MariaDB 10.5 Changes & Improvements

MariaDB 10.5 is no longer maintained. Please use a more recent release.

MariaDB 10.5 is a previous major release series. The first stable release was in June 2020, and it was maintained until June 2025.

Upgrading

• See and .

Implemented Features

See the page for items that are different between MariaDB Community Server 10.5 and MariaDB Enterprise Server 10.5.

ColumnStore

• This release of MariaDB Server includes the storage engine. Note, that plugins have and MariaDB ColumnStore in 10.5.4 has Beta maturity.

Binaries Named mariadb (mysql Symlinked)

• All binaries previously beginning with mysql now begin with mariadb, with symlinks for the corresponding mysql command. ()

• When starting the MariaDB server via the systemd service it will be started using the mariadbd binary name, so this will now show up in the system process list instead of mysqld

INET 6 Data Type

• New data type for storing IPv6 addresses ()

Amazon S3

• The allows one to archive MariaDB tables in Amazon S3, or any third-party public or private cloud that implements S3 API ( )

• Both S3 tables and S3 tables are discoverable. This means that if you create a partitioned S3 table, both the partitioned table and its partitions can be directly used by another server that has access to the S3 storage. ()

Privileges Made More Granular

• Split SUPER to smaller privileges (). New privileges were added so that more fine grained tuning of what each user can do can be applied:

InnoDB: Performance Improvements etc.

• Extend LIKE 'Innodb_%' ()

• Clean up tables ()

• Doublewrite buffer is unnecessarily used for newly (re)initialized pages ()

• Defer change buffer merge until pages are requested ()

InnoDB New Defaults for Variables

• now defaults to OFF ()

• now defaults to full_crc32 ()

InnoDB Removed or Deprecated Variables

• ()

• ()

• ()

Performance Schema Updates to Match MySQL 5.7 Instrumentation and Tables

• Memory ()

• Meta data locking (MDL) ()

• Prepared statements (ps) ()

• [show] status instrumentation and tables ()

Galera: Full GTID Support

• Add full support to cluster (). With this feature all nodes in a cluster will have the same GTID for replicated events originating from the cluster. Also added a new variable, wsrep_gtid_seq_no, to manually update the WSREP GTID sequence number in the cluster (similar to how the gtid_seq_no variable is used for non-WSREP transactions).

• Add new mode to wsrep_OSU_method in which Galera checks storage engine of the affected table ()

• Galera: Replicate MariaDB GTID to other nodes in the cluster ()

Binary Log and Replication: More Metadata

• now defaults to optimistic ().

• Make REPLICA a synonym for ()

• ENFORCE option for ()

Syntax

• () - returns SELECT of inserted rows (analogous to )

• ()

• and ()

• Application period tables: ()

JSON

• Added . This returns a JSON array containing an element for each value in a given set of JSON or SQL values. It acts on a column or an expression that evaluates to a single value.

• Added . This returns a JSON object containing key-value pairs. It takes two expressions that evaluate to a single value, or two column names, as arguments, the first used as a key, and the second as a value.

Thread Pool

• Information Schema tables (, , and ) for internals of generic thread_pool ().

Performance Improvements

• Speed up binary row logging code

• Range optimizer speedups. Removed double calls to records_in_range() for some cases.

• Costs for using MEMORY tables updated to be more accurate

• Fixed that 'ref' access is preferred over 'range' for the same index.

Query Optimizer

• Improve Protocol performance for numeric data by avoiding unnecessary character string conversions (, )

• is improved, now it also shows the time spent checking the WHERE clause and doing other auxiliary operations ()

• ()

• Allow packed sort keys and values of non-sorted fields in the sort buffer ( &

General

• The has a new column showing from which config file a variable derives its value ()

• Switch Perl DBI scripts from DBD::mysql to DBD::MariaDB driver ()

• The max key length is now 2000 bytes, compared to 1000 bytes in .

• now reliably deletes table remnants inside a storage engine even if the .frm file is missing ()

PCRE (Perl Compatible Regular Expressions)

• Migrate to (), a newer version of the pcre library.

Variables

• For a list of all new variables, see and .

• The has a new column showing from which config file a variable derives its value ().

• Port from MySQL 5.6 (). If set, old temporal data types (created with a pre-10.0 version of MariaDB) are displayed with a /* mariadb-5.3 */ comment.

• Numerous deprecated variables removed ()

Security Vulnerabilities Fixed in

For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the page.

• :

• :

• :

• :

Resources

• (video presentation by Sergei Golubchik)

List of All Releases