MariaDB 13.0 Changes & Improvements

An overview of changes, improvements, and what's new in MariaDB Community Server 13.0

The most recent release of MariaDB 13.0 is:

MariaDB 13.0.0 Preview Download Now

MariaDB 13.0 is a rolling release. It is an evolution of MariaDB 12.3 with several entirely new features.

New Features

• Add support for TYPE .. IS REF CURSOR (MDEV-10152)

• One can specify timestamp format for the audit plugin log (MDEV-18386)

• Atomic CREATE OR REPLACE TABLE (MDEV-25292)

• INFORMATON_SCHEMA.SYSTEM_VARIABLES shows if a variable is deprecated (MDEV-35369)

• INFORMATON_SCHEMA.STATISTICS and INFORMATON_SCHEMA.COLUMNS shows engine specific create options (MDEV-36444)

• Optimizer Trace includes used optimizer statistics (MDEV-36511)

• New innodb_log_archive variable makes InnoDB to preserve WAL instead of overwriting it in a ring buffer (MDEV-37949)

• New QB_NAME() optimizer hint (MDEV-38045)

• Support RECORD in routine parameters and function RETURN clause (MDEV-38768)

• Reversed executable comments (MDEV-7381)

Notable Items

• CHANGE MASTER now resets Master_Server_Id in SHOW SLAVES STATUS (MDEV-15327)

• Faster unique indexes over CHAR columns in MEMORY tables (incl. temporary tables) (MDEV-21543)

• PERFORMANCE_SCHEMA now uses XXH3_128 hash for digest. Looks like MD5, but much faster and no problems in FIPS mode. (MDEV-31669)

• binlog_row_event_max_size default value was increased to 64k (MDEV-37608)

• default_master_connection can now be set on global level (MDEV-9247)

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