MariaDB 10.5.0 Release Notes
The most recent release of MariaDB 10.5 is:
MariaDB 10.5.27 Stable (GA) Download Now
Alternate download from mariadb.org
Download Release Notes Changelog Overview of 10.5
Release date: 3 Dec 2019
MariaDB 10.5 is the current development series of MariaDB. It is an evolution of MariaDB 10.4 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.
MariaDB 10.5.0 is an Alpha release.
Do not use alpha releases in production!
For an overview of MariaDB 10.5 see the What is MariaDB 10.5? page.
Thanks, and enjoy MariaDB!
Notable Changes
This is the first alpha release in the MariaDB 10.5 series.
Notable changes of this release include:
INET 6 Data Type
Syntax
- INSERT ... RETURNING (MDEV-10014)
- REPLACE ... RETURNING (MDEV-10014)
- EXCEPT ALL and INTERSECT ALL (MDEV-18844)
- Database comments in CREATE DATABASE and ALTER DATABASE statements (MDEV-307)
- Setup default partitions for system versioning (MDEV-19903)
- Fix REFERENCES constraint in column definition (MDEV-20729)
JSON
- JSON_ARRAYAGG
- JSON_OBJECTAGG
- Add information about packed addon fields in ANALYZE FORMAT=JSON (MDEV-21838)
S3 Storage Engine
- S3 Storage Engine, a read-only storage engine that stores its data in Amazon S3 (MDEV-17841)
Thread Pool
- Information Schema tables (THREADPOOL_GROUPS, THREADPOOL_QUEUES and THREADPOOL_STATS) for internals of generic threadpool (MDEV-19313)
InnoDB
- innodb_adaptive_hash_index now defaults to
OFF(MDEV-20487) - innodb_checksum_algorithm now defaults to
full_crc32(MDEV-19534) - innodb_checksums has been removed (MDEV-19534)
- innodb_log_checksums has been deprecated (MDEV-19543)
- innodb_locks_unsafe_for_binlog has been removed (MDEV-19544)
- innodb_stats_sample_pages has been removed (MDEV-19551)
- innodb_undo_logs has been deprecated (MDEV-19570)
- innodb_rollback_segments has been removed (MDEV-19570)
- Set innodb_log_files_in_group=1 by default (MDEV-20907)
- Extend SHOW STATUS LIKE 'Innodb_%' (MDEV-18582)
- Clean up INFORMATION_SCHEMA.INNODB_ tables (MDEV-19940)
- Doublewrite buffer is unnecessarily used for newly (re)initialized pages (MDEV-19738)
- Defer change buffer merge until pages are requested (MDEV-19514)
InnoDB Refactoring
- Remove buf_page_t::newest_modification (MDEV-21132)
- Replace recv_sys_t::addr_hash with a std::map (MDEV-19586)
- Obsolete internal parser for FK in InnoDB (MDEV-20480)
- InnoDB thread pool for background tasks (MDEV-16264)
Binary Log
- Extended binlog metadata (MDEV-20477)
Query Optimizer
- ANALYZE for statements is improved, now it also shows the time spent checking the WHERE clause and doing other auxiliary operations (MDEV-20854)
- Inferred IS NOT NULL predicates can be used by the range optimizer (MDEV-15777)
Galera
- Galera 4 Inconsistency voting (MDEV-17048)
General
- The Information Schema SYSTEM_VARIABLES Table has a new column showing from which config file a variable derives its value (MDEV-12684)
- Switch Perl DBI scripts from DBD::mysql to DBD::MariaDB driver (MDEV-19755)
- The Aria max key length is now 2000 bytes, compared to 1000 bytes in MyISAM.
Do not use alpha releases in production!
Changelog
For a complete list of changes made in MariaDB 10.5.0, with links to detailed information on each push, see the changelog.
Contributors
For a full list of contributors to MariaDB 10.5.0, see the MariaDB Foundation release announcement.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More
information can be found on the
Distributions which Include MariaDB
page.
