MariaDB 11.5.1 Release Notes
Note: This page describes features in the source repository for MariaDB 11.5. There are currently no official packages or binaries available for download which contain the features. If you want to try out any of the new features described here you will need to get and compile the code yourself.
Do not use non-stable (non-GA) 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.
For an overview of MariaDB 11.5 see the What is MariaDB 11.5? page.
Thanks, and enjoy MariaDB!
New Features
Temporary files and tables
- Limit size of created disk temporary files and tables (MDEV-9101)
- 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)
- Add FLUSH GLOBAL STATUS (MDEV-33145)
- Provide InnoDB async IO statistics (MDEV-32841)
- Show variable deprecation for mariadbd --help output (MDEV-28671)
- Extend Query Response Time plugin to be compatible with Percona server (MDEV-33501)
Sequences
- Additional features for Sequences (MDEV-28152)
- CREATE SEQUENCE ... AS permits creating as any INT type (including BIGINT UNSIGNED), extending the range
- Information Schema Sequences table
- Parser accepts larger and smaller values for MINVALUE and MAXVALUE
Other
- REPAIR TABLE ... FORCE (MDEV-33449)
- Deprecate and ignore the alter_algorithm system variable (MDEV-33655)
- Change default Unicode collation to uca1400_ai_ci (MDEV-25829)
- Parallel dump of multiple databases via mariadb-dump with the
--dir
option (MDEV-33625) - Deprecate spider_casual_read (MDEV-31789)
Changelog
For a complete list of changes made in MariaDB 11.5.1, with links to detailed information on each push, see the changelog.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More
information can be found on the
Distributions which Include MariaDB
page.