Changes and Improvements in MariaDB 10.6
You are viewing an old version of this article. View
the current version here.
The most recent release of MariaDB 10.6 is:
MariaDB 10.6.20 Stable (GA) Download Now
Alternate download from mariadb.org
Register now for our MariaDB Community Server 10.6 webinar to be held 2021-06-29 and be one of the first to see the biggest features coming in MariaDB Community Server 10.6, with an exclusive opportunity to have your questions answered by MariaDB engineering and product leads.
Contents
MariaDB 10.6 is the current major development version. MariaDB 10.5 is stable and feature-complete, so major new features to be developed are going into 10.6.
Do not use non-stable (non-GA) releases in production!
New Features & Improvements
Atomic DDL
- 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).
SQL Syntax
- Implement SQL-standard SELECT ... OFFSET ... FETCH (MDEV-23908)
- Add SELECT ... SKIP LOCKED syntax (InnoDB only) (MDEV-13115)
- Indexes can be ignored (MDEV-7317, MDEV-25075)
- JSON_TABLE, used to extract JSON data based on a JSON path expression and to return it as a relational table (MDEV-17399)
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)
- ROWNUM function returns the current number of accepted rows in the current context (MDEV-24089)
InnoDB
- Optimization to speed up inserts into an empty table (MDEV-515)
- 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
innodbchecksum is no longer supported, onlycrc32. Removed the*innodband*noneoptions from innodb_checksum_algorithm, and the--strict-check/-Cand--write/-woptions from innochecksum (MDEV-25105)
Replication, Galera and Binlog
- Increase master_host limit to 255, user to 128 (MDEV-24312)
- 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)
- The delay between binary log purges can now be specified with much greater precision. The system variable binlog_expire_logs_seconds is introduced as a form of alias for expire_logs_days, which now accepts a precision of 1/1000000 days (MDEV-19371)
- Allow transition from unencrypted to TLS Galera cluster communication without cluster downtime (MDEV-22131)
Sys Schema
- Bundle sys-schema, a collection of views, functions and procedures to help administrators get insight into database usage. (MDEV-9077)
Performance Schema
- Merged replication instrumentation and tables (MDEV-16437, MDEV-20220)
Storage Engines
- TokuDB has been removed (MDEV-19780)
- CassandraSE has been removed (MDEV-23024)
Character Sets
- The
utf8character set (and related collations) is now by default an alias forutf8mb3rather than the other way around. It can be set to implyutf8mb4by changing the value of the old_mode system variable (MDEV-8334)
General
- Bundle sys schema (MDEV-9077)
- 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)
Variables
- For a list of all new variables, see System Variables Added in MariaDB 10.6 and Status Variables Added in MariaDB 10.6.
- max_recursive_iterations has been reduced to 1000 (MDEV-17239)
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_lock_schedule_algorithm
- 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_sync_array_size
- innodb_thread_concurrency
- innodb_thread_sleep_delay
- innodb_undo_logs
Security Vulnerabilities Fixed in MariaDB 10.6
For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the Security Vulnerabilities Fixed in MariaDB page.
- CVE-2024-21096: MariaDB 10.6.18
- CVE-2023-5157: MariaDB 10.6.9
- CVE-2023-22084: MariaDB 10.6.16
- CVE-2022-47015: MariaDB 10.6.13
- CVE-2022-38791: MariaDB 10.6.9
- CVE-2022-32091: MariaDB 10.6.9
- CVE-2022-32089: MariaDB 10.6.9
- CVE-2022-32088: MariaDB 10.6.8
- CVE-2022-32087: MariaDB 10.6.8
- CVE-2022-32086: MariaDB 10.6.8
- CVE-2022-32085: MariaDB 10.6.8
- CVE-2022-32084: MariaDB 10.6.9
- CVE-2022-32083: MariaDB 10.6.8
- CVE-2022-32082: MariaDB 10.6.9
- CVE-2022-32081: MariaDB 10.6.9
- CVE-2022-31624: MariaDB 10.6.5
- CVE-2022-27458: MariaDB 10.6.8
- CVE-2022-27457: MariaDB 10.6.8
- CVE-2022-27456: MariaDB 10.6.8
- CVE-2022-27455: MariaDB 10.6.8
- CVE-2022-27452: MariaDB 10.6.8
- CVE-2022-27451: MariaDB 10.6.8
- CVE-2022-27449: MariaDB 10.6.8
- CVE-2022-27448: MariaDB 10.6.8
- CVE-2022-27447: MariaDB 10.6.8
- CVE-2022-27446: MariaDB 10.6.8
- CVE-2022-27445: MariaDB 10.6.8
- CVE-2022-27444: MariaDB 10.6.8
- CVE-2022-27387: MariaDB 10.6.8
- CVE-2022-27386: MariaDB 10.6.8
- CVE-2022-27385: MariaDB 10.6.5
- CVE-2022-27384: MariaDB 10.6.8
- CVE-2022-27383: MariaDB 10.6.8
- CVE-2022-27382: MariaDB 10.6.8
- CVE-2022-27381: MariaDB 10.6.8
- CVE-2022-27380: MariaDB 10.6.8
- CVE-2022-27379: MariaDB 10.6.8
- CVE-2022-27378: MariaDB 10.6.8
- CVE-2022-27377: MariaDB 10.6.8
- CVE-2022-27376: MariaDB 10.6.8
- CVE-2022-24052: MariaDB 10.6.6
- CVE-2022-24051: MariaDB 10.6.6
- CVE-2022-24050: MariaDB 10.6.6
- CVE-2022-24048: MariaDB 10.6.6
- CVE-2022-21595: MariaDB 10.6.6
- CVE-2022-0778: MariaDB 10.6.6
- CVE-2021-46669: MariaDB 10.6.8
- CVE-2021-46668: MariaDB 10.6.7
- CVE-2021-46667: MariaDB 10.6.5
- CVE-2021-46665: MariaDB 10.6.7
- CVE-2021-46664: MariaDB 10.6.7
- CVE-2021-46663: MariaDB 10.6.7
- CVE-2021-46662: MariaDB 10.6.5
- CVE-2021-46661: MariaDB 10.6.7
- CVE-2021-46659: MariaDB 10.6.6
- CVE-2021-46658: MariaDB 10.6.3
- CVE-2021-35604: MariaDB 10.6.3
- CVE-2021-2389: MariaDB 10.6.4 [2]
- CVE-2021-2372: MariaDB 10.6.4 [2]
- CVE-2018-25032: MariaDB 10.6.9
List of All MariaDB 10.6 Releases
| Date | Release | Status | Release Notes | Changelog |
|---|---|---|---|---|
| 18 Jun 2021 | MariaDB 10.6.2 | RC | Release Notes | Changelog |
| 21 May 2021 | MariaDB 10.6.1 | Beta | Release Notes | Changelog |
| 26 Apr 2021 | MariaDB 10.6.0 | Alpha | Release Notes | Changelog |
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
