Changes and Improvements in MariaDB 10.10

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

New Features & Improvements

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

List of All MariaDB 10.10 Releases