MariaDB 11.7 Changes & Improvements

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

MariaDB 11.7 is a rolling release.

New Features

Vectors

• are now included in the binaries

• Numerous improvements ()

Replication and Binary Log

• When is enabled, committing a large transaction no longer freezes all other transactions until completed ()

• has been deprecated ()

• Async rollback prepared transactions during binlog crash recovery ()

• New variable, , for aborting long-running queries on a replica ()

UUID

• New function for generating version 4 UUIDs ()

• New function for generating version 7 UUIDs ()

Optimization

• Optimization improvement for single-table UPDATE/DELETE: make cost-based choice between subquery strategies ()

• The is now on by default ()

System-Versioned Tables

• Allow a to be converted from implicit to explicit row_start/row_end columns ()

Slow Query Log

• New variable, , for specifying that all queries longer than this time are logged to the , regardless of and ()

Stored Routines

• ROW data type for stored function return values ()

Derived Tables

• Add optional correlation column list for ()

[SHOW] CREATE SERVER

• Implement ()

• Allow arbitrary options in ()

General

• , which used to be an alias for now shows the value of when the session was created ()

• CURRENT_TIMESTAMP should return a TIMESTAMP (WITH TIME ZONE?) ()

• A warning has been added when is exceeded. ()

Deprecated Variables

• ()

Spider

• The Spider variables and have been deprecated ()

List of All Releases