Changes and Improvements in MariaDB 11.7

MariaDB 11.7 is a rolling release, and currently in development.

New Features

Replication and Binary Log

• When binlogging is enabled, committing a large transaction no longer freezes all other transactions until completed (MDEV-32014)
• binlog_optimize_thread_scheduling has been deprecated (MDEV-33756)
• Async rollback prepared transactions during binlog crash recovery (MDEV-33853)
• New variable, slave_abort_blocking_timeout, for aborting long-running queries on a replica (MDEV-34857)

UUID

• New function for generating version 4 UUIDs UUID_v4 (MDEV-11339)
• New function for generating version 7 UUIDs UUID_v7 (MDEV-32637)

Optimization

• Optimization improvement for single-table UPDATE/DELETE: make cost-based choice between subquery strategies (MDEV-25008)
• The Charset Narrowing Optimization is now on by default (MDEV-34380)

GIS

New GIS functions. These functions improve compatibility with MySQL 8.

• ST_Validate (MDEV-34137)
• MBRCoveredBy (MDEV-34138)
• ST_Simplify (MDEV-34141)
• ST_GeoHash (MDEV-34158)
• ST_LatFromGeoHash (MDEV-34159)
• ST_LongFromGeoHash (MDEV-34160)
• ST_IsValid (MDEV-34276)
• ST_Collect (MDEV-34278)

System-Versioned Tables

• Allow a system-versioned table to be converted from implicit to explicit row_start/row_end columns (MDEV-27293)

Slow Query Log

• New variable, log_slow_always_query_time, for specifying that all queries longer than this time are logged to the slow query log, regardless of log_slow_min_examined_row_limit and log_slow_rate_limit (MDEV-33144)

Stored Routines

• ROW data type for stored function return values (MDEV-12252)

Derived Tables

• Add optional correlation column list for derived tables (MDEV-31466)

Vectors

• Various vector search improvements (MDEV-34939)

[SHOW] CREATE SERVER

• Implement SHOW CREATE SERVER (MDEV-15696)
• Allow arbitrary options in CREATE SERVER (MDEV-34716)

General

• SESSION_USER(), which used to be an alias for USER() now shows the value of CURRENT_USER() when the session was created (MDEV-30908)
• CURRENT_TIMESTAMP should return a TIMESTAMP (WITH TIME ZONE?) (MDEV-15751)
• A warning has been added when max_sort_length is exceeded. (MDEV-27277)

Deprecated Variables

• binlog_optimize_thread_scheduling (MDEV-33756)

Spider

• The Spider variables spider_table_crd_thread_count and spider_table_sts_thread_count have been deprecated (MDEV-28009)

List of All MariaDB 11.7 Releases