Changes and Improvements in MariaDB 10.6

MariaDB 10.6 is the current major development version. There are no releases yet. MariaDB 10.5 is stable and feature-complete, so major new features to be developed will be going into 10.6.

• View the source tree
• Plans for MariaDB 10.6
• 10.6 Features/fixes by vote

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, only crc32. 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)

Storage Engines

• TokuDB has been removed (MDEV-19780)
• CassandraSE has been removed (MDEV-23024)
• CREATE TABLE, ALTER TABLE, RENAME TABLE, DROP TABLE, DROP DATABASE and related DDL statements are now atomic. Either the statement is fully completed or everything is reverted to it's original state. Note that when deleting multiple tables with DROP TABLE, only each individual drop is atomic, not the full list of tables). (MDEV-23842).

Oracle Mode

• 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

• 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)

Variables

• For a list of all new variables, see System Variables Added in MariaDB 10.6 and Status Variables Added in MariaDB 10.6.

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