MariaDB 12.0 is a . It is an evolution of with several entirely new features.

New Features

Security

• Support for passphrase protected keys ()

  • variable

• New statement for performing actions as another user ()

Data types

• Comparison (stored_func(),1)=ROW(1,1) erroneously called stored_func() twice per row. It led to a performance degradation, as well as to a double execution of the possible stored function side effects. ()

Stored Routines

• Add support for the pre-defined weak SYS_REFCURSOR ()

  • system variable limits the number of opened at the same time

Server

• Add the FM format to , which suppresses following padding ()

• and now support ()

Optimizer

• optimization can now be applied for reverse-ordered scans ()

• optimization can now applied for reverse-ordered scans ()

• Loose Index Scan ("Use index for group-by") optimization can now use indexes with DESC key parts ()

Optimizer hints

• Add support for ()

GIS

New functions. These functions improve compatibility with MySQL 8.

• ()

• ()

• ()

Trigger

• Add support for TRIGGERS that fire on multiple events ()

Replication

• Server displays if it was started with the option ()

• has been added as a system variable (previously it was just an option). It determines whether to show the user and password in (SHOW SLAVE HOSTS) on the primary.

• system variable added (previously it was just an option), which permits not skipping events having our server id.

Galera

• In , needless foreign key checks during Incremental State Transfers are now avoided ()

Audit Plugin

• The now logs HOST:PORT of incoming connections instead of just the host ()

• Added tls_version field for connection audit plugins ()

Configuration

• Get option group suffix from $MARIADB_GROUP_SUFFIX in addition to $MYSQL_GROUP_SUFFIX ()

mariadb Client

• Can set an alternative directory path for searching scripts invoked via the source command, with the mariadb client option ()

Variables

For a list of all new variables, see .

Removed

• , deprecated in

• , deprecated in

• , deprecated in .

List of All MariaDB 12.0 Releases

_{This page is licensed: CC BY-SA / Gnu FDL}

Download Release Notes Changelog Overview of 12.0

^{Alternate download from mariadb.org}

Release date: 7 Aug 2025

MariaDB 12.0.2 is a Stable (GA) release. It is an evolution of MariaDB 11.8 with several entirely new features.

MariaDB 12.0 is a rolling release. One is expected to upgrade to MariaDB 12.1.2, there will be no 12.0.3.

Thanks, and enjoy MariaDB!

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

InnoDB

• After SET GLOBAL innodb_buffer_pool_size was aborted while attempting to shrink the buffer pool, executing SET GLOBAL innodb_adaptive_hash_index=ON could lead to corruption of the adaptive hash index. ()

• Fatal InnoDB error: Unknown error Temp file write failure ()

• When innodb_buffer_pool_size is being shrunk while there are no data pages cached, InnoDB could hang or crash. ()

Aria

• Assertion when adding FK to MyISAM/Aria table with a vector index ()

Data Definition - Alter Table

• Adding (with ALTER TABLE) a UNIQUE constraint that is USING HASH to a table with foreign keys could've caused the table to become corrupted. ()

• DROP DEFAULT makes SHOW CREATE non-idempotent ()

Partitioning

• Server crashes in do_mark_index_columns instead of ER_DUP_ENTRY on partitioned table ()

• A replica would crash while replicating UPDATE and DELETE DML statements that target a table which previously had a partition that was converted to a separate table via ALTER TABLE .. CONVERT PARTITION .. TO TABLE. For example, if the command looked like ALTER TABLE t1 CONVERT PARTITION p1 TO TABLE t_new; the replica would crash when trying to update/deleterows in table t1 after running the command. ()

Data Definition - Create Table

• CREATE OR REPLACE with self-referencing CHECK hangs forever, cannot be killed ()

Server

• Segfault on INTERSECT ALL with UNION in Oracle mode ()

• In certain cases privileges on sequences were too restrictive, for example, SELECT on a table might've erroneously required INSERT privilege on a sequences ()

mariabackup

• This commit fixes a bug where Aria tables are used in (master->slave1->slave2) and a backup is taken on slave2. In this case it is possible that the replication position in the backup, stored in mysql.gtid_slave_pos, will be wrong. This will lead to replication errors if one is trying to use the backup as a new slave. ()

• Maria-backup would crash during the 'maria_recovery' part. This could happen if server was doing repair or creating indexes while the backup was running. ()

Optimizer

• MariaDB server crash when a query includes a derived table containing unnamed column. ()

• Crash in add_keyuses_for_splitting() when joining with a derived table ()

