MariaDB 11.5.0 Release Notes
The most recent release of MariaDB 11.5 is:MariaDB 11.5.2 Stable (GA) Download Now
Download 11.5.0Release NotesChangelogOverview of 11.5
Release date: 18 March 2024
Do not use alpha releases in production!
MariaDB 11.5 is an upcoming development series of MariaDB. It is an evolution of MariaDB 11.4 with several entirely new features.
MariaDB 11.5.0 is a single preview release. Features are to be considered preview, and none are guaranteed to make it into MariaDB 11.5.
The preview is available as a container quay.io/mariadb-foundation/mariadb-devel:11.5-preview.
For an overview of MariaDB 11.5 see theWhat is MariaDB 11.5? page.
Thanks, and enjoy MariaDB!
New Features
Temporary files and tables
There are two system variables used for controlling this feature:
max_tmp_space_usage: Limits the the temporary space allowance per user
max_total_tmp_space_usage: Limits the temporary space allowance for all users.
Data Types
The TIMESTAMP range of values was extended. The maximal allowed value for timestamps was '2038-01-19 03:14:07 UTC', and is now '2106-02-07 06:28:15 UTC'. This does not change the storage format, and new tables can be read by old MariaDB servers as long as timestamp values are within the old timestamp range. At the moment this is only supported on 64-bit platforms (MDEV-32188).
Optimizer
Index condition pushdown is now supported for partitioned tables (MDEV-12404)
ANALYZE FORMAT=JSON now shows selectivity of pushed index condition (MDEV-18478)
Protocol
Permit bulk implementation to return ALL individual results (MDEV-30366)
Send initial values of system variables in first OK packet (MDEV-31609)
Observability
New USERS table in the Information Schema for storing information about users, password expiry, and the limits set by max_password_errors (MDEV-23729, MDEV-32218)
Add more columns to Information Schema TABLE_STATISTICS, CLIENT_STATISTICS and USER STATISTICS tables (MDEV-33151)
Add QUERIES column to Information Schema INDEX_STATISTICS table (MDEV-33152)
Provide InnoDB async IO statistics (MDEV-32841)
Including a number of status variables.
Show variable deprecation for mariadbd --help output (MDEV-28671)
Extend Query Response Time plugin to be compatible with Percona server (MDEV-33501)
New variable, log_slow_always_query_time for additional control over what is logged to the slow query log. This setting did not make it into MariaDB 11.5, but was added in MariaDB 11.7 (MDEV-33144)
Additional features for Sequences (MDEV-28152)
CREATE SEQUENCE ... AS permits creating as any INT type (including BIGINT UNSIGNED), extending the range
Other
Deprecate and ignore the alter_algorithm system variable (MDEV-33655)
Change default Unicode collation to uca1400_ai_ci, a modern Unicode collation with proper support for SMP characters (including emoji)(MDEV-25829)
Parallel dump of multiple databases via mariadb-dump with the
--dir
option (MDEV-33625)Deprecate spider_casual_read (MDEV-31789)
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?