Download Release Notes Changelog Overview of 10.6

^{Alternate download from mariadb.org}

Release date: 6 Nov 2025

MariaDB 10.6 is a current long-term series of MariaDB, maintained until July 2026. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.24 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

InnoDB

• InnoDB could crash after a DROP TABLE, TRUNCATE TABLE, OPTIMIZE TABLE or a table-rebuilding ALTER TABLE if innodb_adaptive_hash_index entries existed in the table. ()

• InnoDB could crash if the definition of the InnoDB persistent statistics tables were incorrect. ()

• ALTER TABLE could fail to update InnoDB persistent statistics. ()

• InnoDB could crash during the crash recovery of a corrupted database. ()

Aria

• Recovery of Aria transactional tables did not work in big-endian machines like s390x and Sparc ()

Spider

• Spider: XA COMMIT ONE PHASE fails with "This xid does not exist" ()

MyISAM

• myisamchk -V crashes ()

Full-text Search

• InnoDB could potentially crash if there is any lock conflict on an internal FTS_%_CONFIG table of a FULLTEXT INDEX while one of the INFORMATION_SCHEMA views INNODB_TRX, INNODB_LOCKS, or INNODB_LOCK_WAITS are being accessed. ()

• The minimum value of the parameter innodb_ft_min_token_size was increased to 1, similar to the parameter ft_min_word_len. ()

Galera

• MariaDB Cluster server crash during insert when replication filters are used ()

• Inconsistency detected - create sequence ()

Parser

• very long query cannot be killed quickly ()

GIS

• Several bugs in SPATIAL INDEX page splitting logic could crash InnoDB if the PRIMARY KEY or the SPATIAL data is variable-length. ()

• Wrong results for self-touching shapes. ()

Optimizer - CTE

• Server crash on cleanup of non-fully-constructed-due-to-an-error CTE ()

Sequences

• Fixed crashing bug when inserting into a tables with several nextval(sequence) default values. ()

Backup

• Parallel slave worker crashes During Backup at retrying ()

Scripts & Clients

• mariadb-dump -T did not encode table names like the server did for frm files, so some tables can be created in the server, but not dumped with mariadb-dump -T, for example, a table con on Windows. ()

Changelog

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

Download Release Notes Changelog Overview of 10.6

Release date: 12 Feb 2022

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

MariaDB 10.6.7 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

• This release fixes a blocking problem with the MariaDB 10.6.6 release when manually running . ()

• See for other changes since the previous release.

InnoDB

• Set by default ()

Security

• Fixes for the following :

Changelog

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

Contributors

For a full list of contributors to , see the .

Release date: 8 Nov 2021

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

is a release.

Thanks, and enjoy MariaDB!

Release date: 6 Aug 2025

is a current long-term series of MariaDB, July 2026. It is an evolution of with several entirely new features.

MariaDB 10.6.23 is a release.

Download Release Notes Changelog Overview of 10.6

Release date: 6 Jul 2021

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

MariaDB 10.6.3 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Changes

InnoDB

• Maximum value of is now 100000000, which means infinite timeout ()

• Write performance improvements: , , , ,

• rewrite ()

• Thinly provisioned SSD support for page_compressed tables ()

Replication

• Fix binlog background thread hang at shutdown ()

General

• The views and have been added to the information schema ()

• Assertion ``thd->locked_tables_mode == LTM_NONE'failed inLocked_tables_list::init_locked_tables` ()

Security

• Fixes for the following :

Changelog

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

Contributors

For a full list of contributors to , see the .

Download Release Notes Changelog Overview of 10.6

Release date: 21 May 2021

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

MariaDB 10.6.1 is a Beta release.

Thanks, and enjoy MariaDB!

Notable Changes

Notable changes of this release include:

Atomic DDL

• , , , , and related DDL statements are now atomic. Either the statement is fully completed, or everything is reverted to it's original state. Note that when deleting multiple tables with DROP TABLE, only each individual drop is atomic, not the full list of tables). ().

Replication, Galera and Binlog

• updated to 26.4.8

• The delay between binary log purges can now be specified with much greater precision. The system variable is introduced as a form of alias for , which now accepts a precision of 1/1000000 days ()

• Allow transition from unencrypted to TLS cluster communication without cluster downtime ()

