MariaDB 11.5 is an old rolling release and is no longer maintained. Please use a more recent release.

Upgrading

• See and .

New Features

Temporary files and tables

• ()

• There are two system variables used for controlling this feature:

  • : Limits the temporary space allowance per user

  • : Limits the temporary space allowance for all users.

Data Types

• The 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 ().

Optimizer

• is now supported for partitioned tables ()

• ANALYZE for statement should show selectivity of pushed index condition ()

Protocol

• Permit bulk implementation to return ALL individual results ()

• Send initial values of system variables in first OK packet ()

Observability

• New in the Information Schema for storing information about users, , and the limits set by (, )

• Add more columns to Information Schema , and tables ()

• Add QUERIES column to Information Schema table ()

• Additional features for Sequences ()

  • permits creating as any type (including ), extending the range

  • Parser accepts larger and smaller values for and

Other

• ()

• Deprecate and ignore the system variable ()

• Change to uca1400_ai_ci, a modern Unicode collation with proper support for SMP characters (including emoji)()

• Parallel dump of multiple databases via with the --dir

Removed Features

The following deprecated features have been removed:

• ... COMPRESSED...

  • the correct syntax is COMPRESSED... ...

• (and the related variable).

Variables

• For a list of all new variables, see and .

Security Vulnerabilities Fixed in

For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the page. Add listcve macro here - removed for performance reasons

List of All Releases

Download Release Notes Changelog Overview of 11.5

Release date: 30 May 2024

MariaDB 11.5 is a development version of the MariaDB rolling release. It is an evolution of MariaDB 11.4 with several entirely new features.

MariaDB 11.5.1 is a Release Candidate (RC) release.

Thanks, and enjoy MariaDB!

New Features

Temporary files and tables

• ()

• There are two system variables used for controlling this feature:

  • : Limits the temporary space allowance per user.

  • : Limits the temporary space allowance for all users.

Data Types

• The 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 ().

Optimizer

• is now supported for partitioned tables ()

• ANALYZE FORMAT=JSON now ()

Protocol

• Permit bulk implementation to return ALL individual results ()

• Send initial values of system variables in first OK packet ()

Observability

• New in the Information Schema for storing information about users, , and the limits set by (, )

• Add more columns to Information Schema , and tables ()

• Add QUERIES column to Information Schema table ()

• Additional features for Sequences ()

  • permits creating as any type (including ), extending the range

  • Parser accepts larger and smaller values for and

Other

• ()

• Introduce the system variable to address excessive context switching caused by log_sys.lsn_lock (observed on write-intensive workloads on NUMA systems) ()

• Deprecate and ignore the system variable ()

• Change default Unicode collation to uca1400_ai_ci ()

Security

• Fixes for the following :

  • CVE-`-```

Changelog

For a complete list of changes made in , with links to detailed information on each push, see the .

Contributors

For a full list of contributors to , see the .

Release date: 18 March 2024

is an upcoming development series of MariaDB. It is an evolution of with several entirely new features.

is a single preview release. Features are to be considered preview, and none are guaranteed to make it into .

The preview is available as a container quay.io/mariadb-foundation/mariadb-devel:11.5-preview.

Thanks, and enjoy MariaDB!

Download Release Notes Changelog Overview of 11.5

Release date: 14 Aug 2024

MariaDB 11.5.2 is a Stable (GA) release. It is an evolution of MariaDB 11.4 with several entirely new features.

MariaDB 11.5 is a rolling release. One is expected to upgrade to MariaDB 11.6.2, there will be no 11.5.3.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

InnoDB

• now builds indexes more efficiently ()

  • Unsetting the system variable restores the old behavior.

• Fix unexpected storage read IO for the redo log, reintroduce ()

• Correctly terminate transaction early with ER_LOCK_TABLE_FULL when lock memory is growing (

Aria

• Fix index corruption when doing a REPAIR TABLE that has a size of over 4G ()

Spider

• UBSAN: runtime error: applying non-zero offset in spider_free_mem and SIGSEGV in spider_free_mem on SELECT ()

• SIGSEGV in ha_resolve_storage_engine_name, UBSAN: runtime error: index 4294967295 out of bounds for type 'st_plugin_int *[64]' ()

• SIGSEGV in spider_db_conn::fin_loop_check, and ASAN: heap-use-after-free in

Partitioning

• SIGSEGV in parse_engine_part_options on INSERT, SELECT or ALTER ()

• Assertion ``auto_increment_value'failed inha_partition::info` on INSERT into MEMORY table ()

Character Sets

• On startup: UBSAN: applying zero offset to null pointer in my_copy_fix_mb from strings/ctype-mb.c and other locations ()

• On startup: UBSAN: runtime error: applying zero offset to null pointer in skip_trailing_space and my_hash_sort_utf8mb3_general1400_nopad_as_ci ()

• SHOW CREATE DATABASE statement crashes the server when db name contains some unicode characters, ASAN stack-buffer-overflow (

Optimizer

• On startup: UBSAN: runtime error: applying non-zero offset in JOIN::make_aggr_tables_info in sql/sql_select.cc ()

• Crash after killing query while it is processed by test_quick_select ()

• Extend condition normalization to include 'NOT a' ()

• Auto-generated from table no longer breaks replication ()

• Fix replication failure when are used where the replica has set and the client has touched a different database when running DML such as inserts. ()

• Fix replication error when is used in conjunction with a password longer than 41 ascii characters ()

Backup

• Hide password passed on commandline from xtrabackup_info ()

Galera

• updated to 26.4.19

• galera_gtid_2_cluster: Assertion ``thd->wsrep_next_trx_id() != (0x7fffffffffffffffLL * 2ULL + 1)'` ()

• table gtid_slave_pos entries never been deleted with wsrep_gtid_mode = 0 ()

Error Log

• system variable added, and value added to the at startup ()

General

• As per the , this will be the last release of for Debian 10 "Buster", RHEL/CentOS 7, Ubuntu 23.10 "Mantic", and Fedora 38

• Repositories for Ubuntu 24.04 "Noble" have been added

• no longer unnecessarily traverses tablespaces list ()

• Fix unknown variable defaults-group-suffix=

Changelog

For a complete list of changes made in , with links to detailed information on each push, see the .

Contributors

For a full list of contributors to , see the .