Download Release Notes Changelog Overview of 10.11

Alternate download from mariadb.org

Release date: 22 May 2025

MariaDB 10.11 is a stable long term series of MariaDB, maintained until February 2028. It is an evolution of MariaDB 10.10 with several entirely new features.

MariaDB 10.11.13 is a Stable (GA) release.

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

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

• Huge performance drop after update ()

• InnoDB buffer pool reserves all assigned memory even with no/minimum load ()

• Possible data loss in the unlikely scenario when GET GLOBAL innodb_buffer_pool_size is shrinking the size of the buffer pool while the buffer pool contains ROW_FORMAT=COMPRESSED tables that use a non-default KEY_BLOCK_SIZE that is equal to innodb_page_size/1024 ()

General

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

Changelog

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

Contributors

For a full list of contributors to MariaDB 10.11.13, see the .

Download Release Notes Changelog Overview of 10.11

^{Alternate download from mariadb.org}

Release date: 6 Nov 2025

MariaDB 10.11 is a stable long term series of MariaDB, maintained until February 2028. It is an evolution of MariaDB 10.10 with several entirely new features.

MariaDB 10.11.15 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

InnoDB

• The InnoDB purge subsystem will no longer reset transaction identifiers in freshly inserted records, because it did severely hurt performance in some workloads. ()

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

