1 of 100

Old MariaDB Community Server Releases

Old release notes for MariaDB Community Server releases

Release Notes - MariaDB 11.7 Rolling Releases

MariaDB 11.7 was a rolling release, and is no longer maintained.

MariaDB 11.7 Changes & Improvements

MariaDB 11.7 is no longer maintained. Please use a more recent release.

MariaDB 11.7 is a rolling release.

New Features

Vectors

are now included in the binaries
Numerous improvements ()

Replication and Binary Log

When is enabled, committing a large transaction no longer freezes all other transactions until completed ()
has been deprecated ()
Async rollback prepared transactions during binlog crash recovery ()
New variable, , for aborting long-running queries on a replica ()

UUID

New function for generating version 4 UUIDs ()
New function for generating version 7 UUIDs ()

Optimization

Optimization improvement for single-table UPDATE/DELETE: make cost-based choice between subquery strategies ()
The is now on by default ()

System-Versioned Tables

Allow a to be converted from implicit to explicit row_start/row_end columns ()

Slow Query Log

New variable, , for specifying that all queries longer than this time are logged to the , regardless of and ()

Stored Routines

ROW data type for stored function return values ()

Derived Tables

Add optional correlation column list for ()

[SHOW] CREATE SERVER

Implement ()
Allow arbitrary options in ()

General

, which used to be an alias for now shows the value of when the session was created ()
CURRENT_TIMESTAMP should return a TIMESTAMP (WITH TIME ZONE?) ()
A warning has been added when is exceeded. ()

Deprecated Variables

()

Spider

The Spider variables and have been deprecated ()

List of All Releases

Date

Release

Status

Release Notes

Changelog

MariaDB 11.7.2 Release Notes

Download Release Notes Changelog Overview of 11.7

Release date: 13 Feb 2025

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

MariaDB 11.7 is a rolling release. One is expected to upgrade to MariaDB 11.8.2, there will be no 11.7.3.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

Fix possible InnoDB hang while running out of buffer pool ()
Fix assertion failure on cascading foreign key update of table with vcol index in parent ()
Fix potential issue in secondary Index with ROW_FORMAT=COMPRESSED and Change buffering enabled ()
Fix issue where ON UPDATE SET NULL could not be specified on a NOT NULL column ()

Fix possible crash on DELETE from a HEAP table ()

Fix possible Spider thread hang in 'Update' state on 2nd INSERT ()
Fix possible crash on bootup in spider_sys_open_table «ext-issue»«», «ext-issue»«» ()

44 new added. These are aliases for MySQL collations to make it easier to replicate from MySQL to MariaDB ()
- The includes a new column, COMMENT which contains information about which collation the alias refers to.
Fix assertion falilure and possible index corruption with unique key and nopad collation without DESC or HASH keys ()

Fix incorrect formatting of timestamp during parsing of a binary log, causing point in time recovery discrepancies ()
can now correctly process more than one logfile when --stop-datetime is specified ()
Setting pseudo_thread_id to a value exceeding 4 bytes previously resulted in truncation when written to the binary log ()

Optimizer

