Learn about Centmin Mod LEMP Stack today
Become a Member

MariaDB What's New In MariaDB 10.5 ?

Discussion in 'MariaDB & General MySQL news & discussions' started by eva2000, Jun 30, 2020.

Tags:
  1. eva2000

    eva2000 Administrator Staff Member

    54,647
    12,230
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,799
    Local Time:
    1:57 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Just like MariaDB 10.4, MariaDB 10.5 major version release has more new features which further move MariaDB MySQL away from being drop in compatible with Oracle MySQL servers. MariaDB 10.5.4 marks first GA stable release. Centmin Mod 123.09beta01 and higher will eventually add MariaDB 10.5 support as optional upgrade once private testing is done. Similarly to how MariaDB 10.1, 10.2, 10.3, 10.4 upgrade support was added. But for now Centmin Mod will default to MariaDB 10.3 default.

    Here's a run down of what's new in MariaDB 10.5 from What’s New in MariaDB Server 10.5?

    MariaDB 10.5 just uses MariaDB 10.4 InnoDB engine which differs from MariaDB 10.3 and below.
    Yup mysql binary alias for mariadb service and binaries are no more

     
  2. eva2000

    eva2000 Administrator Staff Member

    54,647
    12,230
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,799
    Local Time:
    1:57 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Had a quick look at what MariaDB variables have deprecated in MariaDB 10.5 and they are as follows:
    • innodb_adaptive_max_sleep_delay (Deprecated: MariaDB 10.5.5)
    • innodb_background_scrub_data_check_interval (Deprecated: MariaDB 10.5.2)
    • innodb_background_scrub_data_compressed (Deprecated: MariaDB 10.5.2)
    • innodb_background_scrub_data_interval (Deprecated: MariaDB 10.5.2)
    • innodb_background_scrub_data_uncompressed (Deprecated: MariaDB 10.5.2)
    • innodb_buffer_pool_instances (Deprecated: MariaDB 10.5.1)
    • innodb_commit_concurrency (Deprecated: MariaDB 10.5.5)
    • innodb_concurrency_tickets (Deprecated: MariaDB 10.5.5)
    • innodb_log_checksums (Deprecated: MariaDB 10.5.0)
    • innodb_log_compressed_pages (Deprecated: MariaDB 10.5.3)
    • innodb_log_files_in_group (Deprecated: MariaDB 10.5.2)
    • innodb_log_optimize_ddl (Deprecated: MariaDB 10.5.1)
    • innodb_page_cleaners (Deprecated: MariaDB 10.5.1)
    • innodb_replication_delay (Deprecated: MariaDB 10.5.5)
    • innodb_scrub_log (Deprecated: MariaDB 10.5.2)
    • innodb_scrub_log_speed (Deprecated: MariaDB 10.5.2)
    • innodb_thread_concurrency (Deprecated: MariaDB 10.5.5)
    • innodb_thread_sleep_delay (Deprecated: MariaDB 10.5.5)
    • innodb_undo_logs (Deprecated: MariaDB 10.5.0)
     
  3. rdan

    rdan Well-Known Member

    5,446
    1,408
    113
    May 25, 2014
    Ratings:
    +2,201
    Local Time:
    11:57 AM
    Mainline
    10.2
    Is there any variable I can set to default install 10.5?
    I would like to try it with PHP 8.0 RC3 also.

    Thanks Eva.
     
  4. eva2000

    eva2000 Administrator Staff Member

    54,647
    12,230
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,799
    Local Time:
    1:57 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Not yet haven't had time to test/develop MariaDB 10.5 support in Centmin Mod 123.09beta01 right now. Will be some time given MariaDB 10.4 issues with performance which aren't fixed with MariaDB 10.5 for some either.
     
  5. Xon

    Xon Active Member

    173
    61
    28
    Nov 16, 2015
    Ratings:
    +229
    Local Time:
    11:57 AM
    1.15.x
    MariaDB 10.3.x
  6. eva2000

    eva2000 Administrator Staff Member

    54,647
    12,230
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,799
    Local Time:
    1:57 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    That's good to know as it's already set by default in MariaDB 10.4 upgrades at least.