MariaDB 10.11 Changes & Improvements

MariaDB 10.11 is a long-term maintenance release series, maintained until February 2028.

Upgrading

• See and .

New Features & Improvements

This list includes features from the short-term releases , , and .

Authentication

• () ()

• Separate and privileges ()

• now accepts a comma-separated list of addresses to bind to ()

• password_reuse_check plugin is a new password validation plugin that prevents the new password from being the same as the one being used during the configurable retention period. (

Optimizer

• Make show time spent in the query optimizer ()

• Improve optimization of joins with many tables, including eq_ref tables (, )

• Table elimination does not work across derived tables (, )

• Histograms in the statistics tables are more precise and stored as JSON, not binary (, ,

Descending Indexes

• Individual columns in the can now be explicitly sorted in the ascending or descending order. This can be useful for optimizing certain cases (, , , , ).

Replication

• Change defaults for CHANGE MASTER TO so that GTID-based replication is used by default if master supports it (, )

• Added system variable for SQL thread to limit maximum execution time per query replicated (, )

• Deprecate to favor new option (, )

• Implement the --do-domain-ids, --ignore-domain-ids, and --ignore-server-ids options for

mysqlbinlog GTID support

• (or mysqlbinlog as it was called back when the task was created) now supports both filtering events by GTID ranges through --start-position and --stop-position, and validating a binary log's ordering of GTIDs through --gtid-strict-mode (, ).

Galera

• Implement a method to add IPs to allowlist for Galera Cluster node addresses that can make SST/IST requests (, )

• JSON file interface to wsrep node state / SST progress logging (, )

JSON

• function (, )

• Implement range notation for (, )

• Support negative index (, )

• function to check for equality between JSON objects (,

UUID

• New (, )

SHOW ANALYZE FORMAT=JSON

• Extend to support SHOW ANALYZE [FORMAT=JSON] (, )

• Add EXPLAIN FOR CONNECTION syntax support to (, )

Information Schema

• Performance Issues reading the ()

• Full table scan in the and tables ()

System versioning

• setting, , to allow history modification ()

• : dump and restore historical data ()

• Add option to as of specified timestamp (, ).

InnoDB

• InnoDB performance improvements (, , , , , , , )

• In bulk insert, pre-sort and build indexes one page at a time (, )

InnoDB Redo Log Improvements

• autosize (, ).

• Improve the for concurrency (, ).

• Remove FIL_PAGE_FILE_FLUSH_LSN (, ).

UCA14 Collation

• Add UCA-14.0.0 (, )

• Improve contraction performance in UCA collations (, )

• Improve UCA collation performance for utf8mb3 and utf8mb4 (, )

Windows

• for mariadb root user, for OS admin users ()

• On newer versions of Windows (Windows 10 1903 or later), the mariadb client defaults to the utf8mb4 character set. Several problems with Unicode input and output in client were fixed. Command line utilities now accept all Unicode characters in user names, database names, file names etc (in the past, characters were restricted to the current ANSI codepage) ().

Spider Storage Engine

• This was mostly internal refactoring work. As a result one can now declare connections using the REMOTE_SERVER, REMOTE_DATABASE, and REMOTE_TABLE attributes and not abuse the COMMENT field for that. This works both for the whole table and per partition (, , ).

Convert Partitions

• ALTER TABLE ... CONVERT PARTITION .. TO TABLE (, ), and

• ALTER TABLE ... CONVERT TABLE ... TO PARTITION ... () as an easy way to convert tables to partitions and back in one command, instead of a sequence of CREATE/EXCHANGE/DROP ()

Miscellaneous

• Add function (, )

• The data type (, )

• Re-design the upper level of handling UPDATE and DELETE statements (, )

• Deprecate the / functions (,

Variables

• For a list of all new variables, see .

• Rename variables ()

  • (min_examined_row_limit)

  • (slow_query_log)

InnoDB Variables

• and are now dynamic, and their values can be changed without restarting the server ()

• Removed (, )

• Deprecated ()

• Deprecated ()

Spider Variables

The following deprecated variables have been removed ():

Security Vulnerabilities Fixed in

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

• :

• :

• :

• :

List of All Releases