• DDL information logged on all

Oracle Compatibility

• added ()

• added ()

• added ()

• MINUS is mapped to in UNION ()

Character Sets

• The utf8 (and related collations) is now by default an alias for utf8mb3 rather than the other way around. It can be set to imply utf8mb4 by changing the value of the system variable ()

Clients

• For clients such as , the connection property specified via the command line (e.g. --port=3306) will now force its type ()

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 beta releases in production!

Download Release Notes Changelog Overview of 10.6

Release date: 19 Sep 2022

MariaDB 10.6 is the current long-term maintenance stable series of MariaDB, maintained until July 2026. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.10 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Items

Issues Fixed

• Assertion mysql_mutex_assert_owner(&log_sys.flush_order_mutex) failed in mtr_t::commit() ()

• Frequent "Data structure corruption" in InnoDB after OOM ()

• Recovery or backup of instant ALTER TABLE is incorrect ()

• InnoDB Temporary Tablespace (ibtmp1) is continuously growing ()

Changelog

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

Contributors

For a full list of contributors to , see the .

Release date: 20 May 2022

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

is a release.

Thanks, and enjoy MariaDB!

Note that is not yet available for Ubuntu 22.04 due to . will be available.

Release date: 15 Aug 2022

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

is a release.

Thanks, and enjoy MariaDB!

Release date: 7 Jun 2023

Warning: This version can cause InnoDB file corruption under high I/O-bound load. Stick to an earlier release, or upgrade to a more recent release, if possible. See .

is the current long-term series of MariaDB, July 2026. It is an evolution of with several entirely new features.

is a release.

Thanks, and enjoy MariaDB!

Download Release Notes Changelog Overview of 10.6

Release date: 18 Jun 2021

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

MariaDB 10.6.2 is a Release Candidate (RC) release.

Thanks, and enjoy MariaDB!

Notable Changes

InnoDB

• When (the default), the following counters (which reflect btr_cur_n_non_sea) will no longer be updated ():

  • adaptive_hash_index in

  • in

Replication

• replica recovery is introduced. server executes a special recovery branch to guarantee its consistency with a primary server ()

General

• Error messages now use "MariaDB" instead of "MySQL" ()

• Implement FLUSH TABLES tbl_name [, tbl_name] ... WITH READ LOCK for views ()

• All statements can be prepared, except , , and ()

Changelog

For a complete list of changes and bugfixes 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!

Download Release Notes Changelog Overview of 10.6

Release date: 6 Aug 2021

Warning: This version can cause InnoDB file corruption on FreeBSD and on AIX. Stick to an earlier release, or upgrade to a more recent release, if you are running either of these environments. See MDEV-26537.

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

MariaDB 10.6.4 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Items

InnoDB

• InnoDB no longer acquires advisory file locks by default ()

• Encryption: Automatically disable key rotation checks for file_key_management plugin ()

• Some fixes from MySQL 5.7.35 ()

• Fixed scrubbing on AIX ()

Optimizer

• A query that uses ORDER BY .. LIMIT clause and "Range checked for each record optimization" could produce incorrect results under some circumstances ()