Fix server crash in get_sort_by_table/make_join_statistics after INSERT into a view with ORDER BY ()
Fix failing assertion causing disruption and replication failure ()
Conditions with SP local variables are now pushed into derived table. Previous behaviour caused slow performance and table scans instead of using the pushed down condition ()
NULL-aware materialization with IN predicate and single column no longer skips building sorted Ordered_key structures (

History is now stored on the same partitions on different Galera nodes when system versioning is enabled ()
Fix possible hang or crash during InnoDB purge with HASH indexes during ALTER TABLE ()
EXCHANGE PARTITION now works for tables with unique blobs ()
algorithm = instant can now correctly be used if a table has partitions and one tries to change a column with an index which is not the partitions key. This previously gave the error "ERROR 1846 (0A000): ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY". (

updated to 26.4.21
- NOTE: Includes increasing the GCS protocol version, which prevents downgrades of individual nodes in the cluster as soon as all nodes have been updated
Fix streaming replication transaction crash with innodb_snapshot_isolation ()
Fix sporadic failure of async replication on Galera async replica nodes with parallel replication enabled (

For an authentication with the the password of the CREATE USER statement is now masked in the audit log ()
MariaDB Audit now detects all DCLs forms for masking a password ()

Adding a regular index on a vector column leads to invalid table structure ()
Vector values become zero after / restore, impacting data integrity for vector columns. ()
Server can crash when a SELECT query is including a DISTINCT and ORDER BY, and a vector index is used ()

General

Fix possible crash where server could not construct a geomery object from the input ()
Fix trigger created with "" which is adding rows to another table using "FOR EACH ROW insert into table2(id, name) values (NEW.id, NEW.name);" that did not work correctly when if bulk inserts are used by the application. Only the first row of the bulk insert would be added to the table ()

Security

Fixes for the following :

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 Notes - MariaDB 11.6 Rolling Releases

MariaDB 11.6 was a rolling release, and is no longer maintained.

MariaDB 11.6 Changes & Improvements

is a .

Upgrading

See and .

MariaDB 11.6.0 Vector Release Notes

Release date: 29 July 2024

Vector is a . It is an evolution of with several entirely new features.

Vector is a preview release intended to highlight early work on Vectors. Features are to be considered preview, and will not be a part of .

It is available as a source download only from the download site, and is available as a container quay.io/mariadb-foundation/mariadb-devel:11.6-preview.

Thanks, and enjoy MariaDB!

MariaDB 11.6.0 Release Notes

Release date: 26 June 2024

is a . 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.6-preview.

Thanks, and enjoy MariaDB!

Release Notes - MariaDB 11.5 Rolling Releases

MariaDB 11.5 was a rolling release, and is no longer maintained.

Release Notes - MariaDB 11.3 Rolling Releases

Release notes for MariaDB 11.3 series

Release Notes - MariaDB 11.2 Series

MariaDB 11.2 was a short-term maintenance series of MariaDB maintained until November 2024

Release Notes - MariaDB 11.1 Series

MariaDB 11.1 was a short-term maintenance series of MariaDB maintained until August 2024

MariaDB 11.1.0 Release Notes

The most recent release of MariaDB 11.1 is:MariaDB 11.1.6 Stable (GA) Download Now Alternate download from mariadb.org

Download | Release Notes | Changelog | Overview of 11.1

Release date: 27 Mar 2023

Do not use alpha releases in production!

MariaDB 11.1 is a current development series of MariaDB, and will be maintained for one year after its Generally Available release. It is an evolution of MariaDB 11.0 with several entirely new features.

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

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

For an overview of see the page.

Thanks, and enjoy MariaDB!

InnoDB

Remove and related parameters ()

Optimizer

for single-table / statements. Update and delete statements that use subqueries can now use all subquery optimization strategies that MariaDB offers, so now if you use subqueries in UPDATE or DELETE, these statements will likely be much faster ()
Queries with the or functions comparing against a constant can now make use of indexes, so these will be noticeably quicker in certain instances. For example SELECT * FROM t2 WHERE YEAR(a) = 2019 or SELECT * FROM t2 WHERE DATE(a) <= '2017-01-01' ()

General

ALTER ONLINE TABLE - not released in the final ()

JSON

function for validating a JSON schema ()

mariadb-backup

Rename xtrabackup_* files to mariadb_backup_* ()

Release Notes - MariaDB 11.0 Series

MariaDB 11.0 was a short-term maintenance series of MariaDB maintained until June 2024

Release Notes - MariaDB 10.10 Series

MariaDB 10.10 was a short-term maintenance series of MariaDB maintained until November 2023

Release Notes - MariaDB 10.9 Series

MariaDB 10.9 was a short-term maintenance stable series of MariaDB maintained until August 2023

MariaDB 10.9.7 Release Notes

The most recent release of is: Stable (GA)

| | |

Release date: 7 Jun 2023

is the current short-term maintenance stable series of MariaDB, August 2023. It is an evolution of with several entirely new features.

is a release.

For an overview of see the page.

Thanks, and enjoy MariaDB!

Release Notes - MariaDB 10.8 Series

MariaDB 10.8 was a short-term maintenance stable series of MariaDB maintained until May 2023

MariaDB 10.8.2 Release notes

The most recent release of is: Stable (GA)

| | |

Release date: 12 Feb 2022

Do not use non-stable (non-GA) releases in production!

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

is a release.

For an overview of see the page.

Thanks, and enjoy MariaDB!

Release Notes - MariaDB 10.7 Series

MariaDB 10.7 was a short-term series of MariaDB maintained until February 2023

MariaDB 10.7.3 Release Notes

The most recent release of is: Stable (GA)

| | |

Release date: 12 Feb 2022

is the current short-term maintenance stable series of MariaDB. It is an evolution of with several entirely new features.

is a release.

For an overview of see the page.

Thanks, and enjoy MariaDB!

Release Notes - MariaDB 10.5 Series

MariaDB 10.5 was a long-term maintenance series of MariaDB maintained until June 2025

MariaDB 11.7.2 Release Notes

Download Release Notes Changelog Overview of 11.7

Release date: 13 Feb 2025

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

MariaDB 11.7 is a rolling release. One is expected to upgrade to MariaDB 11.8.2, there will be no 11.7.3.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

Fix possible InnoDB hang while running out of buffer pool ()
Fix assertion failure on cascading foreign key update of table with vcol index in parent ()
Fix potential issue in secondary Index with ROW_FORMAT=COMPRESSED and Change buffering enabled ()
Fix issue where ON UPDATE SET NULL could not be specified on a NOT NULL column ()

Fix possible crash on DELETE from a HEAP table ()

Fix possible Spider thread hang in 'Update' state on 2nd INSERT ()
Fix possible crash on bootup in spider_sys_open_table «ext-issue»«», «ext-issue»«» ()

44 new added. These are aliases for MySQL collations to make it easier to replicate from MySQL to MariaDB ()
- The includes a new column, COMMENT which contains information about which collation the alias refers to.
Fix assertion falilure and possible index corruption with unique key and nopad collation without DESC or HASH keys ()

Fix incorrect formatting of timestamp during parsing of a binary log, causing point in time recovery discrepancies ()
can now correctly process more than one logfile when --stop-datetime is specified ()
Setting pseudo_thread_id to a value exceeding 4 bytes previously resulted in truncation when written to the binary log ()

Optimizer

Fix server crash in get_sort_by_table/make_join_statistics after INSERT into a view with ORDER BY ()
Fix failing assertion causing disruption and replication failure ()
Conditions with SP local variables are now pushed into derived table. Previous behaviour caused slow performance and table scans instead of using the pushed down condition ()
NULL-aware materialization with IN predicate and single column no longer skips building sorted Ordered_key structures (

History is now stored on the same partitions on different Galera nodes when system versioning is enabled ()
Fix possible hang or crash during InnoDB purge with HASH indexes during ALTER TABLE ()
EXCHANGE PARTITION now works for tables with unique blobs ()
algorithm = instant can now correctly be used if a table has partitions and one tries to change a column with an index which is not the partitions key. This previously gave the error "ERROR 1846 (0A000): ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY". (

updated to 26.4.21
- NOTE: Includes increasing the GCS protocol version, which prevents downgrades of individual nodes in the cluster as soon as all nodes have been updated
Fix streaming replication transaction crash with innodb_snapshot_isolation ()
Fix sporadic failure of async replication on Galera async replica nodes with parallel replication enabled (

For an authentication with the the password of the CREATE USER statement is now masked in the audit log ()
MariaDB Audit now detects all DCLs forms for masking a password ()

Adding a regular index on a vector column leads to invalid table structure ()
Vector values become zero after / restore, impacting data integrity for vector columns. ()
Server can crash when a SELECT query is including a DISTINCT and ORDER BY, and a vector index is used ()

General

Fix possible crash where server could not construct a geomery object from the input ()
Fix trigger created with "" which is adding rows to another table using "FOR EACH ROW insert into table2(id, name) values (NEW.id, NEW.name);" that did not work correctly when if bulk inserts are used by the application. Only the first row of the bulk insert would be added to the table ()

Security

Fixes for the following :

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 .

MariaDB 10.10.2 Release Notes

The most recent release of MariaDB 10.10 is:MariaDB 10.10.7 Stable (GA) Download Now

Download 10.10.2 Release Notes Changelog Overview of 10.10

Release date: 17 Nov 2022

MariaDB 10.10 is a current short-term series of MariaDB, maintained until November 2023. It is an evolution of MariaDB 10.9 with several entirely new features.

MariaDB 10.10.2 is a Stable (GA) release.

For an overview of MariaDB 10.10 see theWhat is MariaDB 10.10? page.

Thanks, and enjoy MariaDB!

Notable Items

SSL

The server no longer tolerates incorrectly configured SSL (). If you have enabled SSL in my.cnf but have not configured it properly (for example, a certificate file is missing), MariaDB used to silently disable SSL, leaving you under impression that everything was fine and connections were secure. Since this release, MariaDB will fail to start if SSL is enabled, but cannot be switched on.

Backup

Assertion on info.page_size failed in xb_delta_open_matching_space ()
locks database for minutes ()

InnoDB

Adaptive hash index ,
MVCC and locking (, , , )
Virtual columns (, )
InnoDB crash recovery fixes ()

Galera

updated to 26.4.13
Galera server crashes after 10.3 > 10.4 upgrade ()
status variable prints 0 as port number if the port is not mentioned in system variable ()

Replication

Minor correction in warning message ()
False replication error-stop of from a non-existing user on primary () in combination with a filtering replica is corrected
replication is mended on a replica that filters system tables ()
XA COMMIT is not binlogged when the has not updated any transaction engine (

Repositories

Beginning with the next release (Q1 2023), our Yum, DNF, and Zypper repositories for Red Hat, Fedora, and SUSE will be migrated to being signed with a new . The key we are migrating to is the same one we already use for our Debian and Ubuntu Repositories.
- The short Key ID is: 0xC74CD1D8
- The long Key ID is: 0xF1656F24C74CD1D8

Docker Official Image

The following changes have been made to the docker.io/library/mariadb container image.

The number of gpg packages has been removed, leaving enough to apt-get update, but dirmngr that would fetch keys has been removed. (inspired by )
The environment variable LANG=C.UTF-8 has been added for those that exec into containers and copy paste UTF8 characters (fixes ).
Adds OCI labels to image (fixes and )

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 .

MariaDB 11.6.1 Release Notes

The most recent release of MariaDB 11.6 is:

Stable (GA)

Download Release Notes Changelog Overview of 11.6

Release date: 14 Aug 2024

Do not use non-stable (non-GA) releases in production!

MariaDB 11.6 is a rolling release. It is an evolution of MariaDB 11.5 with several entirely new features.

MariaDB 11.6.1 is a Release Candidate (RC) release.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

InnoDB

now builds indexes more efficiently ()
- Unsetting the system variable restores the old behavior.
Correctly terminate transaction early with ER_LOCK_TABLE_FULL when lock memory is growing ()
Alter operation on redundant table no longer aborts the server (

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

no longer unnecessarily traverses tablespaces list ()
Fix unknown variable defaults-group-suffix= with ()
no longer hangs on macOS ()

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 .

MariaDB 11.5.2 Release Notes

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 .

MariaDB 10.8.4 Release Notes

The most recent release of MariaDB 10.8 is:MariaDB 10.8.8 Stable (GA) Download Now

Download 10.8.4 | Release Notes | Changelog | Overview of 10.8

Release date: 15 Aug 2022

MariaDB 10.8 is the current short-term maintenance stable series of MariaDB. It is an evolution of MariaDB 10.7 with several entirely new features.

MariaDB 10.8.4 is a Stable (GA) release.

For an overview of MariaDB 10.8 see theWhat is MariaDB 10.8? page.

Thanks, and enjoy MariaDB!

Notable Items

InnoDB

InnoDB corruption due to lack of file locking ()
FULLTEXT search with apostrophe, and mandatory words ()
ALTER TABLE IMPORT TABLESPACE corrupts an encrypted table ()
ALTER TABLE wrong-result fix ()

Replication

is stored in binlog, so that CREATE TABLE on slave would always have the same effect as on master. ()
ER_SLAVE_INCIDENT error is specified now on slave to be seen with SHOW-SLAVE-STATUS ()
INCIDENT_EVENT is no longer binlogged when a being logged transaction can be safely rolledback ()
sequences related row-format events are made to correspond to binlog_row_image ()

Galera

updated to 26.4.12
Possible to write/update with read_only=ON and not a SUPER privilege ()
Node crashes with Transport endpoint is not connected mysqld got signal 6 ()
Galera4 not able to report proper wsrep_incoming_addresses ()

Optimizer

Server crash in JOIN_CACHE::free or in copy_fields ()
- Queries that use DISTINCT and an always-constant function like COLLATION(aggegate_func(...)) could cause a server crash. Note that COLLATION() is a special function - its value is constant even if its argument is not costant.
Crash when using ANY predicand with redundant subquery in GROUP BY clause ()

MariaDB Server SEGV on INSERT .. SELECT ()
- Certain queries in form "INSERT ... SELECT with_aggregate_or_window_func" could cause a crash.
restore_prev_nj_state() doesn't update cur_sj_inner_tables correctly ()

Wrong result with table elimination combined with not_null_range_scan ()
- If one runs with optimizer_switch='not_null_range_scan=on' (which is not enabled by default), a query that does a join and has const tables could produce a wrong result.
Assertion `tmp >= 0' failed in best_access_path ()

Spider

and have been deprecated (, )
Spider's high-availability feature has been deprecated ()

JSON

: extract document fragment into JSON column ()

CONNECT

now supports with ()

General

now also has a session scope, not only global ()
New option, -enable-cleartext-plugin. Option does not do anything, and is for MySQL-compatibility purposes only.
Crash in ()

Security

Fixes for the following :

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 .

MariaDB 10.7.1 Release Notes

The most recent release of MariaDB 10.7 is:MariaDB 10.7.8 Stable (GA) Download Now

Download 10.7.1 | Release Notes | Changelog | Overview of 10.7

Release date: 8 Nov 2021

Do not use non-stable (non-GA) releases in production!

MariaDB 10.7 is the current development series of MariaDB. It is an evolution of MariaDB 10.6 with several entirely new features.

MariaDB 10.7.1 is a Release Candidate (RC) release.

For an overview of MariaDB 10.7 see theWhat is MariaDB 10.7? page.

Thanks, and enjoy MariaDB!

Notable Items

This release includes all features from the preview releases except for the JSON histogram preview feature, which was not ready in time to be included.

Performance Schema

Comments have been added for each table column in the to improve documentation (). For example:

Diagnostics

The property introduced in to identify the affected row has been renamed to the more intuitive ROW_NUMBER (, )

Provider Plugins

Five provider plugins (bzip2, lzma, lz4, lzo, snappy) provide to the server and storage engines (, ).

SFORMAT

function for arbitrary text formatting (, ).

UUID

New (, )

Natural Sort

function (, ).

Convert Partitions

(, ), and
() as an easy way to convert tables to partitions and back in one command, instead of a sequence of CREATE/EXCHANGE/DROP
The redundant PARTITION keyword is now optional in the ()

Password Reuse

The is a new password validation plugin that prevents the new password from being the same as the one being used during the configurable retention period. (, ).

InnoDB

In bulk insert, pre-sort and build indexes one page at a time ()
Linux after kernel version 5.10 has a io-uring regression causing a write to storage to be lost, or not acknowledged. As such will default to 0 (off) until 5.16. If is enabled in your configuration, a warning will be logged, however it will continue with the io-uring enabled, potentially resulting in a hang, or an assertion later. The long term support kernel 5.14.14 we haven't observed failures, and 5.15.0-rc7 failures have been observed, though less frequently. If you have explicitly enabled, and are using watch out for a lack of InnoDB updates followed by a 10 minute timeout. See for details.
ALTER TABLE…IMPORT TABLESPACE fixes (, ,

Replication

Memory hogging on slave by ROW event applier is eliminated ()
mysql --binary-mode now properly handles \\0 in data ()
Fixes race condition between SHOW BINARY LOGS and RESET MASTER ()

Packaging & Misc

Session tracking flag in OK_PACKET ()
Some views force server (and mysqldump) to generate invalid SQL for their definitions ()
function to check for equality between JSON objects ().
function, which recursively sorts keys and removes spaces ()

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 .

Do not use non-stable (non-GA) releases in production!

MariaDB 10.5.26 Release Notes

Download Release Notes Changelog Overview of 10.5

Release date: 8 Aug 2024

MariaDB 10.5 is a previous stable series of MariaDB, maintained until June 2025. It is an evolution of MariaDB 10.4 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.5.26 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

InnoDB

Alter operation on redundant table aborts the server ()
MariaDB crashes with SIGILL because the OS does not support AVX512 ()
InnoDB: Failing assertion: stat_n_leaf_pages > 0 in ha_innobase::estimate_rows_upper_bound ()

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

MariaDB Server crashes with ill-formed partitions ()
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
- NOTE: Includes increasing the GCS protocol version, which prevents downgrades of individual nodes in the cluster as soon as all nodes have been updated
galera_gtid_2_cluster: Assertion ``thd->wsrep_next_trx_id() != (0x7fffffffffffffffLL * 2ULL + 1)'` ()

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", and RHEL/CentOS 7
no longer unnecessarily traverses tablespaces list ()
Fix unknown variable defaults-group-suffix= with ()

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 .

MariaDB 11.1.6 Release Notes

Download | Release Notes | Changelog | Overview of 11.1

Alternate download from mariadb.org

Release date: 8 Aug 2024

MariaDB 11.1 is a short-term stable series of MariaDB and will be maintained until August 2024. It is an evolution of MariaDB 11.0 with several entirely new features.

MariaDB 11.1.6 is a Stable (GA) release.

MariaDB 11.1.6 is the last release of the MariaDB 11.1 release series.

For an overview of MariaDB 11.1 see theWhat is MariaDB 11.1? page.

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

MariaDB Server crashes with ill-formed partitions ()
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
- NOTE: Includes increasing the GCS protocol version, which prevents downgrades of individual nodes in the cluster as soon as all nodes have been updated
galera_gtid_2_cluster: Assertion ``thd->wsrep_next_trx_id() != (0x7fffffffffffffffLL * 2ULL + 1)'` ()

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=

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 .

MariaDB 10.9.2 Release Notes

The most recent release of MariaDB 10.9 is:MariaDB 10.9.8 Stable (GA) Download Now

Download 10.9.2 | Release Notes | Changelog | Overview of 10.9

Release date: 22 Aug 2022

MariaDB 10.9 is a current stable series of MariaDB, maintained until August 2023. It is an evolution of MariaDB 10.8 with several entirely new features.

MariaDB 10.9.2 is a Stable (GA) release.

For an overview of MariaDB 10.9 see theWhat is MariaDB 10.9? page.

Thanks, and enjoy MariaDB!

Notable Items

InnoDB

InnoDB corruption due to lack of file locking ()
with apostrophe, and mandatory words ()
ALTER TABLE IMPORT TABLESPACE corrupts an encrypted table ()
ALTER TABLE wrong-result fix ()

Replication

is stored in binlog, so that CREATE TABLE on slave would always have the same effect as on master. ()
ER_SLAVE_INCIDENT error is specified now on slave to be seen with SHOW-SLAVE-STATUS ()
INCIDENT_EVENT is no longer binlogged when a being logged transaction can be safely rolledback ()
sequences related row-format events are made to correspond to binlog_row_image ()

Galera

updated to 26.4.12
Possible to write/update with read_only=ON and not a SUPER privilege ()
Node crashes with Transport endpoint is not connected mysqld got signal 6 ()
Galera4 not able to report proper wsrep_incoming_addresses ()

Optimizer

Server crash in JOIN_CACHE::free or in copy_fields ()
- Queries that use DISTINCT and an always-constant function like COLLATION(aggegate_func(...)) could cause a server crash. Note that COLLATION() is a special function - its value is constant even if its argument is not costant.
Crash when using ANY predicand with redundant subquery in GROUP BY clause ()

MariaDB Server SEGV on INSERT .. SELECT ()
- Certain queries in form "INSERT ... SELECT with_aggregate_or_window_func" could cause a crash.
restore_prev_nj_state() doesn't update cur_sj_inner_tables correctly ()

Wrong result with table elimination combined with not_null_range_scan ()
- If one runs with optimizer_switch='not_null_range_scan=on' (which is not enabled by default), a query that does a join and has const tables could produce a wrong result.
Assertion `tmp >= 0' failed in best_access_path ()

Spider

The version number now matches the server version (and the system variable removed) ()
and have been deprecated (, )
Spider's high-availability feature has been deprecated ()

JSON

: extract document fragment into JSON column ()

CONNECT

now supports with ()

General

now also has a session scope, not only global ()
New option, -enable-cleartext-plugin. Option does not do anything, and is for MySQL-compatibility purposes only.
Crash in ()

Security

Fixes for the following :

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 .

Crashing on I/O error is unhelpful (MDEV-27593)
SIGSEGV in log_sort_flush_list() in InnoDB crash recovery (MDEV-31354)
InnoDB tables are being flagged as corrupted on an I/O bound server (MDEV-31767)
Duplicate entry allowed into a ()
Server Status is reported in seconds ()
innochecksum dies with Floating point exception ()
Add InnoDB engine information to the ()
Deadlock with 3 concurrent by ()
innodb protection against dual processes accessing data insufficient ()
ER_DUP_KEY in mysql.innodb_table_stats upon RENAME on sequence ()
Assertion ``!strcmp(index->table->name.m_name, "SYS_FOREIGN") || !strcmp(index->table->name.m_name, "SYS_FOREIGN_COLS")'failed inbtr_node_ptr_max_size` ()
InnoDB: Failing assertion: page_type == i_s_page_type[page_type].type_value ()
btr_estimate_n_rows_in_range() accesses unfixed, unlatched page ()
MODIFY COLUMN can break FK constraints, and lead to unrestorable dumps ()
Recovery or backup failure after ()
Assertion 'n & PENDING' failed in fil_space_t::set_needs_flush() ()
fil_node_open_file() releases fil_system.mutex allowing other thread to open its file node ()
ASAN errors in dict_v_col_t::detach upon adding key to virtual column ()
Purge trying to access freed secondary index page ()
Freed data pages are not always being scrubbed ()
InnoDB recovery hangs after reporting corruption ()
!cursor->index->is_committed() in row0ins.cc after update to 10.4.13 from 10.3.21 ()
fails to wait for purge of enough transaction history ()
SET GLOBAL does not free space when no undo logs exist ()
(linear read-ahead) does not work ()
InnoDB recovery and mariadb-backup --prepare fail to report detailed progress ()
fil_ibd_create() may hijack the file handle of an old file ()
recovery results in a corrupted undo log ()
Server freeze due to and ()
Change buffer entries are left behind when freeing a page, causing secondary index corruption when the page is later reused ()
Foreign Key Constraint actions don't affect Virtual Column ()

MariaDB 11.1.2 Release Notes

The most recent release of MariaDB 11.1 is:MariaDB 11.1.6 Stable (GA) Download Now Alternate download from mariadb.org

Download 11.1.2 | Release Notes | Changelog | Overview of 11.1

Release date: 21 Aug 2023

MariaDB 11.1 is a current short-term stable series of MariaDB, maintained until August 2024. It is an evolution of MariaDB 11.0 with several entirely new features.

MariaDB 11.1.2 is a Stable (GA) release.

For an overview of MariaDB 11.1 see theWhat is MariaDB 11.1? page.

Thanks, and enjoy MariaDB!

Notable Items

Localization

Create Swahili ()

Upgrading from MySQL

MariaDB now detects and converts previously incompatible MySQL partition schemes ()

General

As per the , this will be the last release of for Ubuntu 18.04 LTS "Bionic" and Ubuntu 22.10 "Kinetic"
In this release repositories for Debian 12 "Bookworm" have been added.
doesn't ignore error as it should ()
280 Bytes lost in mysys/array.c, mysys/hash.c, sql/sp.cc, sql/sp.cc, sql/item_create.cc, sql/item_create.cc, sql/sql_yacc.yy:10748 when using oracle sql_mode ()

Character Sets, Data Types

UBSAN: null pointer passed as argument 1, which is declared to never be null in my_strnncoll_binary on SELECT ... COUNT or GROUP_CONCAT ()
Possibly wrong result or Assertion 0' failed in Item_func_round::native_op` ()
Assertion ``(length % 4) == 0'failed in

InnoDB

Crashing on I/O error is unhelpful ()
SIGSEGV in log_sort_flush_list() in InnoDB crash recovery ()
InnoDB tables are being flagged as corrupted on an I/O bound server ()
Duplicate entry allowed into a (

Aria

Various crashes upon INSERT/UPDATE after changing settings ()
Various crashes/asserts/corruptions when Aria encryption is enabled/used, but the encryption plugin is not loaded ()

Spider

SIGSEGV in spider_db_open_item_field and SIGSEGV in spider_db_print_item_type, on SELECT ()
that double as table params overriding mechanism is buggy ()

Optimizer

InnoDB engine statistics for each table ()
Assertion ``last_key_entry >= end_pos'failed in virtual boolJOIN_CACHE_HASHED::put_record()` ()
Problem with open ranges on prefix blobs keys ()
Equal on two

Replication

Parallel Slave SQL Thread Can Update Seconds_Behind_Master with Active Workers ()
ends up in optimistic parallel slave binlog out-of-order ()
takes very long time on a busy system ()
On slave fail to return an error in read-only mode ()

Galera

Node never returns from Donor/Desynced to Synced when wsrep_mode = BF_ABORT_mariadb-backup ()
Node has been dropped from the cluster on Startup / Shutdown with async replica ()
KILL QUERY maintains nodes data consistency but breaks GTID sequence ()
Assertion failure

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 .

MariaDB 10.10.6 Release Notes

The most recent release of MariaDB 10.10 is:MariaDB 10.10.7 Stable (GA) Download Now

Download 10.10.6 Release Notes Changelog Overview of 10.10

Release date: 14 Aug 2023

MariaDB 10.10 is a previous short-term maintenance stable series of MariaDB, maintained until November 2023. It is an evolution of MariaDB 10.9 with several entirely new features.

MariaDB 10.10.6 is a Stable (GA) release.

For an overview of MariaDB 10.10 see theWhat is MariaDB 10.10? page.

Thanks, and enjoy MariaDB!

Notable Items

Upgrading from MySQL

MariaDB now detects and converts previously incompatible MySQL partition schemes ()

General

As per the , this will be the last release of for Ubuntu 18.04 LTS "Bionic" and Ubuntu 22.10 "Kinetic"
doesn't ignore error as it should ()
280 Bytes lost in mysys/array.c, mysys/hash.c, sql/sp.cc, sql/sp.cc, sql/item_create.cc, sql/item_create.cc, sql/sql_yacc.yy:10748 when using oracle sql_mode ()
SQL/PL package body does not appear in I_S.ROUTINES.ROUTINE_DEFINITION

Character Sets, Data Types

version >= 6 are now stored without byte-swapping, UUIDs with version >=8 and variant=0 are now considered invalid, old tables are supported, old (always byte swapped) and new (swapped for version < 6) UUIDs can be compared and converted transparently ()
UBSAN: null pointer passed as argument 1, which is declared to never be null in my_strnncoll_binary on SELECT ... COUNT or GROUP_CONCAT ()
Possibly wrong result or Assertion 0' failed in

InnoDB

SIGSEGV in log_sort_flush_list() in InnoDB crash recovery ()
InnoDB tables are being flagged as corrupted on an I/O bound server ()
Duplicate entry allowed into a ()
Server Status

Aria

Various crashes upon INSERT/UPDATE after changing Aria settings ()
Various crashes/asserts/corruptions when Aria encryption is enabled/used, but the encryption plugin is not loaded ()

Spider

SIGSEGV in spider_db_open_item_field and SIGSEGV in spider_db_print_item_type, on SELECT ()
that double as table params overriding mechanism is buggy ()

Optimizer

InnoDB engine statistics for each table ()
Assertion ``last_key_entry >= end_pos'failed in virtual boolJOIN_CACHE_HASHED::put_record()` ()
Problem with open ranges on prefix blobs keys ()
Equal on two

Replication

Parallel Slave SQL Thread Can Update Seconds_Behind_Master with Active Workers ()
ends up in optimistic parallel slave binlog out-of-order ()
takes very long time on a busy system ()
On slave fail to return an error in read-only mode ()

Galera

Node never returns from Donor/Desynced to Synced when wsrep_mode = BF_ABORT_mariadb-backup ()
Node has been dropped from the cluster on Startup / Shutdown with async replica ()
KILL QUERY maintains nodes data consistency but breaks GTID sequence ()
Assertion failure

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 .

Crashing on I/O error is unhelpful (MDEV-27593)
SIGSEGV in log_sort_flush_list() in InnoDB crash recovery (MDEV-31354)
InnoDB tables are being flagged as corrupted on an I/O bound server (MDEV-31767)
Duplicate entry allowed into a ()
Server Status is reported in seconds ()
innochecksum dies with Floating point exception ()
Add InnoDB engine information to the ()
Deadlock with 3 concurrent by ()
innodb protection against dual processes accessing data insufficient ()
ER_DUP_KEY in mysql.innodb_table_stats upon RENAME on sequence ()
Assertion ``!strcmp(index->table->name.m_name, "SYS_FOREIGN") || !strcmp(index->table->name.m_name, "SYS_FOREIGN_COLS")'failed inbtr_node_ptr_max_size` ()
InnoDB: Failing assertion: page_type == i_s_page_type[page_type].type_value ()
btr_estimate_n_rows_in_range() accesses unfixed, unlatched page ()
MODIFY COLUMN can break FK constraints, and lead to unrestorable dumps ()
Recovery or backup failure after ()
Assertion 'n & PENDING' failed in fil_space_t::set_needs_flush() ()
fil_node_open_file() releases fil_system.mutex allowing other thread to open its file node ()
ASAN errors in dict_v_col_t::detach upon adding key to virtual column ()
Purge trying to access freed secondary index page ()
Freed data pages are not always being scrubbed ()
InnoDB recovery hangs after reporting corruption ()
!cursor->index->is_committed() in row0ins.cc after update to 10.4.13 from 10.3.21 ()
fails to wait for purge of enough transaction history ()
SET GLOBAL does not free space when no undo logs exist ()
(linear read-ahead) does not work ()
InnoDB recovery and mariadb-backup --prepare fail to report detailed progress ()
fil_ibd_create() may hijack the file handle of an old file ()
recovery results in a corrupted undo log ()
Server freeze due to and ()
Change buffer entries are left behind when freeing a page, causing secondary index corruption when the page is later reused ()
Foreign Key Constraint actions don't affect Virtual Column ()

Thread (10.6+) and server hangs (10.4/10.5) in 'Opening tables' (on optimized builds) and SIGABRT in safe_mutex_lock (on debug) on I_S read when using Spider (MDEV-29421)
SIGSEGV in spider_db_mbase::append_lock_tables on LOCK TABLES (MDEV-29963)
ASAN heap-use-after-free in spider_link_get_key on LOCK TABLES ()
Crash when lateral derived is guaranteed to return no rows ()
Bogus error executing PS for query using CTE with renaming of columns ()
Spider: Valid LEFT JOIN results in ERROR 1064 ()
Trying to lock uninitialized mutex or hang upon shutdown after using Spider with query_cache ()
Spider tests failing in asan/valgrind builds ()
Backport fixes to spider init bugs to 10.4-10.6 once they have SQL service ()
Server crash with SIGSEGV or dynamic-stack-buffer-overflow in spider_db_mbase_util::append_table ()
heap-use-after-free in ha_spider::lock_tables(), highly sporadic SIGSEGV in intern_close_table ()
Syntax error upon query with subquery from Spider table ()
Spider doesn't recognize semi JOIN ()
MariaDB, SPIDER engine, usage of REGEXP ()
Spider: variable spider_same_server_link not functioning correctly ()
Spider fails to autodiscover structure (did in <=10.5) and reports ERROR 12500 (HY000): unknown ()
Spider spawns unnecessarily many system threads for stats synchronization ()
- Defaults for and changed from 10 to 1
SIGSEGV in spider_db_delete_all_rows on TRUNCATE, UBSAN: member call on null pointer of type 'struct spider_db_handler' in spider_db_delete_all_rows ()
mariadb-upgrade fails with 'System table spider_tables is different version' => Can't create database 'performance_schema' ()
Spider: SIGSEGV in spider_db_direct_delete, SIGSEGV in spider_db_connect, ASAN: heap-use-after-free in spider_db_direct_delete ()
INSERT ... SELECT Does not produce an optimizer trace ()
No error for DROP TABLE and no warning for DROP TABLE IF EXISTS with absent table when Spider plugin is included ()
ASAN errors in spider_conn_queue_and_merge_loop_check ()

MariaDB 11.3.1 Release Notes

The most recent release of MariaDB 11.3 is:

Stable (GA)

Download 11.3.1 | Release Notes | Changelog | Overview of 11.3

Release date: 21 Nov 2023

Do not use non-stable (non-GA) releases in production!

MariaDB 11.3 is a current development series of MariaDB. It is an evolution of MariaDB 11.2 with several entirely new features.

MariaDB 11.3.1 is a Release Candidate (RC) release.

For an overview of MariaDB 11.3 see theWhat is MariaDB 11.3? page.

Thanks, and enjoy MariaDB!

Notable Items

InnoDB

followed by may corrupt data ()
ROW_FORMAT=COMPRESSED table: InnoDB: 2048 bytes should have been read. Only 0 bytes read. ()
Server aborts during alter operation when table doesn't have foreign index ()
row_merge_fts_doc_tokenize() handles FTS plugin parser inconsistently ()

Optimizer

New setting, cset_narrowing, to enable the ()
Crash when HAVING in a correlated subquery references columns in the outer query ()
Server crashes at TABLE::add_tmp_key ()
Server crashes inside filesort at my_decimal::to_binary (

Replication

rpl.rpl_parallel_temptable failure due to incorrect commit optimization of temptables ()
Lock wait timeout with INSERT-SELECT, autoinc, and statement-based replication ()
strings/ctype-ucs2.c:2336: my_vsnprintf_utf32: Assertion `(n % 4) == 0' failed in my_vsnprintf_utf32 on INSERT ()
Assertion fails in MDL_context::acquire_lock upon parallel replication of CREATE SEQUENCE ()

Assertion ``state() == s_executing || state() == s_prepared || state() == s_committing || state() == s_must_abort || state() == s_replaying'` failed. ()
Assertion ``state() == s_executing || state() == s_preparing || state() == s_prepared || state() == s_must_abort || state() == s_aborting || state() == s_cert_failed || state() == s_must_replay'` failed ()
wsrep_sst_mariadb-backup not working on FreeBSD ()
Galera library 26.4.16 fails with every server version (

Data Definition

MariaDB crash on calling function ()
ASAN errors in grn_obj_unlink / ha_mroonga::clear_indexes upon index operations ()
vcol circular references lead to stack overflow ()
OPTIMIZE TABLE crash ()

Scripts and Clients

(mysqlbinlog) option ()
(mysqladmin) wrong error with ()
shows warning on missing directory $pamtooldir/auth_pam_tool_dir ()
main.mysql_client_test, main.mysql_client_test_comp failed on ASAN build with error: 5888, status: 23, errno: 2 ()

mariadb-backup

mariadb-backup full backup failed with InnoDB: Failing assertion: success in storage/innobase/fil/fil0fil.cc line 657 ()
mbstream breaks page compression on XFS ()

Character Sets, Data Types, Collations

Prefix keys for CHAR work differently for MyISAM vs InnoDB ()
Inconsistent results of DISTINCT with NOPAD ()
Assertion `(length % 4) == 0' failed in my_lengthsp_utf32 on INSERT ()
Compressed varchar values lost on joins when sorting on columns from joined table(s) ()

Spider

Spider UBSAN runtime error: applying non-zero offset x to null pointer in st_spider_param_string_parse::restore_delims ()
Segfault when setting spider_delete_all_rows to 0 and delete all rows of a spider table, ASAN heap-use-after-free in spider_db_delete_all_rows ()
ASAN errors in spider_fields::free_conn_holder or spider_create_group_by_handler ()
ASAN: heap-buffer-overflow & stack-buffer-overflow in spider_db_mbase_row::append_to_str

General

Added database level privilege ()
option breaks importing sql dumps ()
Crashes in MDL_key::mdl_key_init with lower-case-table-names=2 ()
getting error 'Illegal parameter data types row and bigint for operation '+' ' when using ITERATE in a FOR..DO ()

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 .

Do not use non-stable (non-GA) releases in production!

MariaDB 11.2.4 Release Notes

The most recent release of MariaDB 11.2 is:MariaDB 11.2.6 Stable (GA) Download Now Alternate download from mariadb.org

Download 11.2.4 | Release Notes | Changelog | Overview of 11.2

Release date: 16 May 2024

MariaDB 11.2 is a current short-term stable series of MariaDB and will be maintained until October 2024. It is an evolution of MariaDB 11.1 with several entirely new features.

MariaDB 11.2.4 is a Stable (GA) release.

For an overview of MariaDB 11.2 see theWhat is MariaDB 11.2? page.

Thanks, and enjoy MariaDB!

Notable Items

From this version, the tool adds a new command to the top of every dump file. This command cannot be interpreted by MariaDB command line client versions that do not have the sandbox command, or by MySQL command line clients, and an error will be generated in these clients. Other methods of importing the dump will work not have this issue.

Storage Engines

InnoDB

Introduce the system variable to address excessive context switching caused by log_sys.lsn_lock (observed on write-intensive workloads on NUMA systems) ()
Fix InnoDB holding shared dict_sys.latch while waiting for FOREIGN KEY child table lock on DDL ()
Fix adaptive hash index corruption after ()
Server no longer aborts while altering an InnoDB statistics table (

Fixed that internal temporary tables did not wait for freed disk space, and related issues ()

Fix wrong result on 2nd execution of prepared statement for query with derived table ()

Improve Spider performance by pushing down function () and statement () to data nodes
Fix server crash when deleting partitions from a table with spider engine ()
SPIDER plugin initialization no longer fails at 'create table if not exists mysql.spider_tables ... with 'Specified key was too long; max key length is 1000 bytes', Warning: Memory not freed: 10720 ()

Backup

Port backup features from Enterprise Server. This adds support for to , and obsoletes the and options ()
now preserves ()
Fix problem on older mariadb (opendir(NULL)) caused by ()

,

Fixed improper application of COLLATE to non-character columns ()
Default charset now works with PHP MySQLi extension ()
Fixed Bad SEPARATOR value in on character set conversion ()
Fixed out of range error in (()) due to a wrong data type (

JSON

View created via now returns correct json object ()
now detects the type of String Values and correctly returns Date/DateTime values ()
no longer returns NULL on valid arguments ()
no longer returns multiple values for same path ()

Encryption, TLS, SSL

WolfSSL's math is unnecessarily slow ()

Optimization & Tuning

Server crashes in JOIN_CACHE::write_record_data upon EXPLAIN with subqueries and constant tables ()
Wrong result with cross Join given join order ()
Wrong warnings on 2-nd execution of PS for query with GROUP_CONCAT ()
Wrong result with semi-join and splittable derived table ()

Plugins

The now reports the user and host in all cases ()

Replication

--gtid-ignore-duplicate can double-apply event in case of parallel replication retry ()
Deadlock kill of XA PREPARE can break replication / rpl.rpl_parallel_multi_domain_xa sporadic failure ()
mysql_manager_submit Segfault at Startup Still Possible During Recovery ()
Server crash in Rows_log_event::update_sequence upon replaying binary log ()

Galera

updated to 26.4.18
- NOTE: Includes increasing the GCS protocol version, which prevents downgrades of individual nodes in the cluster as soon as all nodes have been updated
Disallow bulk insert operation during partition update statement ()

SQL, Data Definition, and Data Manipulation

Transportable Tablespaces no longer leave in a mismatched state ()
Fix wrong row targeted with "insert ... on duplicate" and "replace", leading to data corruption ()
Fix incorrect DEFAULT expression evaluated in ()
Fix server crash when UPDATE statement with duplicate key is run after setting a low thread_stack ()

Platforms & Packaging

MariaDB-client community can't be installed in red hat ubi9 ()

General

Scripts & Clients

It's now possible to disable system commands with the option. ()
now exports the data with sandbox mode enable, so that the mariadb client will not execute potentially dangerous cli commands.()
commands such as mariadb-dump --dump-slave=2 --master-data=2 now record both positions ()

Server

Moving from to 10.6 mysql_upgrade is not updating some system tables ()
Original IP not shown in network related error messages when proxy_protocol is in use ()
Server incorrectly describes known variables as UNKNOWN if invalid values are specified at startup ()
update case insensitive (large) unique key with insensitive change of value - duplicate key ()

Security

Fixes for the following :

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 .

MariaDB 11.2.3 Release Notes

The most recent release of MariaDB 11.2 is:MariaDB 11.2.6 Stable (GA) Download Now Alternate download from mariadb.org

Download 11.2.3 | Release Notes | Changelog | Overview of 11.2

Release date: 7 Feb 2024

MariaDB 11.2 is a current short-term stable series of MariaDB, maintained until October 2024. It is an evolution of MariaDB 11.1 with several entirely new features.

MariaDB 11.2.3 is a Stable (GA) release.

For an overview of MariaDB 11.1 see theWhat is MariaDB 11.2? page.

Thanks, and enjoy MariaDB!

Notable Items

Windows packages were delayed but have now been added to the downloads site

InnoDB

Unique hash key on column prefix is computed incorrectly ()
Query from I_S.INNODB_SYS_INDEXES exceeding LIMIT ROWS EXAMINED causes ER_UNKNOWN_ERROR and LeakSanitizer errors in rec_copy_prefix_to_buf_old ()
Assertion ``0'failed in

Backup

mariadb-backup has wrong or missing plugin-dir default? ()
mariadb-backup fails when innodb_max_dirty_pages_pct contains a fraction (is not an integer) ()
Missing required privilege CONNECTION ADMIN ()

JSON

Wrong function name in ER_JSON_PATH_NO_WILDCARD error message for JSON_REPLACE ()
JSON_VALID fail to validate integer zero in scientific notation ()
ASAN errors in Item_func_json_contains_path::val_int

Spider

Thread (10.6+) and server hangs (10.4/10.5) in 'Opening tables' (on optimized builds) and SIGABRT in safe_mutex_lock (on debug) on I_S read when using Spider ()
SIGSEGV in spider_db_mbase::append_lock_tables on LOCK TABLES ()
ASAN

Optimizer

Crash caused by multi-table UPDATE over derived with hanging CTE ()
Crash on query using CTE with the same name as a base table ()
Crash with query using constant subquery as left part of IN subquery ()
Incorrect result interceptor passed to mysql_explain_union()

Data Definition, Data Manipulation

ALTER SEQUENCE IF NOT EXISTS non_existing_seq Errors rather than note ()
Unexpected ER_ERROR_ON_RENAME upon DROP non-existing FOREIGN KEY with ALGORITHM=COPY ()

Character Sets, Data Types

InnoDB: CHAR+nopad does not work well ()
CAST(AS UNSIGNED) fails with --view-protocol ()
JSON_ARRAYAGG charset issue ()

Plugins

The can optionally (when is enabled) include the thread ID and database / table in its log (). NULL is displayed if there is no database ()
Backport SQL service, introduced by ()
"plugin already loaded" should be a Warning, not an Error ()

Galera

Node has been dropped from the cluster on Startup / Shutdown with async replica ()
Inconsistency in Galera caused by ALTER being aborted before entering TOI mode ()
Assertion ``total_length + thd->wsrep_sr().log_position() == saved_pos'failed in intwsrep_write_cache_inc(THD*, IO_CACHE*, size_t*)` ()

Replication

Server crashes in Item_func_binlog_gtid_pos::val_str / Binary_string::c_ptr_safe ()
binlog corruption (/tmp no space left on device at the same moment) ()
multi source replication filters breaking GTID semantic ()
SHOW SLAVE STATUS

General

As per the , this will be the last release of for Fedora 37, Ubuntu 23.04 "Lunar", and Windows Server 2019
is now dynamic, and contains new options, and old options have been deprecated ()
New value, NO_NULL_COLLATION_IDS, a compatibility setting to support connectors (in particular MySQL Connector/NET) that give an exception when collation ids returned by are NULL. It is automatically set when a MySQL Connector/NET connection is determined.

Security

Fixes for the following :

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 .

MariaDB 11.1.4 Release Notes

The most recent release of MariaDB 11.1 is:MariaDB 11.1.6 Stable (GA) Download Now Alternate download from mariadb.org

Download 11.1.4 | Release Notes | Changelog | Overview of 11.1

Release date: 7 Feb 2024

MariaDB 11.1 is a current short-term stable series of MariaDB, maintained until August 2024. It is an evolution of MariaDB 11.1 with several entirely new features.

MariaDB 11.1.4 is a Stable (GA) release.

For an overview of MariaDB 11.1 see theWhat is MariaDB 11.1? page.

Thanks, and enjoy MariaDB!

Notable Items

Windows packages were delayed but have now been added to the downloads site

InnoDB

Unique hash key on column prefix is computed incorrectly ()
Query from I_S.INNODB_SYS_INDEXES exceeding LIMIT ROWS EXAMINED causes ER_UNKNOWN_ERROR and LeakSanitizer errors in rec_copy_prefix_to_buf_old ()
Assertion ``0'failed in

Backup

mariadb-backup has wrong or missing plugin-dir default? ()
mariadb-backup fails when innodb_max_dirty_pages_pct contains a fraction (is not an integer) ()
Missing required privilege CONNECTION ADMIN ()

JSON

Wrong function name in ER_JSON_PATH_NO_WILDCARD error message for JSON_REPLACE ()
JSON_VALID fail to validate integer zero in scientific notation ()
ASAN errors in Item_func_json_contains_path::val_int

Spider

Thread (10.6+) and server hangs (10.4/10.5) in 'Opening tables' (on optimized builds) and SIGABRT in safe_mutex_lock (on debug) on I_S read when using Spider ()
SIGSEGV in spider_db_mbase::append_lock_tables on LOCK TABLES ()
ASAN

Optimizer

Crash caused by multi-table UPDATE over derived with hanging CTE ()
Crash on query using CTE with the same name as a base table ()
Crash with query using constant subquery as left part of IN subquery ()
Incorrect result interceptor passed to mysql_explain_union()

Data Definition, Data Manipulation

ALTER SEQUENCE IF NOT EXISTS non_existing_seq Errors rather than note ()
Unexpected ER_ERROR_ON_RENAME upon DROP non-existing FOREIGN KEY with ALGORITHM=COPY ()

Character Sets, Data Types

InnoDB: CHAR+nopad does not work well ()
CAST(AS UNSIGNED) fails with --view-protocol ()
JSON_ARRAYAGG charset issue ()

Plugins

The can optionally (when is enabled) include the thread ID and database / table in its log (). NULL is displayed if there is no database ()
Backport SQL service, introduced by ()
"plugin already loaded" should be a Warning, not an Error ()

Galera

Node has been dropped from the cluster on Startup / Shutdown with async replica ()
Inconsistency in Galera caused by ALTER being aborted before entering TOI mode ()
Assertion ``total_length + thd->wsrep_sr().log_position() == saved_pos'failed in intwsrep_write_cache_inc(THD*, IO_CACHE*, size_t*)` ()

Replication

Server crashes in Item_func_binlog_gtid_pos::val_str / Binary_string::c_ptr_safe ()
binlog corruption (/tmp no space left on device at the same moment) ()
multi source replication filters breaking GTID semantic ()
SHOW SLAVE STATUS

General

As per the , this will be the last release of for Fedora 37, Ubuntu 23.04 "Lunar", and Windows Server 2019
is now dynamic, and contains new options, and old options have been deprecated ()
New value, NO_NULL_COLLATION_IDS, a compatibility setting to support connectors (in particular MySQL Connector/NET) that give an exception when collation ids returned by are NULL. It is automatically set when a MySQL Connector/NET connection is determined.

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 .

MariaDB 11.2.2 Release Notes

The most recent release of MariaDB 11.2 is:MariaDB 11.2.6 Stable (GA) Download Now Alternate download from mariadb.org

Download 11.2.2 | Release Notes | Changelog | Overview of 11.2

Release date: 21 Nov 2023

MariaDB 11.2 is a current short-term stable series of MariaDB, maintained until November 2024. It is an evolution of MariaDB 11.1 with several entirely new features.

MariaDB 11.2.2 is a Stable (GA) release.

For an overview of MariaDB 11.1 see theWhat is MariaDB 11.2? page.

Thanks, and enjoy MariaDB!

Notable Items

InnoDB

followed by may corrupt data ()
ROW_FORMAT=COMPRESSED table: InnoDB: 2048 bytes should have been read. Only 0 bytes read. ()
Server aborts during alter operation when table doesn't have foreign index ()
row_merge_fts_doc_tokenize() handles FTS plugin parser inconsistently ()

Optimizer

New setting, cset_narrowing, to enable the ()
Crash when HAVING in a correlated subquery references columns in the outer query ()
Server crashes at TABLE::add_tmp_key ()
Server crashes inside filesort at my_decimal::to_binary (

Replication

rpl.rpl_parallel_temptable failure due to incorrect commit optimization of temptables ()
Lock wait timeout with INSERT-SELECT, autoinc, and statement-based replication ()
strings/ctype-ucs2.c:2336: my_vsnprintf_utf32: Assertion `(n % 4) == 0' failed in my_vsnprintf_utf32 on INSERT ()
Assertion fails in MDL_context::acquire_lock upon parallel replication of CREATE SEQUENCE ()

updated to 26.4.16
Assertion ``state() == s_executing || state() == s_prepared || state() == s_committing || state() == s_must_abort || state() == s_replaying'` failed. ()
Assertion ``state() == s_executing || state() == s_preparing || state() == s_prepared || state() == s_must_abort || state() == s_aborting || state() == s_cert_failed || state() == s_must_replay'` failed ()
wsrep_sst_mariadb-backup not working on FreeBSD (

Data Definition

MariaDB crash on calling function ()
ASAN errors in grn_obj_unlink / ha_mroonga::clear_indexes upon index operations ()
vcol circular references lead to stack overflow ()
OPTIMIZE TABLE crash ()

Scripts and Clients

(mysqlbinlog) option ()
(mysqladmin) wrong error with ()
shows warning on missing directory $pamtooldir/auth_pam_tool_dir ()
main.mysql_client_test, main.mysql_client_test_comp failed on ASAN build with error: 5888, status: 23, errno: 2 ()

mariadb-backup

mariadb-backup full backup failed with InnoDB: Failing assertion: success in storage/innobase/fil/fil0fil.cc line 657 ()
mbstream breaks page compression on XFS ()

Character Sets, Data Types, Collations

Prefix keys for CHAR work differently for MyISAM vs InnoDB ()
Inconsistent results of DISTINCT with NOPAD ()
Assertion `(length % 4) == 0' failed in my_lengthsp_utf32 on INSERT ()
Compressed varchar values lost on joins when sorting on columns from joined table(s) ()

Spider

Spider UBSAN runtime error: applying non-zero offset x to null pointer in st_spider_param_string_parse::restore_delims ()
Segfault when setting spider_delete_all_rows to 0 and delete all rows of a spider table, ASAN heap-use-after-free in spider_db_delete_all_rows ()
ASAN errors in spider_fields::free_conn_holder or spider_create_group_by_handler ()
ASAN: heap-buffer-overflow & stack-buffer-overflow in spider_db_mbase_row::append_to_str

General

option breaks importing sql dumps ()
Crashes in MDL_key::mdl_key_init with lower-case-table-names=2 ()
getting error 'Illegal parameter data types row and bigint for operation '+' ' when using ITERATE in a FOR..DO ()
Assertion `arena_for_set_stmt== 0' failed in LEX::set_arena_for_set_stmt upon SET STATEMENT ()

Docker Official Images

Invert single and double quotes for sql command definitions in due to failure under - contribution by Dominik Häckel
--no-defaults behaviour was corrected - reported by Dominik Häckel
Added /docker-entrypoint-init.d for tar{,compression} from -
Refactor docker_mariadb_init

Variables

Added the system variable to manage .

Security

Fixes for the following :

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 .

Unique hash key on column prefix is computed incorrectly (MDEV-29954)
Query from I_S.INNODB_SYS_INDEXES exceeding LIMIT ROWS EXAMINED causes ER_UNKNOWN_ERROR and LeakSanitizer errors in rec_copy_prefix_to_buf_old (MDEV-28613)
Assertion ``0'failed inrow_sel_convert_mysql_key_to_innobase upon UPDATE` using a partial-field key prefix in search ()
Assertion failure on REPLACE on ROW_FORMAT=COMPRESSED table ()
Crash emitting "Unsupported meta-data version number" error message ()
LeakSanitizer errors in mem_heap_create_block_func upon query from I_S.INNODB_SYS_TABLES with LIMIT ROWS EXAMINED ()
Inplace alter rebuild increases file size ()
BLOB corruption on UPDATE of PRIMARY KEY with FOREIGN KEY ()
GNU libc posix_fallocate() may be extremely slow ()
InnoDB wrong error message ()
Assertion failure on ALTER TABLE…PAGE_COMPRESSED=1 ()
InnoDB after ALTER TABLE…IMPORT TABLESPACE may not be crash safe ()
InnoDB fails to restore tablespace first page from doublewrite buffer when page is empty ()
innodb_fast_shutdown=0 hang after incomplete startup ()
innodb_undo_log_truncate=ON prevents fast shutdown ()
Adaptive flush recommendation ignores dirty ratio and checkpoint age ()
gcol.gcol_purge contaminates further execution of innodb.gap_locks ()
LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE ()
Adaptive flushing is still not getting invoked in 10.5.11 ()
History list is not shrunk unless there is a pause in the workload ()
path separator near ib_buffer_pool incorrect ()
Deadlock between buf_page_get_zip() and buf_pool_t::corrupted_evict() on InnoDB ROW_FORMAT=COMPRESSED table corruption ()
Empty INSERT crashes with innodb_force_recovery=6 or innodb_read_only=ON ()
Assertion ``end_lsn == page_lsn'failed inrecv_recover_page` ()
Some calls to buf_read_ahead_linear() seem to be useless ()
Opening all .ibd files on InnoDB startup can be slow ()
InnoDB LRU flushing does not run before running out of buffer pool ()
innodb_undo_log_truncate=ON is blocking page writes ()

Thread (10.6+) and server hangs (10.4/10.5) in 'Opening tables' (on optimized builds) and SIGABRT in safe_mutex_lock (on debug) on I_S read when using Spider (MDEV-29421)
SIGSEGV in spider_db_mbase::append_lock_tables on LOCK TABLES (MDEV-29963)
ASAN heap-use-after-free in spider_link_get_key on LOCK TABLES ()
Crash when lateral derived is guaranteed to return no rows ()
Bogus error executing PS for query using CTE with renaming of columns ()
Spider: Valid LEFT JOIN results in ERROR 1064 ()
Trying to lock uninitialized mutex or hang upon shutdown after using Spider with query_cache ()
Spider tests failing in asan/valgrind builds ()
Backport fixes to spider init bugs to 10.4-10.6 once they have SQL service ()
Server crash with SIGSEGV or dynamic-stack-buffer-overflow in spider_db_mbase_util::append_table ()
heap-use-after-free in ha_spider::lock_tables(), highly sporadic SIGSEGV in intern_close_table ()
Syntax error upon query with subquery from Spider table ()
Spider doesn't recognize semi JOIN ()
MariaDB, SPIDER engine, usage of REGEXP ()
Spider: variable spider_same_server_link not functioning correctly ()
Spider fails to autodiscover structure (did in <=10.5) and reports ERROR 12500 (HY000): unknown ()
Spider spawns unnecessarily many system threads for stats synchronization ()
- Defaults for and changed from 10 to 1
SIGSEGV in spider_db_delete_all_rows on TRUNCATE, UBSAN: member call on null pointer of type 'struct spider_db_handler' in spider_db_delete_all_rows ()
mariadb-upgrade fails with 'System table spider_tables is different version' => Can't create database 'performance_schema' ()
Spider: SIGSEGV in spider_db_direct_delete, SIGSEGV in spider_db_connect, ASAN: heap-use-after-free in spider_db_direct_delete ()
No error for DROP TABLE and no warning for DROP TABLE IF EXISTS with absent table when Spider plugin is included ()
ASAN errors in spider_conn_queue_and_merge_loop_check ()

As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 11.0 for Fedora 37, Ubuntu 23.04 "Lunar", and Windows Server 2019
is now dynamic, and contains new options, and old options have been deprecated (MDEV-32884)
New value, NO_NULL_COLLATION_IDS, a compatibility setting to support connectors (in particular MySQL Connector/NET) that give an exception when collation ids returned by are NULL. It is automatically set when a MySQL Connector/NET connection is determined.
Upgrade to 12.6.
Using two temporary tables in OPTIMIZE TABLE lead to crash ()
REGEXP_REPLACE treats empty strings different than REPLACE in ORACLE mode ()
CREATE UNIQUE INDEX fails with "ERROR 1286 (42000): Unknown storage engine 'partition'" ()
Failure when executing PS for query using IN subquery ()
Potential memory leak on execuing of create view statement ()
Assertion failures ()
Two JSON related tests running in PS mode fail on server built with -DWITH_PROTECT_STATEMENT_MEMROOT=YES ()
Alter sequence 2nd ps fails while alter sequence 2nd time (no ps) succeeds ()
Set TaskMax=inifinity in the MariaDB systemd unit ()
Unreliable autocommit flag on connection creation ()
A connection can control RAND() in following connection ()
THD::rli_fake/rgi_fake not cleared on new connection ()
Assertion failures in tdc_remove_table upon interrupted CREATE TABLE LIKE <sequence> ()
Server crash in find_field_in_table ()
LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE ()
Failure to call SP invoking another SP with parameter requiring type conversion ()
The database part is not case sensitive in SP names ()
EXCHANGE PARTITION with non-matching vcol expression segfault ()
Wrong user in SET DEFAULT ROLE error ()
quote(NULL) returns incorrect result in view ('NU' instead of 'NULL') ()
mysql.slow_log reports incorrect start time ()
Update federated table and column privileges ()
Disable transparent huge pages after page buffers have been allocated ()
Deprecate ()
sys schema view session_ssl_status is empty ()
Memory pressure ()

Unique hash key on column prefix is computed incorrectly (MDEV-29954)
Query from I_S.INNODB_SYS_INDEXES exceeding LIMIT ROWS EXAMINED causes ER_UNKNOWN_ERROR and LeakSanitizer errors in rec_copy_prefix_to_buf_old (MDEV-28613)
Assertion ``0'failed inrow_sel_convert_mysql_key_to_innobase upon UPDATE` using a partial-field key prefix in search ()
Assertion failure on REPLACE on ROW_FORMAT=COMPRESSED table ()
Crash emitting "Unsupported meta-data version number" error message ()
LeakSanitizer errors in mem_heap_create_block_func upon query from I_S.INNODB_SYS_TABLES with LIMIT ROWS EXAMINED ()
Inplace alter rebuild increases file size ()
BLOB corruption on UPDATE of PRIMARY KEY with FOREIGN KEY ()
GNU libc posix_fallocate() may be extremely slow ()
InnoDB wrong error message ()
Assertion failure on ALTER TABLE…PAGE_COMPRESSED=1 ()
InnoDB after ALTER TABLE…IMPORT TABLESPACE may not be crash safe ()
InnoDB fails to restore tablespace first page from doublewrite buffer when page is empty ()
innodb_fast_shutdown=0 hang after incomplete startup ()
innodb_undo_log_truncate=ON prevents fast shutdown ()
Adaptive flush recommendation ignores dirty ratio and checkpoint age ()
gcol.gcol_purge contaminates further execution of innodb.gap_locks ()
LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE ()
Adaptive flushing is still not getting invoked in 10.5.11 ()
History list is not shrunk unless there is a pause in the workload ()
path separator near ib_buffer_pool incorrect ()
Deadlock between buf_page_get_zip() and buf_pool_t::corrupted_evict() on InnoDB ROW_FORMAT=COMPRESSED table corruption ()
Empty INSERT crashes with innodb_force_recovery=6 or innodb_read_only=ON ()
Assertion ``end_lsn == page_lsn'failed inrecv_recover_page` ()
Some calls to buf_read_ahead_linear() seem to be useless ()
Opening all .ibd files on InnoDB startup can be slow ()
InnoDB LRU flushing does not run before running out of buffer pool ()
innodb_undo_log_truncate=ON is blocking page writes ()

Thread (10.6+) and server hangs (10.4/10.5) in 'Opening tables' (on optimized builds) and SIGABRT in safe_mutex_lock (on debug) on I_S read when using Spider (MDEV-29421)
SIGSEGV in spider_db_mbase::append_lock_tables on LOCK TABLES (MDEV-29963)
ASAN heap-use-after-free in spider_link_get_key on LOCK TABLES ()
Crash when lateral derived is guaranteed to return no rows ()
Bogus error executing PS for query using CTE with renaming of columns ()
Spider: Valid LEFT JOIN results in ERROR 1064 ()
Trying to lock uninitialized mutex or hang upon shutdown after using Spider with query_cache ()
Spider tests failing in asan/valgrind builds ()
Backport fixes to spider init bugs to 10.4-10.6 once they have SQL service ()
Server crash with SIGSEGV or dynamic-stack-buffer-overflow in spider_db_mbase_util::append_table ()
heap-use-after-free in ha_spider::lock_tables(), highly sporadic SIGSEGV in intern_close_table ()
Syntax error upon query with subquery from Spider table ()
Spider doesn't recognize semi JOIN ()
MariaDB, SPIDER engine, usage of REGEXP ()
Spider: variable spider_same_server_link not functioning correctly ()
Spider fails to autodiscover structure (did in <=10.5) and reports ERROR 12500 (HY000): unknown ()
Spider spawns unnecessarily many system threads for stats synchronization ()
- Defaults for and changed from 10 to 1
SIGSEGV in spider_db_delete_all_rows on TRUNCATE, UBSAN: member call on null pointer of type 'struct spider_db_handler' in spider_db_delete_all_rows ()
mariadb-upgrade fails with 'System table spider_tables is different version' => Can't create database 'performance_schema' ()
Spider: SIGSEGV in spider_db_direct_delete, SIGSEGV in spider_db_connect, ASAN: heap-use-after-free in spider_db_direct_delete ()
No error for DROP TABLE and no warning for DROP TABLE IF EXISTS with absent table when Spider plugin is included ()
ASAN errors in spider_conn_queue_and_merge_loop_check ()

As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 11.3 for Fedora 37 and Ubuntu 23.04 "Lunar"
is now dynamic, and contains new options, and old options have been deprecated (MDEV-32884)
It is now possible to create partitions on tables that contain (MDEV-19177)
New value, NO_NULL_COLLATION_IDS, a compatibility setting to support connectors (in particular MySQL Connector/NET) that give an exception when collation ids returned by are NULL. It is automatically set when a MySQL Connector/NET connection is determined.
Upgrade to 12.6.
Using two temporary tables in OPTIMIZE TABLE lead to crash ()
REGEXP_REPLACE treats empty strings different than REPLACE in ORACLE mode ()
CREATE UNIQUE INDEX fails with "ERROR 1286 (42000): Unknown storage engine 'partition'" ()
Failure when executing PS for query using IN subquery ()
Potential memory leak on execuing of create view statement ()
Assertion failures ()
Two JSON related tests running in PS mode fail on server built with -DWITH_PROTECT_STATEMENT_MEMROOT=YES ()
Alter sequence 2nd ps fails while alter sequence 2nd time (no ps) succeeds ()
Set TaskMax=inifinity in the MariaDB systemd unit ()
Unreliable autocommit flag on connection creation ()
A connection can control RAND() in following connection ()
THD::rli_fake/rgi_fake not cleared on new connection ()
Assertion failures in tdc_remove_table upon interrupted CREATE TABLE LIKE <sequence> ()
Server crash in find_field_in_table ()
LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE ()
Failure to call SP invoking another SP with parameter requiring type conversion ()
The database part is not case sensitive in SP names ()
EXCHANGE PARTITION with non-matching vcol expression segfault ()
Wrong user in SET DEFAULT ROLE error ()
quote(NULL) returns incorrect result in view ('NU' instead of 'NULL') ()
mysql.slow_log reports incorrect start time ()
Update federated table and column privileges ()
Deprecate ()
sys schema view session_ssl_status is empty ()
Memory pressure ()

MariaDB 10.5 Changes & Improvements

MariaDB 10.5 is no longer maintained. Please use a more recent release.

The most recent release of MariaDB 10.5 is:

Stable (GA)

MariaDB 10.5 is a previous major release series. The first stable release was in June 2020, and it was maintained until June 2025.

Upgrading

See and .

Implemented Features

See the page for items that are different between MariaDB Community Server 10.5 and MariaDB Enterprise Server 10.5.

ColumnStore

This release of MariaDB Server includes the storage engine. Note, that plugins have and MariaDB ColumnStore in 10.5.4 has Beta maturity.

Binaries Named mariadb (mysql Symlinked)

All binaries previously beginning with mysql now begin with mariadb, with symlinks for the corresponding mysql command. ()
When starting the MariaDB server via the systemd service it will be started using the mariadbd binary name, so this will now show up in the system process list instead of mysqld

INET 6 Data Type

New data type for storing IPv6 addresses ()

Amazon S3

The allows one to archive MariaDB tables in Amazon S3, or any third-party public or private cloud that implements S3 API ( )
Both S3 tables and S3 tables are discoverable. This means that if you create a partitioned S3 table, both the partitioned table and its partitions can be directly used by another server that has access to the S3 storage. ()

Privileges Made More Granular

Split SUPER to smaller privileges (). New privileges were added so that more fine grained tuning of what each user can do can be applied:

InnoDB: Performance Improvements etc.

Extend LIKE 'Innodb_%' ()
Clean up tables ()
Doublewrite buffer is unnecessarily used for newly (re)initialized pages ()
Defer change buffer merge until pages are requested ()

InnoDB New Defaults for Variables

now defaults to OFF ()
now defaults to full_crc32 ()

InnoDB Removed or Deprecated Variables

()
()
()

Performance Schema Updates to Match MySQL 5.7 Instrumentation and Tables

Memory ()
Meta data locking (MDL) ()
Prepared statements (ps) ()
[show] status instrumentation and tables ()

Galera: Full GTID Support

Add full support to cluster (). With this feature all nodes in a cluster will have the same GTID for replicated events originating from the cluster. Also added a new variable, wsrep_gtid_seq_no, to manually update the WSREP GTID sequence number in the cluster (similar to how the gtid_seq_no variable is used for non-WSREP transactions).
Add new mode to wsrep_OSU_method in which Galera checks storage engine of the affected table ()
Galera: Replicate MariaDB GTID to other nodes in the cluster ()

Binary Log and Replication: More Metadata

now defaults to optimistic ().
Make REPLICA a synonym for ()
ENFORCE option for ()

Syntax

() - returns SELECT of inserted rows (analogous to )
()
and ()
Application period tables: ()

JSON

Added . This returns a JSON array containing an element for each value in a given set of JSON or SQL values. It acts on a column or an expression that evaluates to a single value.
Added . This returns a JSON object containing key-value pairs. It takes two expressions that evaluate to a single value, or two column names, as arguments, the first used as a key, and the second as a value.

Thread Pool

Information Schema tables (, , and ) for internals of generic thread_pool ().

Performance Improvements

Speed up binary row logging code
Range optimizer speedups. Removed double calls to records_in_range() for some cases.
Costs for using MEMORY tables updated to be more accurate
Fixed that 'ref' access is preferred over 'range' for the same index.

Query Optimizer

Improve Protocol performance for numeric data by avoiding unnecessary character string conversions (, )
is improved, now it also shows the time spent checking the WHERE clause and doing other auxiliary operations ()
()
Allow packed sort keys and values of non-sorted fields in the sort buffer ( &

General

The has a new column showing from which config file a variable derives its value ()
Switch Perl DBI scripts from DBD::mysql to DBD::MariaDB driver ()
The max key length is now 2000 bytes, compared to 1000 bytes in .
now reliably deletes table remnants inside a storage engine even if the .frm file is missing (

PCRE (Perl Compatible Regular Expressions)

Migrate to (), a newer version of the pcre library.

Variables

For a list of all new variables, see and .
The has a new column showing from which config file a variable derives its value ().
Port from MySQL 5.6 (). If set, old temporal data types (created with a pre-10.0 version of MariaDB) are displayed with a /* mariadb-5.3 */ comment.
Numerous deprecated variables removed (

Security Vulnerabilities Fixed in

For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the page.

Resources

(video presentation by Sergei Golubchik)

List of All Releases

Date

Release

Status

Release Notes

Changelog