MariaDB 11.4 Changes & Improvements

MariaDB 11.4 is a current long-term series, maintained until May 2029.

Upgrading

• See and .

New Features

This list includes all features since the previous long-term release, (those introduced in the , and short-term releases, and the rolling release).

Optimizer

• Major improvements to the Optimizer. See .

• for single-table / statements. Update and delete statements that use subqueries can now use all subquery optimization strategies that MariaDB offers, so now if you use subqueries in UPDATE or DELETE, these statements will likely be much faster (, )

• Queries with the or functions comparing against a constant can now make use of indexes, so these will be noticeably quicker in certain instances. For example SELECT * FROM t2 WHERE YEAR(a) = 2019 or SELECT * FROM t2 WHERE DATE(a) <= '2017-01-01'

InnoDB

• Shrink without restart by setting the system variable. (, )

• The is now shrunk by reclaiming unused space at startup (, )

Online Schema Change

• can now do most operations with ALGORITHM=COPY, LOCK=NONE, that is, in most cases, unless the algorithm and lock level are explicitly specified, ALTER TABLE will be performed using the algorithm while simultaneously allowing concurrent on the altered table. ()

For more information, refer to, .

Replication and Binary Log

• writing speed was improved by moving checksum calculations out of the global binlog mutex (). The system variable is available if the old behavior is desired. This is a contribution by Kristian Nielsen

• New system variable enables binary log purging when the total size of all binary logs exceeds the specified threshold. The implementation is based on the patch from Percona ()

• New system variable disables binary log purging until the number of connected slaves reaches the specified threshold ().

SSL/TLS

• is now enabled in the server by default. No configuration necessary, if no server certificate was provided a self-signed certificate will be automatically generated by the server. See for details ().

• Clients now can validate self-signed server certificates if the or authentication is used and account password is not empty ().

• Clients now require SSL and have enabled by default ().

JSON

• now allows retrieval of the key when iterating on JSON objects (, )

• New functions , and to check for JSON intersection (, )

• extracts key/value pairs from a JSON object (, )

Data Types

• It is now possible to create on tables that contain (, )

• data types can now be cast into types (, )

• This means INET4 values can be compared with INET6 values and can be inserted into INET6 columns; the server can automatically convert INET4 value into INET6 as needed ()

Backup and Restore

• New option, -j, --parallel= for increased parallelism, specifies the number of dump table jobs executed in parallel (only for use with the --tab option). Also added to , with --use-threads as a synonym. ()

• mode has been deprecated (, )

Application-Time Periods

• Add views for in information_schema (), in particular

• New view

• New view

• New columns IS_SYSTEM_TIME_PERIOD_START and IS_SYSTEM_TIME_PERIOD_END

Sys Schema

• New view shows granted privileges broken down by table on which they allow access and level on which they were granted. For example, if a user x has SELECT privilege granted ON db.*, this view will list all tables in the db schema with the user x having SELECT privilege on them. This is different from , which only lists privileges granted on the table level ()

Partitioning

• and now support the WITH VALIDATION and WITHOUT VALIDATION clauses. If neither is specified, the default behavior is WITH VALIDATION ()

Collations

From :

• 44 new added. These are aliases for MySQL collations to make it easier to replicate from MySQL to MariaDB ()

  • The includes a new column, COMMENT which contains information about which collation the alias refers to.

Connection Redirection

• Added a using the system variable (, )

• At the moment client-side support is missing

Privileges

• Add a new database-level , SHOW CREATE ROUTINE that allows one to see the routine definition even if the user isn't the routine owner (, )

Spider

• The preferred way to specify is to use the dedicated Spider table options (implemented in ). Abusing the table COMMENT clause is now deprecated ()

• The storage engine now supports table options instead of having to encode them in COMMENT/CONNECTION strings. When any table option is specified, Spider will ignore COMMENT/CONNECTION strings at the same table/partition/subpartition. A new variable is introduced to ignore them globally at all levels (table/partition/subpartition). Another variable, , is introduced to suppress warnings when Spider ignores COMMENT/CONNECTION strings. (, )

Miscellaneous Functions

• function now supports conversion up to base 62 ()

• Values generated by the Key Derivation Function are resistant against password hashing generators, so are good for strongly hashed passwords ()

• Given a time in picoseconds, the new function returns a human-readable time value and unit indicator (, )

Date and Time

• function can now print the current time zone abbreviation and current time zone offset from UTC with %Z and %z format specifiers. (, )

Processlist

• Added a SENT_ROWS column to the table, as well as extended the display size for the columns in processlist to ensure that most results will fit in display (, )

Miscellaneous

• Added support for packages () outside of ()

• Setting a non-default value will now always issue a deprecation warning (, )

• enhancement (, )

• Temporary tables are now displayed in the ,

Variables

• For a list of all new variables, see .

Removed

• Remove thr_alarm from server codebase

  • Includes removal of the system variable ()

• In addition, the following deprecated features and system 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