• Queries that have more than 32 equality conditions comparing columns of different tables ("tableX.colX=tableY.colY) could cause a stack overrun in the query optimizer (, )

• "Condition pushdown into derived table" optimization cannot be applied if the expression being pushed refers to a derived table column which is computed from expression that has a stored function call, @session variable reference, or other similar construct. The fix for makes it so that only the problematic part of the condition is not pushed. The rest of the condition is now pushed. ()

Packaging & Misc

• As per the , this will be the last release of for Ubuntu 20.10 Groovy

• Debian 11 Bullseye repositories added

• updated to 26.4.9

• Linux on IBM Z (s390x) architecture added with releases on Ubuntu-20.04 Focal

Security

• Fixes for the following :

Changelog

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

Contributors

For a full list of contributors to , see the .

Release date: 6 Feb 2023

is the current long-term series of MariaDB, July 2026. It is an evolution of with several entirely new features.

is a release.

Thanks, and enjoy MariaDB!

Release date: 7 Nov 2022

is the current long-term maintenance stable series of MariaDB, maintained until July 2026. It is an evolution of with several entirely new features.

is a release.

Thanks, and enjoy MariaDB!

MariaDB 10.6 is a long-term maintenance stable version. The first stable release was in July 2021, and it will be maintained until July 2026.

Upgrading

• See and .

New Features & Improvements

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

Atomic DDL

• , , , , and related DDL statements . Either the statement is fully completed, or everything is reverted to it's original state. Note that when deleting multiple tables with DROP TABLE, only each individual drop is atomic, not the full list of tables). ().

SQL Syntax

• Implement SQL-standard ()

• Add syntax (InnoDB only) ()

• (, )

• , used to extract JSON data based on a JSON path expression and to return it as a relational table ()

Oracle Compatibility

• Anonymous (no AS clause) are permitted in ()

• added ()

• added ()

• added ()

InnoDB

• Optimization to speed up inserts into an empty table ()

• We intended to deprecate and eventually remove the . The first step was to make the tables , but this plan was abandoned from () ()

• now directly reflects the filesystem, and has been removed ()

Replication, Galera and Binlog

• Increase limit to 255, user to 128 ()

• The system variable, for turning on WSREP features which are not part of default behavior (including the experimental Aria replication) (, , )

• The delay between binary log purges can now be specified with much greater precision. The system variable is introduced as a form of alias for , which now accepts a precision of 1/1000000 days ()

Sys Schema

• Bundle , a collection of views, functions and procedures to help administrators get insight into database usage. ()

Performance Schema

• Merged replication instrumentation and tables (, )

Information Schema

• The views and have been added to the information schema ()

Storage Engines

• has been removed ()

• has been removed ()

Character Sets

• The utf8 (and related collations) is now by default an alias for utf8mb3 rather than the other way around. It can be set to imply utf8mb4 by changing the value of the system variable ()

General

• Bundle sys schema ()

• Do not resend unchanged resultset metadata for prepared statements ()

• now listens on both IPv6 and IPv4 addresses ()

• Support systemd socket activation ()

Variables

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

• has been reduced to 1000 ()

InnoDB Variables

The following deprecated variables have been removed ():

Security Vulnerabilities Fixed in

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

• :

• :

• :

• :

List of All Releases

Release date: 9 Feb 2022

This release is no longer available for download after a problem was noticed when manually running mariadb-upgrade. See for more details.Please use a later release.

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

is a release.

Thanks, and enjoy MariaDB!

Download Release Notes Changelog Overview of 10.6

Release date: 4 Feb 2025

MariaDB 10.6 is a current long-term series of MariaDB, maintained until July 2026. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.21 is a Stable (GA) release.

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 (, , )

• 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 error "ERROR 1846 (0A000): ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY". (

• Fix assertion falilure and possible index corruption with unique key and nopad collation without DESC or HASH keys ()

• Fix client crash the command after client sets character set to utf32 ()

• Fix possible runtime error caused by XA RECOVER applying a zero offset to a null pointer ()

• Fix issue where functions in default values in tables with certain character sets could break SHOW CREATE and mariadb-dump ()

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

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 and bugfixes made in , with links to detailed information on each push, see the .

Contributors

For a full list of contributors to , see the .

Download Release Notes Changelog Overview of 10.6

Release date: 1 Nov 2024

MariaDB 10.6 is a current long-term series of MariaDB, maintained until July 2026. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.20 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

• Fix attempt to read outside the bounds of the file: ./ibdata1 ()

• Fix MariaDB crash with SIGILL because the OS does not support AVX512 ()

• Fix deadlock caused by lock_rec_unlock_unmodified() ()

• Fix duplicate key error in table 'mysql.innodb_table_stats' ()

• Fix server crash when calling after is enabled ()

• SELECT MIN on Spider table no longer returns more rows than expected ()

• Fix Spider group by handler wrong result on order by aggregate ()

• Fix Storage Engine S3 that caused 500 error when using Huawai Cloud S3 and possibly other S3 providers ()

  • A new option has been added. s3-provider=Huawai needs to be set for Huawai Cloud S3

  • New option , if true, SSL certificate verification for the S3 endpoint is disabled

Optimizer

• Fix crash caused by query containing constant having clause ()

• Fix assertion with optimizer_join_limit_pref_ratio and 1-table select ()

Data Definition - Alter Table

• Fix InnoDB crash under Windows Subsystem for Linux on ALTER TABLE or OPTIMIZE TABLE ()

• Modification of the column now correctly checks foreign key constraint ()

• Fix incorrect NULL value handling for instantly dropped BLOB columns ()

• Galera updated to 26.4.20

• Fix server crash when setting wsrep_cluster_address after adding invalid value to wsrep_allowlist table ()

• TOI (ALTER) no longer hangs on a parent table if SR transaction is in progress on a child table ()

• Fix INSERT...SELECT' on MyISAM table suddenly replicated by alera ()

Backup

• Recovery now correctly notes some log corruption ()

• InnoDB now correctly merges the change buffer to ROW_FORMAT=COMPRESSED tables ()

• Can now selectively restore sequences using innodb tables from backup ()

JSON

• now properly unquotes strings ()

• default values now allows non-string literals ()

General

• As per the , this will be the last release of for SLES 12, and Windows 11 22H2

• no longer hangs on startup when --init-file target does not exist ()

• LOAD DATA INFILE with geometry data no longer fails ()

• Fix heap-use-after-free in group_concat with compressed or GIS columns ()

Changelog

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

Contributors

For a full list of contributors to , see the .

Download Release Notes Changelog Overview of 10.6

^{Alternate download from mariadb.org}

Release date: 8 May 2025

MariaDB 10.6 is a current long-term series of MariaDB, maintained until July 2026. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.22 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

InnoDB

• Incorrect undo logging for indexes on virtual columns whose index ID does not fit in 32 bits ()

• Race conditions between ALTER TABLE or OPTIMIZE TABLE and the purge of transaction history were fixed. ()

• ASAN errors in dict_sys_t::load_table / get_foreign_key_info after failing to load a table ()

• CREATE INDEX fails to heal a FOREIGN KEY constraint ()

Spider

• The untested ha_spider::index_first_internal constructs broken queries ()

• Unexpected error 1264 'Out of Range Value for Column' when inserting into ... select ... from a spider table ()

• Tests calling the udf spider_copy_tables fail with --view-protocol ()

Optimizer

• group by handler missing constant fields when selecting from a view ()

Data Definition - Alter Table

• Incorrect error handling on DDL with FULLTEXT INDEX ()

• ALTER TABLE…SEQUENCE does not work correctly with InnoDB ()

• The server could crash when an UPDATE is about to commit concurrently with a CREATE INDEX that includes VIRTUAL columns ()

• ALTER TABLE…DROP COLUMN after a failed ALTER TABLE…DROP COLUMN could lead to a server crash ()

GIS

• Server aborts while deleting the record in spatial index ()

Upgrades

• Upgrades fail on Windows ()

Galera

• updated to 26.4.22

• With wsrep_ignore_apply_errors = 0, the node crashes due to assertion thd->is_error() failed in Sql_cmd_dml::prepare(), shown in the logs ()

• In some cases, if there are MDL locks (for example, when LOCK TABLE is executed), a node could get stuck in the system thread due to incorrect handling of metadata locks (MDL) in server code when a transaction was BF aborted. ()

• Regression after the fix for - sometimes the server crashes with an assertion in wsrep::transaction::before_rollback(), for example when using OPTIMIZE TABLE on an ARIA table with wsrep_osu_method=RSU. (

Partitioning

• corruption when query cache cannot allocate block ()

Data Manipulation - Update

• Stack looping and SIGSEGV in Item_args::walk_args on UPDATE ()

Server

• Server crash in find_field_in_tables, Assertion `name' failed in find_field_in_table_ref ()

• Server crash when inserting from derived table containing insert target table ()

• MariaDB effectively running as root CAP_DAC_OVERRIDE ()

• Build fails with cmake 4.0 ()

Plugin - Audit

• Long server_audit_file_path causes buffer overflow ()

General

• As per the , this will be the last release of for Ubuntu 20.04 LTS 'focal'

• Field pointer may be uninitialized in fill_record ()

• Wrong results from tables with a single record and an aggregate ()

Security

• Fixes for the following :

Changelog

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

Release date: 14 Aug 2023

is a previous long-term series of MariaDB, July 2026. It is an evolution of with several entirely new features.

is a release.

Thanks, and enjoy MariaDB!