MariaDB 10.6.0 Release Notes
The most recent release of MariaDB 10.6 is:
MariaDB 10.6.20 Stable (GA) Download Now
Alternate download from mariadb.org
Note: This page describes features in the source repository for MariaDB 10.6. There are currently no official packages or binaries available for download which contain the features. If you want to try out any of the new features described here you will need to get and compile the code yourself.
MariaDB 10.6 is the current development series of MariaDB. It is an evolution of MariaDB 10.5 with several entirely new features.
MariaDB 10.6.0 will be an Alpha release.
For an overview of MariaDB 10.6 see the What is MariaDB 10.6? page.
Thanks, and enjoy MariaDB!
Notable Changes
This will be the first alpha release in the MariaDB 10.6 series.
Notable changes of this release include:
Storage Engines
- TokuDB has been removed (MDEV-19780)
- CassandraSE has been removed (MDEV-23024)
InnoDB
- Make InnoDB's COMPRESSED row format read-only by default (MDEV-23497)
- Information Schema SYS_TABLESPACES now directly reflects the filesystem, and SYS_DATAFILES has been removed (MDEV-22343)
- Defer writes to the InnoDB temporary tablespace (MDEV-12227)
- The old MariaDB 5.5-compatible
innodb
checksum is no longer supported, onlycrc32
. Removed the*innodb
and*none
options from innodb_checksum_algorithm, and the--strict-check
/-C
and--write
/-w
options from innochecksum (MDEV-25105)
Galera
- The wsrep_mode system variable, for turning on WSREP features which are not part of default behavior (including the experimental Aria replication) (MDEV-20008, MDEV-20715, MDEV-24946)
Oracle Compatibility
- Anonymous subqueries in a FROM clause (no AS clause) are permitted in ORACLE mode (MDEV-19162)
- ADD_MONTHS() added (MDEV-20025)
- TO_CHAR() added (MDEV-20017)
- SYS_GUID() added (MDEV-24285)
- MINUS is mapped to EXCEPT in UNION (MDEV-20021)
- Oracle
rownum
syntax added. (MDEV-24089)
General
- Bundle sys schema (MDEV-9077)
- Add binlog_expire_logs_seconds for more granular purging of binary logs (MDEV-19371)
- ROWNUM function returns the current number of accepted rows in the current context (MDEV-24089)
- Do not resend unchanged resultset metadata for prepared statements (MDEV-19237)
- --bind-address=hostname now listens on both IPv6 and IPv4 addresses (MDEV-6536)
- Support systemd socket activation (MDEV-5536)
- For the GSSAPI plugin, support AD or local group name, and SIDs on Windows (MDEV-23959)
- Check for $MARIADB_HOME/my.cnf (MDEV-21365)
- max_recursive_iterations has been reduced to 1000 (MDEV-17239)
- Server system variables for negative values no-longer means the maximum value (MDEV-22219)
Galera
- wsrep_mode variable for turning on WSREP features which are not part of default behavior.
- wsrep_strict_ddl has been deprecated. Use wsrep_mode=STRICT_REPLICATION instead.
InnoDB Variables
The following deprecated variables have been removed (MDEV-23397):
- innodb_adaptive_max_sleep_delay
- innodb_background_scrub_data_check_interval
- innodb_background_scrub_data_compressed
- innodb_background_scrub_data_interval
- innodb_background_scrub_data_uncompressed
- innodb_buffer_pool_instances
- innodb_commit_concurrency
- innodb_concurrency_tickets
- innodb_file_format
- innodb_large_prefix
- innodb_log_checksums
- innodb_log_compressed_pages
- innodb_log_files_in_group
- innodb_log_optimize_ddl
- innodb_page_cleaners
- innodb_replication_delay
- innodb_scrub_log
- innodb_scrub_log_speed
- innodb_thread_concurrency
- innodb_thread_sleep_delay
- innodb_undo_logs
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.