Changes and Improvements in MariaDB 11.7
The most recent release of MariaDB 11.7 is:
MariaDB 11.7.1 RC Download Now
Alternate download from mariadb.org
Contents
MariaDB 11.7 is a rolling release, and currently in development.
New Features
Vectors
- Vectors are now included in the binaries
- Numerous vector search improvements (MDEV-34939)
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)
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)
[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
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
| Date | Release | Status | Release Notes | Changelog |
|---|---|---|---|---|
| 21 Nov 2024 | MariaDB 11.7.1 | RC | Release Notes | Changelog |
| 25 Sep 2024 | MariaDB 11.7.0 | Alpha | Release Notes |
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
