MariaDB 12.0 Changes & Improvements

The most recent release of MariaDB 12.0 is:

MariaDB 12.0.2 Stable (GA) Download Now

_{Alternate download from mariadb.org}

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

  • ssl_passphrase system variable

• New statement SET SESSION AUTHORIZATION for performing actions as another user (MDEV-20299)

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

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. (MDEV-36322)

Stored Routines

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

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

Server

• Add the FM format to TO_CHAR, which suppresses following padding (MDEV-36216)

• mariadb-check and CHECK TABLE now support SEQUENCE tables (MDEV-22491)

Optimizer

• find_order_in_list mismatch when order item needs fixing() (MDEV-36607)

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

• Add support for optimizer hints (MDEV-35504)

  • QB_NAME

  • NO_RANGE_OPTIMIZATION

  • NO_ICP

  • MRR, NO_MRR

  • BKA, NO_BKA

  • BNL, NO_BNL

• Add support for subquery optimizer hints (MDEV-34888)

  • SEMIJOIN

  • SUBQUERY

• Add support for join order hints (MDEV-34870)

  • JOIN_FIXED_ORDER similar to existing STRAIGHT_JOIN hint

  • JOIN_ORDER to apply the specified table order

  • JOIN_PREFIX to hint what tables should be first in the join

  • JOIN_SUFFIX to hint what tables should be last in the join

• Add support for the MAX_EXECUTION_TIME hint (MDEV-34860)

GIS

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

• ST_Validate (MDEV-34137)

• MBRCoveredBy (MDEV-34138)

• ST_Simplify (MDEV-34141)

• ST_GeoHash (MDEV-34158)

• ST_LatFromGeoHash (MDEV-34159)

• ST_LongFromGeoHash (MDEV-34160)

• ST_PointFromGeoHash (MDEV-34277)

• ST_IsValid (MDEV-34276)

• ST_Collect (MDEV-34278)

Trigger

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

Replication

• Server displays if it was started with the skip-slave-start option (MDEV-27669)

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

• replicate_same_server_id 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 (MDEV-36099)

  • create_tmp_table_binlog_formats system variable.

Galera

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

Audit Plugin

• The Audit Plugin now logs HOST:PORT of incoming connections instead of just the host (MDEV-1282)

• Added tls_version field for connection audit plugins (MDEV-33834)

Configuration

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

mariadb Client

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

Variables

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

Removed

• big_tables, deprecated in MariaDB 10.5.0

• large_page_size, deprecated in MariaDB 10.5.3

• storage_engine, deprecated in MariaDB 5.5.

List of All MariaDB 12.0 Releases

Date	Release	Status	Release Notes	Changelog
7 Aug 2025	MariaDB 12.0.2	GA	Release Notes	Changelog
5 Jun 2025	MariaDB 12.0.1	RC	Release Notes	Changelog
26 March 2025	MariaDB 12.0.0	Preview

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