MariaDB 11.7.0 Release Notes

Download Release Notes Overview of 11.7

Release date: 25 Sep 2024

MariaDB 11.7 is a rolling release. It is an evolution of MariaDB 11.6 with several entirely new features.

MariaDB 11.7.0 is a single preview release. Features are to be considered preview, and none are guaranteed to make it into MariaDB 11.7.

The preview is available as a container quay.io/mariadb-foundation/mariadb-devel:11.7-preview.

Thanks, and enjoy MariaDB!

Notable Items

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 ()

GIS

New GIS functions. These functions improve compatibility with MySQL 8. Note that these were not included in

• ()

• ()

• ()

• ()

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 ()

Vectors

• ()

[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 ()