• Workloads that are bound by innodb_log_file_size would write out unnecessarily many data pages in an attempt to advance the log checkpoint. (

Aria

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

• Failure to detect corruption during backups of Aria table ()

Connect

• BsonGet_String and JsonGet_String with a NULL argument resulted in an empty string warning. This now has an "Argument is NULL" warning. ()

Federated

• FederatedX error 10000 on multi-table UPDATE/DELETE ()

MyISAM

• myisamchk -V crashes ()

RocksDB

• Corrected python3 compatibility of myrocks_hotbackup thanks to contributor i18n.site ()

Spider

• Server may crash in spider bg mode if multiple queries are sent by spider bg threads consecutively ()

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

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

Sequences

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

Galera

• Setting wsrep_slave_threads causes thread hang when wsrep is not enabled ()

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

• Inconsistency detected - create sequence ()

• InnoDB partition table disallow local GTIDs in galera ()

Plugins

• Change several Plugin Maturity Levels ()

Plugin - Audit

• Wrong query_ids are logged by the server_audit plugin for inserts by triggers when multi-insert statements are used ()

• Fix server_audit rwlock Performance Schema instrumentation ()

Plugin - userstat

• The number of concurrent connections reported by userstats, when enabled, is updated. ()

Plugin - Hashicorp Key Management

• Hashicorp Plugin: enable key version caching by default ()

Optimizer

• Prevent MariaDB server crash when a query includes a derived table containing unnamed column. ()

• Crash when considering Split-Materialized plan ()

• Wrong result when split optimization is used for grouping with order by and limit ()

• Correlated derived table query merges can cause crashes, especially with prepared statements. ()

Optimizer - CTE

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

Parser

• very long query cannot be killed quickly ()

Server

• LIMIT ROWS EXAMINED prematurely triggers during optimization ()

• Exchange partition with virtual columns fails ()

• ALTER TABLE allows adding unique hash key with duplicate values ()

• LOCATE(X,Y,NULL) is not NULL ()

Locking

• DDL in procedure propagates no locking to tables locked by DML ()

Partitioning

• Errors or assertion failure upon REPAIR on partitioned Aria table with misplaced rows ()

Platform RedHat

• On Fedora, RHEL, and derivatives, depend on the mysql-selinux-1.0.14 package that provides the correct selinux rules for the /usr/sbin/mariadbd that is installed. ()

Stored routines

• Crash when calling stored function in FOR loop argument ()

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

JSON

• Corrected the creation of views on JSON_TABLEs to require no special privileges. ()

• View containing JSON_TABLE does not return JSON ()

• Wrong result json_table ()

• Correct return value of JSON_VALUE which in the previous release, incorrectly converted a valid empty string return value to a NULL. This has been reverted to correct behaviour. ()

Packaging

• A tmpfiles file will now create /run/mysqld path on Debian/Ubuntu packaged distributions. ()

• server cannot load client plugins on Debian ()

• Previous systemd warnings in recent systemd versions about uninitialised environment variables have been corrected. ()

• The PrivateDevices=false directive in the systemd service has been removed as it was an old kernel incompatibility that this directived worked around. With this, the MariaDB is restricted further. Those using InnoDB on raw devices will need to add an override for this. See https://mariadb.com/docs/server/server-management/starting-and-stopping-mariadb/systemd#useful-systemd-options (

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

• Using mytop with DBD-MariaDB and host=localhost specified resulted in an unexpected error because the driver did not expect a port 3306. Contribution thanks to Jean Weisbuch. ()

Versioned Tables

• REPLACE on a precise-versioned table returns duplicate key error (ER_DUP_ENTRY) ()

Prepared Statements

• Parameterized PS converts error to warning, causes replication problems ()

mariabackup

• Fixed bug in maria-backup where maria-backup would crash during the 'maria_recovery' part.

This could happen if server was doing repair or creating indexes while the

backup was running. ()

Platform Windows

• On Windows, when MSI package is installed, with ADDLOCAL parameter passed to msiexec.exe, and Visual C++ Redistributable package is not installed on the target machine, installation may fail during "create database" step. ()

Replication

• Fix --master-retry-count=0 not infinite as described ()

• Ensure that Annotate_rows is always written direct after GTID information, before any table_map events. Before this patch the event could be written in a random position in the binary log. This change make the place of the Annotate_rows event predictable.

  • When mixing transactional and not transactional tables in the same transaction, the Annotate rows event was not always written in the case of a rollback. This is now fixed. ()

Configuration

• Galera galera_new_cluster scipt and its systemd interactions was rewritten to avoid selinux errors. This will require the mysql-selinux-1.0.14+ version that is a dependency of the server in RPM+selinux distributions. ()

Changelog

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

Download Release Notes Changelog Overview of 10.11

Release date: 1 Nov 2024

MariaDB 10.11 is a stable long term series of MariaDB, maintained until February 2028. It is an evolution of MariaDB 10.10 with several entirely new features.

MariaDB 10.11.10 is a Stable (GA) release.

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

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

InnoDB

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

Security

• Fixes for the following :

  • CVE--``#

Changelog

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

Contributors

For a full list of contributors to , see the .

Release date: 7 Jun 2023

is the current long term maintenance development series of MariaDB, February 2028. It is an evolution of with several entirely new features.

is a release.

For an overview of see the page.

Thanks, and enjoy MariaDB!

Download Release Notes Changelog Overview of 10.11

^{Alternate download from mariadb.org}

Release date: 6 Aug 2025

MariaDB 10.11 is a stable long term series of MariaDB, maintained until February 2028. It is an evolution of MariaDB 10.10 with several entirely new features.

MariaDB 10.11.14 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

InnoDB

• Fatal InnoDB error: Unknown error Temp file write failure ()

• When innodb_buffer_pool_size is being shrunk while there are no data pages cached, InnoDB could hang or crash. ()

• After a successful shrinking of innodb_buffer_pool_size, there will be no message about it in the server error log.

  • After a failed shrinking of innodb_buffer_pool_size, the adaptive hash index will not be re-enabled if innodb_adaptive_hash_index was ON when SET GLOBAL innodb_buffer_pool_size=... started to execute. (

Data Definition - Alter Table

• Adding (with ALTER TABLE) a UNIQUE constraint that is USING HASH to a table with foreign keys could've caused the table to become corrupted. ()

• DROP DEFAULT makes SHOW CREATE non-idempotent ()

Data Definition - Create Table

• CREATE OR REPLACE with self-referencing CHECK hangs forever, cannot be killed ()

Data Manipulation - Insert

• UNIQUE constraint that was USING HASH and UNIQUE constrant WITHOUT OVERLAPS could be violated under heavy load in READ COMMITTED transaction isolation mode. ()

Partitioning

• Server crashes in do_mark_index_columns instead of ER_DUP_ENTRY on partitioned table ()

• A replica would crash while replicating UPDATE and DELETE DML statements that target a table which previously had a partition that was converted to a separate table via ALTER TABLE .. CONVERT PARTITION .. TO TABLE. For example, if the command looked like ALTER TABLE t1 CONVERT PARTITION p1 TO TABLE t_new; the replica would crash when trying to update/deleterows in table t1 after running the command. ()

Server

• Segfault on INTERSECT ALL with UNION in Oracle mode ()

• In certain cases privileges on sequences were too restrictive, for example, SELECT on a table might've erroneously required INSERT privilege on a sequences ()

mariadb-backup

• This commit fixes a bug where Aria tables are used in (master->slave1->slave2) and a backup is taken on slave2. In this case it is possible that the replication position in the backup, stored in mysql.gtid_slave_pos, will be wrong. This will lead to replication errors if one is trying to use the backup as a new slave ()

• Maria-backup would crash during the 'maria_recovery' part. This could happen if server was doing repair or creating indexes while the backup was running. ()

Optimizer

• MariaDB server crash when a query includes a derived table containing unnamed column. ()

• Crash in add_keyuses_for_splitting() when joining with a derived table ()

• Don't generate index_merge plans, if a column is present in both Secondary Key and Primary Key indexes and either of the indexes include it with DESC order (as the scan itself is not a ROR scan). ()

JSON

• Starting from 10.11.12, Incorrect handling of UTF-8 characters (and other character sets requiring more than a single byte representation) in the minimum/maximum positions of a table during the execution of ANALYZE TABLE tbl PERSISTENT FOR ALL resulted in an endless loop consuming more memory and prevented the server from terminating. ()

Galera

• updated to 26.4.23

• galera_3nodes.inconsistency_shutdown test occasionally hangs ()

• Galera-26.4.23 corrects an incompatibility with OpenZFS >= 2.3.0 enabling the use of galera on this filesystem.

Replication

• semi sync makes the master unresponsive when a replica is stopped ()

• parallel slave ALTER-SEQUNCE attempted to binlog out-of-order ()

• mysqldump --dump-slave always starts stopped slave ()

• Optimize Rows_log_event Reporting of Process Info ()

Stored routines

• Crash when calling stored function in FOR loop argument ()

Authentication and Privilege System

• ALTER TABLE require ALTER privilege on sequence from DEFAULT value expression ()

Locking

• Deadlock does not rollback transaction fully ()

Character Sets

• Changing the server character set in my.cnf could cause debian-start script to fail with "Illegal mix of collations" ().

Packaging

• mariadb systemd mult-instance service was changed to not attempt changes to the permissions on its pam helper server. This prevented unconstructive behaviour and errors in the systemd journal when starting the mariadb@.service. ()

Sequences

• Remove the error codes added to 10.11 by the MDEV-36032 patch ()

XA

• DML committed within XA transaction block after deadlock error and implicit rollback ()

General

• Add option to not collect statistics for long char/varchars ()

• Packages for RHEL8 no longer depend on liburing. The RHEL8 kernel had insufficient kernel support so linking was an unneeded dependency. libaio was sufficient ()

• SLES 15 SP6 is a new package in this release. Because of incompatibilities of packages between SLES service pack versions there are now separate packages for 15sp6. An upgradeable repo file should include "sles/$releasever/$basearch" rather than the "sles15-amd64" or "sles/15/x86_64" path that may exist currently. (, )

Changelog

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

is a stable long term series of MariaDB, February 2028. 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 date: 4 Feb 2025

is a stable long term series of MariaDB, February 2028. It is an evolution of with several entirely new features.

is a release.

For an overview of see the page.

Thanks, and enjoy MariaDB!

Download Release Notes Changelog Overview of 10.11

Release date: 8 Aug 2024

MariaDB 10.11 is a stable long term series of MariaDB, maintained until February 2028. It is an evolution of MariaDB 10.10 with several entirely new features.

MariaDB 10.11.9 is a Stable (GA) release.

For an overview of MariaDB 10.11 see the What is MariaDB 10.11? 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 .

Download Release Notes Changelog Overview of 10.11

Release date: 16 Feb 2023

MariaDB 10.11 is a long term maintenance release series of MariaDB, maintained until February 2028. It is an evolution of MariaDB 10.10 with several entirely new features.

MariaDB 10.11.2 is a Stable (GA) release.

For an overview of MariaDB 10.11 see the What is MariaDB 10.11? page.

Thanks, and enjoy MariaDB!

Notable Items

• As mentioned in the , our Yum/DNF/Zypper repositories for Red Hat Enterprise Linux, CentOS, Fedora, openSUSE, and SUSE are changing with this release to being signed with a new GPG key with SHA2 digest algorithms instead of SHA1. See and the page for more details.

InnoDB

• corruption with ()

• recovery and backup fixes (, , )

• Upgrade after a crash is not supported ()

• Remove load throttling ()

Galera

• Fixes for cluster wide write conflict resolving ()

Replication

• Parallel slave applying in binlog order is corrected for admin class of commands including ANALYZE ()

• is now shown now more precisely at the slave applier start, including in the delayed mode ()

• is made to show the type of compressed columns ()

• Deadlock is resolved on replica involving BACKUP STAGE BLOCK_COMMIT

General

• Infinite sequence of recursive calls when processing embedded CTE ()

• Crash with a query containing nested WINDOW clauses ()

• Major performance regression with 10.6.11 ()

• Json Range only affects first row of the result set ()

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 .

Download Release Notes Overview of 10.11

Release date: 26 Sep 2022

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

Unlike recent new releases, MariaDB 10.11.0 is a single preview release. Features are to be considered preview, and none are guaranteed to make it into MariaDB 10.11.

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

For an overview of MariaDB 10.11 see the What is MariaDB 10.11? page.

Thanks, and enjoy MariaDB!

Authentication

• Windows - passwordless login for mariadb root user, for OS admin users, using the ()

• () ()

• Separate and privileges ()

Optimizer

• Semi-join optimization for single-table update/delete statements ()

• Allow pushdown of queries involving UNIONs in outer select to foreign engines ()

• Make show time spent in the query optimizer ()

Information Schema

• Performance Issues reading the ()

• Full table scan in the and tables ()

System versioning

• setting, , to allow history modification ()

• : dump and restore historical data ()

InnoDB

• and are now dynamic, and their values can be changed without restarting the server ()

General

• Rename variables ()

  • (min_examined_row_limit)

  • (slow_query_log)

  • (slow_query_log_file) This will be renamed to in the next release.

Do not use alpha releases on production systems! For a complete list of changes made in , with links to detailed information on each push, see the .

Release date: 17 Nov 2022

is a 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!

MariaDB 10.11 is a long-term maintenance release series, maintained until February 2028.

Upgrading

• See and .

New Features & Improvements

This list includes features from the short-term releases , , and .

Authentication

• () ()

• Separate and privileges ()

• now accepts a comma-separated list of addresses to bind to ()

• password_reuse_check plugin 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. (

Optimizer

• Make show time spent in the query optimizer ()

• Improve optimization of joins with many tables, including eq_ref tables (, )

• Table elimination does not work across derived tables (, )

• Histograms in the statistics tables are more precise and stored as JSON, not binary (, ,

Descending Indexes

• Individual columns in the can now be explicitly sorted in the ascending or descending order. This can be useful for optimizing certain cases (, , , , ).

Replication

• Change defaults for CHANGE MASTER TO so that GTID-based replication is used by default if master supports it (, )

• Added system variable for SQL thread to limit maximum execution time per query replicated (, )

• Deprecate to favor new option (, )

• Implement the --do-domain-ids, --ignore-domain-ids, and --ignore-server-ids options for

mysqlbinlog GTID support

• (or mysqlbinlog as it was called back when the task was created) now supports both filtering events by GTID ranges through --start-position and --stop-position, and validating a binary log's ordering of GTIDs through --gtid-strict-mode (, ).

Galera

• Implement a method to add IPs to allowlist for Galera Cluster node addresses that can make SST/IST requests (, )

• JSON file interface to wsrep node state / SST progress logging (, )

JSON

• function (, )

• Implement range notation for (, )

• Support negative index (, )

• function to check for equality between JSON objects (,

UUID

• New (, )

SHOW ANALYZE FORMAT=JSON

• Extend to support SHOW ANALYZE [FORMAT=JSON] (, )

• Add EXPLAIN FOR CONNECTION syntax support to (, )

Information Schema

• Performance Issues reading the ()

• Full table scan in the and tables ()

System versioning

• setting, , to allow history modification ()

• : dump and restore historical data ()

• Add option to as of specified timestamp (, ).

InnoDB

• InnoDB performance improvements (, , , , , , , )

• In bulk insert, pre-sort and build indexes one page at a time (, )

InnoDB Redo Log Improvements

• autosize (, ).

• Improve the for concurrency (, ).

• Remove FIL_PAGE_FILE_FLUSH_LSN (, ).

UCA14 Collation

• Add UCA-14.0.0 (, )

• Improve contraction performance in UCA collations (, )

• Improve UCA collation performance for utf8mb3 and utf8mb4 (, )

Windows

• for mariadb root user, for OS admin users ()

• On newer versions of Windows (Windows 10 1903 or later), the mariadb client defaults to the utf8mb4 character set. Several problems with Unicode input and output in client were fixed. Command line utilities now accept all Unicode characters in user names, database names, file names etc (in the past, characters were restricted to the current ANSI codepage) ().

Spider Storage Engine

• This was mostly internal refactoring work. As a result one can now declare connections using the REMOTE_SERVER, REMOTE_DATABASE, and REMOTE_TABLE attributes and not abuse the COMMENT field for that. This works both for the whole table and per partition (, , ).

Convert Partitions

• ALTER TABLE ... CONVERT PARTITION .. TO TABLE (, ), and

• ALTER TABLE ... CONVERT TABLE ... TO PARTITION ... () as an easy way to convert tables to partitions and back in one command, instead of a sequence of CREATE/EXCHANGE/DROP ()

Miscellaneous

• Add function (, )

• The data type (, )

• Re-design the upper level of handling UPDATE and DELETE statements (, )

• Deprecate the / functions (,

Variables

• For a list of all new variables, see .

• Rename variables ()

  • (min_examined_row_limit)

  • (slow_query_log)

InnoDB Variables

• and are now dynamic, and their values can be changed without restarting the server ()

• Removed (, )

• Deprecated ()

• Deprecated ()

Spider 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

Download Release Notes Changelog Overview of 10.11

Release date: 16 May 2024

MariaDB 10.11 is a stable long term series of MariaDB, maintained until February 2028. It is an evolution of MariaDB 10.10 with several entirely new features.

MariaDB 10.11.8 is a Stable (GA) release.

For an overview of MariaDB 10.11 see the What is MariaDB 10.11? 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 ()

• Fix spider plugin init failure with no_zero_date sql_mode (

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 .

Download Release Notes Changelog Overview of 10.11

Release date: 10 May 2023

MariaDB 10.11 is the current long term maintenance development series of MariaDB, maintained until February 2028. It is an evolution of MariaDB 10.10 with several entirely new features.

MariaDB 10.11.3 is a Stable (GA) release.

For an overview of MariaDB 10.11 see the What is MariaDB 10.11? page.

Thanks, and enjoy MariaDB!

Notable Items

InnoDB

• Crash on in a table ()

• UNIQUE USING HASH accepts duplicate entries for tricky collations ()

• rec_get_offsets() is not optimal ()

• Performance regression in fil_space_t::try_to_close() introduced in ()

Backup

• mariadb-backup doesn't utilise innodb-undo-log-directory (if specified as a relative path) during copy-back operation ()

• mariadb-backup issues error messages during InnoDB tablespaces export on partial backup preparing ()

• mariadb-backup does not copy Aria logs if aria_log_dir_path is used ()

• Race condition between buffer pool flush and log file deletion in mariadb-backup --prepare ()

Replication

• Fixed a deadlock on parallel slave involving full image Write event on the sequence engine ()

• Fixed an attempted out-of-order binlogging error on slave involving ALTER on the sequence engine ()

• Corrected non-versioned master to versioned slave replication on no-unique attribute table ()

• Mended encrypted binlog master to error out to gtid-mode slave when master could not decrypt a binlog file ()

Optimizer

• optimization is improved to re-fill the materialized table only if necessary. The fewer number of table refills is taken into account when choosing query plan, too ()

• New optimizer_switch option, , is added. It is off by default. When set to ON, the optimizer will produce tighter bounds for hash join output cardinality. ()

• Queries using SELECT DISTINCT some_expression(aggregate_function()) could produce wrong query result. ()

Docker Official Image

• Add replication setup to containers contributed by Md Sahil ()

• Added LTS tags for easier identification of LTS releases:

  • lts-jammy

  • lts

General

• As per the , this will be the last release of for Fedora 36.

• In this release repositories for Fedora 38 and Ubuntu 23.04 Lunar have been added.

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 .