Changes and Improvements in MariaDB 11.5
You are viewing an old version of this article. View
the current version here.
The most recent release of MariaDB 11.5 is:
MariaDB 11.5.2 Download Now
Alternate download from mariadb.org
Contents
MariaDB 11.5 is a rolling release, and is currently in development.
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 for statement should show 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)
- New variable, log_slow_always_query_time for additional control over what is logged to the slow query log. (MDEV-33144)
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
- ANALYZE TABLE on sequences no longer attempts to collect statistics (MDEV-33938)
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)
Removed Features
The following deprecated features have been removed:
- <data type> <character set clause> ... COMPRESSED...
- the correct syntax is <data type> COMPRESSED... <character set clause> ...
- wsrep_load_data_splitting
- integer latches in OQGraph (and the related oqgraph_allow_create_integer_latch variable).
Variables
- For a list of all new variables, see System Variables Added in MariaDB 11.5 and Status Variables Added in MariaDB 11.5.
List of All MariaDB 11.5 Releases
Date | Release | Status | Release Notes | Changelog |
---|---|---|---|---|
14 Aug 2024 | MariaDB 11.5.2 | Stable (GA) | Release Notes | Changelog |
30 May 2024 | MariaDB 11.5.1 | RC | Release Notes | Changelog |
18 Mar 2024 | MariaDB 11.5.0 | Alpha | Release Notes |
Comments
Comments loading...
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.