Changes and Improvements in MariaDB 10.10

MariaDB 10.10 is no longer maintained. Please use a more recent release.

The most recent release of MariaDB 10.10 is:MariaDB 10.10.7 Stable (GA) Download Now

MariaDB 10.10 is a short-term release series, maintained until November 2023.

Upgrading

• See Upgrading Between Major MariaDB Versions and Upgrading from MariaDB 10.9 to MariaDB 10.10.

New Features & Improvements

Variables

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

and Status Variables Added in MariaDB 10.10.

Replication

• Change defaults for CHANGE MASTER TO so that GTID-based replication is used by default if master supports it (MDEV-19801)

• Added global.slave_max_statement_time system variable for SQL thread to limit maximum execution time per query replicated (MDEV-27161)

• Deprecate MASTER_USE_GTID=Current_Pos to favor new MASTER_DEMOTE_TO_SLAVE option (MDEV-20122)

Optimizer

• Improve optimization of joins with many tables, including eq_ref tables (MDEV-28852)

• Table elimination does not work across derived tables (MDEV-26278)

UCA14 Collation

• Add UCA-14.0.0 collations (MDEV-27009)

• Improve contraction performance in UCA collations (MDEV-27265)

• Improve UCA collation performance for utf8mb3 and utf8mb4 (MDEV-27266)

Galera

• Implement a method to add IPs to allowlist for Galera Cluster node addresses that can make SST/IST requests (MDEV-27246)

Miscellaneous

• Change default of explicit_defaults_for_timestamp to ON (MDEV-28632)

• --ssl option set as default for mariadb CLI (MDEV-27105)

• Add RANDOM_BYTES function (MDEV-25704)

• The INET4 data type (MDEV-23287)

• Re-design the upper level of handling UPDATE and DELETE statements (MDEV-28883)

• Deprecate the DES_ENCRYPT/DECRYPT functions (MDEV-27104)

Variables

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

InnoDB

• Removed innodb_version (MDEV-28554)

• Deprecated innodb_prefix_index_cluster_optimization

Spider

The following deprecated variables have been removed:

• spider_udf_ct_bulk_insert_interval

• spider_udf_ct_bulk_insert_rows

• spider_udf_ds_bulk_insert_rows

• spider_udf_ds_table_loop_mode

• spider_udf_ds_use_real_table

• spider_use_handle

• spider_udf_table_mon_mutex_count

• spider_use_handler

Security Vulnerabilities Fixed in MariaDB 10.10

For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the Security Vulnerabilities Fixed in MariaDB page.

• CVE-2023-22084: MariaDB 10.10.7

• CVE-2022-47015: MariaDB 10.10.4

List of All MariaDB 10.10 Releases

Date	Release	Status	Release Notes	Changelog
Date	Release	Status	Release Notes	Changelog
13 Nov 2023	MariaDB 10.10.7	Stable (GA)	Release Notes	Changelog
14 Aug 2023	MariaDB 10.10.6	Stable (GA)	Release Notes	Changelog
7 Jun 2023	MariaDB 10.10.5	Stable (GA)	Release Notes	Changelog
10 May 2023	MariaDB 10.10.4	Stable (GA)	Release Notes	Changelog
6 Feb 2023	MariaDB 10.10.3	Stable (GA)	Release Notes	Changelog
17 Nov 2022	MariaDB 10.10.2	Stable (GA)	Release Notes	Changelog
22 Aug 2022	MariaDB 10.10.1	RC	Release Notes	Changelog
23 Jun 2022	MariaDB 10.10.0	Alpha	Release Notes