MariaDB 12.0 Changes & Improvements

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

New Features

Security

• Support for passphrase protected keys ()

  • variable

• New statement for performing actions as another user ()

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

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 ()

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

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.

• Ensure that creation and usage of temporary tables in replication is predictable (

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