MariaDB 11.1.5 Release Notes

The most recent release of MariaDB 11.1 is:MariaDB 11.1.6 Stable (GA) Download NowAlternate download from mariadb.org

Download 11.1.5 | Release Notes | Changelog | Overview of 11.1

Release date: 16 May 2024

MariaDB 11.1 is a current short-term stable series of MariaDB and will be maintained until August 2024. It is an evolution of MariaDB 11.0 with several entirely new features.

MariaDB 11.1.5 is a Stable (GA) release.

For an overview of MariaDB 11.1 see theWhat is MariaDB 11.1? page.

Thanks, and enjoy MariaDB!

Notable Items

From this version, the tool adds a new command to the top of every dump file. This command cannot be interpreted by MariaDB command line client versions that do not have the sandbox command, or by MySQL command line clients, and an error will be generated in these clients. Other methods of importing the dump will work not have this issue.

Storage Engines

InnoDB

• Introduce the system variable to address excessive context switching caused by log_sys.lsn_lock (observed on write-intensive workloads on NUMA systems) ()

• Fix InnoDB holding shared dict_sys.latch while waiting for FOREIGN KEY child table lock on DDL ()

• Fix adaptive hash index corruption after ()

• Server no longer aborts while altering an InnoDB statistics table (

• Fixed that internal temporary tables did not wait for freed disk space, and related issues ()

• Fix wrong result on 2nd execution of prepared statement for query with derived table ()

• Improve Spider performance by pushing down function () and statement () to data nodes

• Fix server crash when deleting partitions from a table with spider engine ()

• SPIDER plugin initialization no longer fails at 'create table if not exists mysql.spider_tables ... with 'Specified key was too long; max key length is 1000 bytes', Warning: Memory not freed: 10720 ()

Backup

• Port backup features from Enterprise Server. This adds support for to , and obsoletes the and options ()

• now preserves ()

• Fix problem on older mariadb (opendir(NULL)) caused by ()

,

• Fixed improper application of COLLATE to non-character columns ()

• Default charset now works with PHP MySQLi extension ()

• Fixed Bad SEPARATOR value in on character set conversion ()

• Fixed out of range error in (()) due to a wrong data type (

JSON

• View created via now returns correct json object ()

• now detects the type of String Values and correctly returns Date/DateTime values ()

• no longer returns NULL on valid arguments ()

• no longer returns multiple values for same path ()

Encryption, TLS, SSL

• WolfSSL's math is unnecessarily slow ()

Optimization & Tuning

• Server crashes in JOIN_CACHE::write_record_data upon EXPLAIN with subqueries and constant tables ()

• Wrong result with cross Join given join order ()

• Wrong warnings on 2-nd execution of PS for query with GROUP_CONCAT ()

• Wrong result with semi-join and splittable derived table ()

Plugins

• The now reports the user and host in all cases ()

Replication

• --gtid-ignore-duplicate can double-apply event in case of parallel replication retry ()

• Deadlock kill of XA PREPARE can break replication / rpl.rpl_parallel_multi_domain_xa sporadic failure ()

• mysql_manager_submit Segfault at Startup Still Possible During Recovery ()

• Server crash in Rows_log_event::update_sequence upon replaying binary log ()

Galera

• updated to 26.4.18

  • NOTE: Includes increasing the GCS protocol version, which prevents downgrades of individual nodes in the cluster as soon as all nodes have been updated

• Disallow bulk insert operation during partition update statement ()

SQL, Data Definition, and Data Manipulation

• Transportable Tablespaces no longer leave in a mismatched state ()

• Fix wrong row targeted with "insert ... on duplicate" and "replace", leading to data corruption ()

• Fix incorrect DEFAULT expression evaluated in ()

• Fix server crash when UPDATE statement with duplicate key is run after setting a low thread_stack ()

Platforms & Packaging

• MariaDB-client community can't be installed in red hat ubi9 ()

General

Scripts & Clients

• It's now possible to disable system commands with the option. ()

• now exports the data with sandbox mode enable, so that the mariadb client will not execute potentially dangerous cli commands.()

• commands such as mariadb-dump --dump-slave=2 --master-data=2 now record both positions ()

Server

• Moving from to 10.6 mysql_upgrade is not updating some system tables ()

• Original IP not shown in network related error messages when proxy_protocol is in use ()

• Server incorrectly describes known variables as UNKNOWN if invalid values are specified at startup ()

• update case insensitive (large) unique key with insensitive change of value - duplicate key ()

Security

• Fixes for the following :

Changelog

For a complete list of changes made in , with links to detailed information on each push, see the .

Contributors

For a full list of contributors to , see the .