• Split Materialized code: last_refills is never set in 11.0+ ()

JSON

• Starting from 10.11.12, Incorrect handling of UTF-8 characters (and other character sets requiring more than a single byte representation) in the minimum/maximum positions of a table during the execution of ANALYZE TABLE tbl PERSISTENT FOR ALL resulted in an endless loop consuming more memory and prevented the server from terminating. ()

Galera

• updated to 26.4.23

• galera_3nodes.inconsistency_shutdown test occasionally hangs ()

• Galera-26.4.23 corrects an incompatibility with OpenZFS >= 2.3.0 enabling the use of galera on this filesystem.

Replication

• semi sync makes the master unresponsive when a replica is stopped ()

• parallel slave ALTER-SEQUNCE attempted to binlog out-of-order ()

• mysqldump --dump-slave always starts stopped slave ()

Stored routines

• Crash when calling stored function in FOR loop argument ()

Authentication and Privilege System

• ALTER TABLE require ALTER privilege on sequence from DEFAULT value expression ()

Locking

• Deadlock does not rollback transaction fully ()

Data Manipulation - Insert

• UNIQUE constraint that was USING HASH and UNIQUE constrant WITHOUT OVERLAPS could be violated under heavy load in READ COMMITTED transaction isolation mode. ()

Character Sets

• Changing the server character set in my.cnf could cause debian-start script to fail with "Illegal mix of collations" ().

Plugin - AWS key management

• aws_key_management compilation was previously broken, is now fixed. plugin can be compiled again. As before, -DNOT_FOR_DISTRIBUTION=ON is necessary to build it. ()

Packaging

• mariadb systemd mult-instance service was changed to not attempt changes to the permissions on its pam helper server. This prevented unconstructive behaviour and errors in the systemd journal when starting the mariadb@.service. ()

Sequences

• Remove the error codes added to 10.11 by the MDEV-36032 patch ()

XA

• DML committed within XA transaction block after deadlock error and implicit rollback ()

General

• Add option to not collect statistics for long char/varchars ()

• Packages for RHEL8 no longer depend on liburing. The RHEL8 kernel had insufficient kernel support so linking was an unneeded dependency. libaio was sufficient ()

• SLES 15 SP6 and SLES 15 SP7 are new packages in this release. Because of incompatibilities of packages between SLES service pack versions there are now separate packages for 15sp6 and 15sp7. An upgradeable repo file should include "sles/$releasever/$basearch" rather than the "sles15-amd64" or "sles/15/x86_64" path that may exist currently. (, )

Changelog

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

_{This page is licensed: CC BY-SA / Gnu FDL}

Release date: 5 Jun 2025

is a . It is an evolution of with several entirely new features.

MariaDB 12.0.1 is a release.

Thanks, and enjoy MariaDB!

Notable Items

Security

• Support for passphrase protected keys ()

• New SET SESSION AUTHORIZATION ()

• Implement SHA2 support for file_key_management.so plugin (TDE) ()

Data types

• Comparison ROW(stored_func(),1)=ROW(1,1) erroneously called stored_func() twice per row. It led to a performance degradation, as well as to a double execution of the possible stored function side effects. ()

Stored Routines

• Add support for the pre-defined weak SYS_REFCURSOR ()

Server

• TO_CHAR FM format not recognized in SQL_MODE=Oracle ()

• Support mariadb-check and CHECK TABLE with SEQUENCE ()

Optimizer

• find_order_in_list mismatch when order item needs fixing() ()

• If the join_condition is specified via USING (column_list), the query plan depends on the sequence of tables in the query ()

• Add support for optimizer hints ()

GIS

New GIS functions. These functions improve compatibility with MySQL 8.

• ()

• ()

• ()

Trigger

• Add support for TRIGGERS that fire on multiple events ()

Replication

• Server now displays if it was started with option ()

Galera

• Skip FK checks in Galera during applying in IST ()

Audit Plugin

• Log HOST:PORT of incoming connection instead of just the host ()

• Add tls_version field for connection audit plugins ()

Configuration

• Get option group suffix from $MARIADB_GROUP_SUFFIX in addition to $MYSQL_GROUP_SUFFIX ()

Clients and Scripts

• Can set an alternative directory path for searching scripts invoked via the source command, with the --script-dir mariadb client option ()

Changelog

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

Contributors

For a full list of contributors to MariaDB 12.0.1, see the .

_{This page is licensed: CC BY-SA / Gnu FDL}