All pages
Powered by GitBook
1 of 32

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Release Notes - MariaDB 10.5 Series

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

MariaDB 10.5.29 Release Notes

Download Release Notes Changelog Overview of 10.5

Release date: 8 May 2025

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

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

Data Definition - Alter Table

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

GIS

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

Upgrades

  • Upgrades fail on Windows ()

OTHER

  • Field pointer may be uninitialized in fill_record ()

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

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

Optimizer

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

Security

  • Fixes for the following :

Changelog

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

Contributors

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

MariaDB 10.5.28 Release Notes

Release date: 4 Feb 2025

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

is a release.

Thanks, and enjoy MariaDB!

MariaDB 10.5.6 Release Notes

Release date: 7 Oct 2020

is the current stable series of MariaDB. It is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

is a release.

Thanks, and enjoy MariaDB!

MariaDB 10.5.8 Release Notes

Release date: 11 Nov 2020

is the current stable series of MariaDB. It is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

is a release.

Thanks, and enjoy MariaDB!

)
  • In Galera, creating sequence with a small cache leads to signal 6 error: [ERROR] WSREP: FSM: no such a transition REPLICATING -> COMMITTED. (MDEV-33850)

  • Assertion `commit_trx' failed in innobase_commit() (ha_innodb.cc). An INSERT with sql_log_bin=0 is still replicated in Galera (per MDEV-7205), despite binary logging being disabled. This results in a partial binlog bypass, requiring a two-phase commit (2PC). During 2PC, the INSERT is first prepared (entering the PREPARED state in InnoDB), and on commit, the new assertion from MDEV-24035 fails, causing a crash with "Assertion 'commit_trx' failed" in logs. (MDEV-35658)

  • When a sequence is used and inserts run in parallel on multiple Galera nodes, a transaction may be aborted after passing certification. If it then attempts to roll back, the binlog statement cache—which includes reserved sequence values—may be written prematurely. This causes a crash with the diagnostic "WSREP: FSM: no such a transition REPLICATING -> COMMITTED" in the logs, as the transaction is supposed to replay and only write to the binlog during the final commit. (MDEV-33589)

  • After a corrupted table on one node triggers the cluster to vote to evict a node that failed a transaction, the current master can't commit any more and hangs. To avoid this crash in the future, the user should also update the galera library to version 26.4.21+. (MDEV-34998)

  • Creating partitioned tables is disallowed when wsrep_osu_method=TOI and wsrep_strict_ddl=ON, preventing alteration or deletion of partitioned tables. (MDEV-27861)

  • Attempting to create a CONNECT engine table results in "non-InnoDB sequences in Galera cluster" error message in logs due to an incorrect engine check. (MDEV-35748)

  • Build fails with cmake 4.0.0 due to wsrep (MDEV-36422)

  • CVE-2023-52969

    MDEV-36613
    MDEV-36324
    MDEV-35874
    MDEV-36335
    MDEV-36038
    MDEV-35420
    MDEV-36128
    MDEV-36181
    MDEV-35238
    MDEV-35946
    MDEV-35941
    MDEV-31413
    MDEV-34075
    MDEV-31647
    MDEV-25012
    MDEV-32086
    MDEV-36229
    MDEV-36506
    MDEV-36245
    MDEV-36307
    CVE-2025-30722
    CVE-2025-30693
    CVE-2023-52970
    changelog
    MariaDB Foundation release announcement
    Galera
    MDEV-32631
    Notable Items

    Storage Engines

    • Fix assertion failure on cascading foreign key update of table with vcol index in parent (MDEV-29182)

    • Fix issue where ON UPDATE SET NULL could not be specified on a NOT NULL column (MDEV-35445)

    • Fix possible crash on DELETE from a HEAP table (MDEV-22695)

    Spider

    • Fix possible Spider thread hang in 'Update' state on 2nd INSERT (MDEV-35064)

    • Fix incorrect formatting of timestamp during parsing of a binary log, causing point in time recovery discrepancies (MDEV-31761)

    • can now correctly process more than one logfile when --stop-datetime is specified (MDEV-35528)

    • Setting pseudo_thread_id to a value exceeding 4 bytes previously resulted in truncation when written to the binary log (MDEV-35646)

    Optimizer

    • Fix server crash in get_sort_by_table/make_join_statistics after INSERT into a view with ORDER BY (MDEV-29935)

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

    • NULL-aware materialization with IN predicate and single column no longer skips building sorted Ordered_key structures (MDEV-34665)

    • Fix possibly wrong result using a degenerated subquery (SELECT ) with window function ()

    Partitioning

    • History is now stored on the same partitions on different Galera nodes when system versioning is enabled (MDEV-35096)

    • Fix possible hang or crash during InnoDB purge with HASH indexes during ALTER TABLE (MDEV-25654)

    • EXCHANGE PARTITION now works for tables with unique blobs (MDEV-35612)

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

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

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

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

    Galera

    • Galera 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 sporadic failure of async replication on Galera async replica nodes with parallel replication enabled (MDEV-35465)

    • Fix possible failure of wsrep_sst_rsync SST script if user specified aria_log_dir_path different from default data directory ()

    • Fix cluster node hang during shutdown if threadpool is used ()

    • MariaDB Cluster and ALTER INPLACE running in Total Order Isolation (wsrep_OSU_method=TOI) now correctly abort a DML INSERT operation in InnoDB ()

    • Fix possible crash in wsrep_check_sequence ()

    • Fix sporadic reporting of success when a deadlock error occurs under --ps-protocol BF aborted transaction ()

    • Rows in table mysql.gtid_slave_pos are now correctly deleted on Galera nodes when wsrep_gtid_mode = 1 is used, which previously lead to wrong information about replica delays ()

    • Undefined behavior could occur when attempting to perform INSERT DELAYED on a Galera cluster node. ()

    • Fix issue where DROP TABLE on child and UPDATE of parent table can cause a metadata lock BF-BF conflict when applied concurrently. ()

    • Galera protocol versions are now shown by show status - change available with installation of galera library 26.4.21+ ()

    • Fix possible crash in wsrep_sst_mariadb-backup script when upgrading node in cluster from 10.11.9 to 10.11.10. ()

    • wsrep_sst_mariadb-backup.sh no longer uses --use-memory default (100MB) resulting in prepare stage which could take hours ()

    • For an authentication with the the password of the CREATE USER statement is now masked in the audit log (MDEV-35507)

    • MariaDB Audit now detects all DCLs forms for masking a password (MDEV-35522)

    General

    • Fix possible crash where server could not construct a geomery object from the input (MDEV-33987)

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

    • After changing the table definition for the system table 'mysql.servers', a following execution of CREATE SERVER would previously lead to a server crash.

      • NOTE: System tables should never be modified by a user anyhow ()

    • Fix connection hang after query on a partitioned table with UNION and LIMIT ROWS EXAMINED ()

    • Fix possible crash during index traversal using tree_search_next. ()

    • FIx assertion failure where CURRENT_USER was not correctly copied during condition pushdown ()

    • sql_mode='NO_UNSIGNED_SUBTRACTION' now works for multiple unsigned integers ()

    • The "Failed to write to mysql.slow_log" error no longer shown without a detailed reason for the error ()

    • Can now correctly add a foreign key on a table with a long UNIQUE multi-column index that contains a foreign key as a prefix ()

    • During an online table rebuild of an InnoDB statistics table, opt_search_plan_for_table() no longer sometimes degrades to full table scan ()

    • Fix debian-start script failure when using non-standard socket path ()

    • Fixed issue where ST_PointFromWKB ignored SRID parameter and returned 0 ()

    • Fix possible memory leak on SHUTDOWN ()

    • Fix possible memory leak while shutting down server after installing the auth_gssapi plugin ()

    • Fix possible server crash when using INSERT DELAYED on tables with virtual columns. ()

    • Fix possible Spider crash or hang when the first byte of a connection key is changed ()

    • A BEFORE INSERT Trigger previously returned with error ""Field 'xxx' doesn't have a default value", if a NULL value is added for a column defined NOT NULL without explicit value and no DEFAULT specified ()

    • Calling a stored routine that executes a join on three or more tables and referencing not-existent column name in the USING clause could previously result in a crash on its second invocation. ()

    • Fix rare cases where binlog entries could receive incorrect timestamps on secondary nodes of a Galera cluster, potentially impacting replication accuracy ()

    Security

    • Fixes for the following :

      • CVE-2025-21490

    Changelog

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

    Contributors

    For a full list of contributors to MariaDB 10.5.28, see the MariaDB Foundation release announcement.

    Download
    Release Notes
    Changelog
    Overview of 10.5
    MariaDB 10.5
    maintained until
    MariaDB 10.4
    MariaDB 10.5.28
    Stable (GA)
    Notable Changes
    • Fixes for the following :

      • CVE-2020-15180

    Changelog

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

    Contributors

    For a full list of contributors to MariaDB 10.5.6, see the MariaDB Foundation release announcement.

    Download
    Release Notes
    Changelog
    Overview of 10.5
    MariaDB 10.5
    MariaDB 10.4
    MariaDB 10.5.6
    Stable (GA)
    Notable Changes
    • Out-of-cycle release to fix regressions in MariaDB 10.5.7

    • Follow up to MDEV-19838 to alter protocol checks to support the following implementations (which add garbage to the end of some packets):

      • PHP PDO (all versions) (MDEV-24121)

      • mysqlnd (from PHP < 7.3) (MDEV-24121)

      • mysql-connector-python (all versions) ()

      • and mysql-connector-java (all versions)

    • Arbitrary InnoDB buffer pool and data file corruption ()

    • The query optimizer consumed a lot of memory when handling construct in form of key_column [NOT] IN (large-list-of constants) ()

    • Fixes for the following :

      • CVE--``#

    Changelog

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

    Contributors

    For a full list of contributors to MariaDB 10.5.8, see the MariaDB Foundation release announcement.

    Download
    Release Notes
    Changelog
    Overview of 10.5
    MariaDB 10.5
    MariaDB 10.4
    MariaDB 10.5.8
    Stable (GA)
    MDEV-35869
    MDEV-34813
    MDEV-35387
    MDEV-35710
    MDEV-33064
    MDEV-33245
    MDEV-35446
    MDEV-34924
    MDEV-35852
    MDEV-35018
    MDEV-35505
    MDEV-35526
    MDEV-35749
    MDEV-33783
    MDEV-35571
    MDEV-28130
    MDEV-35090
    MDEV-35651
    MDEV-20281
    MDEV-33658
    MDEV-35443
    MDEV-35907
    MDEV-32619
    MDEV-35326
    MDEV-35575
    MDEV-26891
    MDEV-34849
    MDEV-19761
    MDEV-24935
    MDEV-35157
    MDEV-24134
    MDEV-24096
    MDEV-24117

    MariaDB 10.5.1 Release Notes

    Download Release Notes Changelog Overview of 10.5

    Release date: 14 Feb 2020

    MariaDB 10.5 is the current development series of MariaDB. 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.1 is a Beta release.

    Thanks, and enjoy MariaDB!

    Notable Changes

    This will be the first beta release in the series.

    Notable changes of this release include:

    InnoDB

    • Remove dummy tablespace for the ()

    • Optimize access to InnoDB page header fields ()

    • Remove multiple instances ()

      • Deprecate and ignore and

    Optimizer

    • Allow packed values of non-sorted fields in the sort buffer ()

    Replication and Galera

    • now defaults to optimistic ().

    • Make REPLICA a synonym for ()

    • support ()

    • Add new mode to wsrep_OSU_method in which Galera checks storage engine of the effected table (

    PCRE

    • Migrate to ()

    Compatibility

    • Show internal type for TIMESTAMP, DATETIME, and TIME columns ()

    Variables

    • Numerous deprecated variables removed ()

    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!

    MariaDB 10.5.4 Release Notes

    Download Release Notes Changelog Overview of 10.5

    Release date: 24 Jun 2020

    MariaDB 10.5 is the current stable series of MariaDB. 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.4 is a Stable (GA) release.

    Thanks, and enjoy MariaDB!

    Notable Changes

    This is the first Stable (GA) release in the series.

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

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

    • New version of the , 3.3.15.

    • now reliably deletes table remnants inside a storage engine even if the .frm file is missing (

    Variables

    • Limit to 255 ().

    • Minimum value of raised to 8 (previously 4) so fixed size like and are not truncated for lower values of max_sort_length ().

    InnoDB

    • improvements: , ,

    • InnoDB Performance improvements: , , , ,

    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.5.25 Release Notes

    Release date: 16 May 2024

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

    is a release.

    Thanks, and enjoy MariaDB!

    MariaDB 10.5.26 Release Notes

    Release date: 8 Aug 2024

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

    is a release.

    Thanks, and enjoy MariaDB!

    Columns that indicated the buffer pool instance from the Information Schema , , , and tables now return a dummy value of 0.

  • Deprecate and ignore (MDEV-19747)

  • Prefer MDL to dict_sys.latch for innodb background tasks (MDEV-16678)

  • Use fdatasync() for redo log where appropriate (MDEV-21382)

  • Replace recv_sys.heap with list of buf_block_t (MDEV-21351)

  • Several fixes to server hangs (MDEV-16264)

  • )
  • Galera: Replicate MariaDB GTID to other nodes in the cluster (MDEV-20720)

  • MariaDB 10.5
    MDEV-18115
    MDEV-21133
    MDEV-15058
    MDEV-21263
    MDEV-18648
    MDEV-20601
    commit
    MDEV-14024
    MDEV-19906
    MDEV-18650
    MariaDB 10.5.1
    changelog
    MariaDB 10.5.1
    MariaDB Foundation release announcement
    Galera
    MDEV-20051

    The most recent release of MariaDB 10.5 is:

    Stable (GA)

    )
  • Accelerated crc32() function for AMD64, ARMv8, POWER 8 (MDEV-22669)

  • Lots of bug fixes, see the changelog.

  • updated to 26.4.5

  • MariaDB 10.5
    Gamma
    MDEV-22258
    MDEV-22715
    MDEV-8069
    MDEV-11412
    MDEV-22456
    MDEV-15053
    MDEV-22593
    MDEV-22697
    MDEV-22871
    MDEV-22841
    MariaDB 10.5.4
    changelog
    MariaDB 10.5.4
    MariaDB Foundation release announcement
    MariaDB ColumnStore
    MDEV-11412

    The most recent release of MariaDB 10.5 is:

    Stable (GA)

    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

    • Fix adaptive hash index corruption after (MDEV-33400)

    • Fix fatal InnoDB error or assertion ``!is_v'` failure upon multi-update with indexed virtual column (MDEV-31154)

    • Fix InnoDB: Failing assertion on UPDATE (MDEV-32346)

    • Fix fatal error InnoDB: Clustered record field for column x not found (MDEV-33558)

    • Fix alter operation hang when encryption thread works on the same tablespace ()

    • Fix MariaDB segfault on rowid filter query involving generated column ()

    • Fix discard/import tablespace, restart, index corruption ()

    • Fix alter table corruption while applying the modification log ()

    • Fix weird read view after ROLLBACK of other transactions ()

    • Read only server no longer throws error when running a create temporary table as select statement ()

    • Change buffer index no longer fails to delete the records ()

    • Fix InnoDB include OS error information when failing to write to iblogfile0 ()

    • In-place migration from MySQL 5.7 no longer causes invalid AUTO_INCREMENT values ()

    • Fix InnoDB log corruption before upgrading it on startup ()

    • Table no longer gets rebuilt with ALTER TABLE ADD COLUMN ()

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

    • Improve Spider performance by pushing down function (MDEV-28992) and statement (MDEV-28993) to data nodes

    • Fix server crash when deleting partitions from a table with spider engine (MDEV-33731)

    • Fix spider plugin init failure with no_zero_date sql_mode (MDEV-33494)

    • Fix sql plugin init failure with traditional sql_mode (MDEV-33584)

    • Fix parsing failure on valid left join select by translating the on expression to () ()

    • Fix Spider: ERROR 12710 (HY000): Invalid information from remote table when using local and remote ()

    • Fix Spider: @@insert_id 128 to TINYINT: Assertion ``!is_set() || (m_status == DA_OK_BULK && is_bulk_op())'` failed. ()

    • Fix bug where were not available if Spider was loaded upon server startup ()

    Backup

    • mariadb-backup now preserves (MDEV-33334)

    • Fix mariadb-backup problem on older mariadb (opendir(NULL)) caused by MDEV-30968 (MDEV-31251)

    • Fix mariadb-backup --backup FATAL ERROR: ... Can't open datafile cool_down/t3 (MDEV-33011)

    • mariadb-backup --backup now includes retry logic for undo tablespaces (MDEV-33980)

    • Fix crash recovery in due to insufficient ()

    • Fix crash in after --prepare ()

    • now considers O/S user when --user option is omitted ()

    ,

    • Fixed improper application of COLLATE to non-character columns (MDEV-33318)

    • Default charset now works with PHP MySQLi extension (MDEV-32975)

    • Fixed Bad SEPARATOR value in on character set conversion (MDEV-33772)

    • Fixed out of range error in (()) due to a wrong data type (MDEV-33496)

    • Fixed and problems with ()

    JSON

    • View created via now returns correct json object (MDEV-30646)

    • now detects the type of String Values and correctly returns Date/DateTime values (MDEV-19487)

    • no longer returns NULL on valid arguments (MDEV-22141)

    • no longer returns multiple values for same path (MDEV-32287)

    Encryption, TLS, SSL

    • WolfSSL's math is unnecessarily slow (MDEV-33482)

    Optimization & Tuning

    • Server crashes in JOIN_CACHE::write_record_data upon EXPLAIN with subqueries and constant tables (MDEV-21102)

    • Wrong result with cross Join given join order (MDEV-30975)

    • Wrong warnings on 2-nd execution of PS for query with GROUP_CONCAT (MDEV-31276)

    • Wrong result with semi-join and splittable derived table (MDEV-23878)

    • Aggregation functions fail to leverage uniqueness property ()

    Plugins

    • The now reports the user and host in all cases (MDEV-33393)

    Replication

    • --gtid-ignore-duplicate can double-apply event in case of parallel replication retry (MDEV-33475)

    • Server crash in Rows_log_event::update_sequence upon replaying binary log (MDEV-31779)

    • Slave crashed:reload_acl_and_cache during shutdown (MDEV-30260)

    • When binlog_annotate_row_events on , event of binlog file is truncated (MDEV-9179)

    Galera

    • 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

    SQL, Data Definition, and Data Manipulation

    • Transportable Tablespaces no longer leave in a mismatched state (MDEV-18288)

    • Fix wrong row targeted with "insert ... on duplicate" and "replace", leading to data corruption (MDEV-30046)

    • Fix incorrect DEFAULT expression evaluated in (MDEV-33790)

    • Fix incorrect handling of in PS mode when a table's column declared as NOT NULL (MDEV-33549)

    • Fix crash in EXECUTE IMMEDIATE 'CREATE OR REPLACE TABLE t1 (a INT DEFAULT ?)' USING DEFAULT ()

    • Fix wrong result on 2nd execution of PS to select from view using derived ()

    • value of '1970-01-01 00:00:00' can no longer be indirectly inserted in ()

    • Fix zero datetime reinterpreting as '1970-01-01 00:00:00' on field_datetime=field_timestamp ()

    • unix_timestamp(coalesce(timestamp_column)) no longer returns NULL on '1970-01-01 00:00:00.000001' ()

    • Fix crash using UDF in WHERE clause of VIEW ()

    • Fix update for portion changes autoincrement key in period table ()

    • Fix SIGABRT resulting from CREATE TABLE with generated column and RLIKE ()

    General

    Scripts & Clients

    • It's now possible to disable system commands with the option. (MDEV-21778)

    • now exports the data with sandbox mode enable, so that the mariadb client will not execute potentially dangerous cli commands.(MDEV-33727)

    • commands such as mariadb-dump --dump-slave=2 --master-data=2 now record both positions (MDEV-4827)

    • Loading now works with INPLACE () )

    Server

    • Original IP not shown in network related error messages when proxy_protocol is in use (MDEV-33506)

    • Server incorrectly describes known variables as UNKNOWN if invalid values are specified at startup (MDEV-33469)

    • update case insensitive (large) unique key with insensitive change of value - duplicate key (MDEV-29345)

    • MariaDB will abort server startup if it finds an invalid parameter, but won't check for other invalid params (MDEV-26923)

    Security

    • Fixes for the following :

      • CVE-2024-21096

    Changelog

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

    Contributors

    For a full list of contributors to MariaDB 10.5.25, see the MariaDB Foundation release announcement.

    Download
    Release Notes
    Changelog
    Overview of 10.5
    MariaDB 10.5
    maintained until
    MariaDB 10.4
    MariaDB 10.5.25
    Stable (GA)

    The most recent release of MariaDB 10.5 is:

    Stable (GA)

    Notable Items

    Storage Engines

    InnoDB

    • Alter operation on redundant table aborts the server (MDEV-34222)

    • MariaDB crashes with SIGILL because the OS does not support AVX512 (MDEV-34565)

    • InnoDB: Failing assertion: stat_n_leaf_pages > 0 in ha_innobase::estimate_rows_upper_bound (MDEV-34474)

    Aria

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

    Spider

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

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

    • SIGSEGV in spider_db_conn::fin_loop_check, and ASAN: heap-use-after-free in spider_db_mbase::fin_loop_check on SHOW TABLE STATUS ()

    • SIGSEGV in ha_spider::lock_tables on BEGIN after table lock ()

    • SIGSEGV in spider_conn_first_link_idx and others on DELETE, INSERT and SELECT ()

    • Spider: Crashes, asserts, hangs, memory corruptions and ASAN heap-use-after-free's ()

    • Spider: @@insert_id 128 to TINYINT: Assertion ``!is_set() || (m_status == DA_OK_BULK && is_bulk_op())'` failed. ()

    • Server crashes when calling spider UDF after aria_encrypt_tables is enabled ()

    Partitioning

    • MariaDB Server crashes with ill-formed partitions (MDEV-32155)

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

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

    Character Sets

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

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

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

    • Wrong result set with utf8mb4_danish_ci and BNLH join ()

    Optimizer

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

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

    • Extend condition normalization to include 'NOT a' (MDEV-19520)

    • Constant subquery causing a crash in pushdown optimization ()

    • Crash when pushing condition with CHARSET()/COERCIBILITY() into derived table ()

    • 2nd execution name resolution problem with pushdown into unions ()

    • Assertion ``(key_part->key_part_flag & 4) == 0'` failed key_hashnr ()

    • Crash caused by query containing constant having clause ()

    • ORDER BY DESC causes ROWID Filter optimization performance degradation ()

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

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

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

    Backup

    • Hide password passed on commandline from xtrabackup_info (MDEV-34434)

    Galera

    • 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)'` (MDEV-32633)

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

    • Change error code for Galera unkillable threads ()

    • 10.11.8 cluster becomes inconsistent when using composite primary key and partitioning ()

    • wsrep_sst_mariadb-backup use /tmp dir during SST rather then user defined tmpdir ()

    Error Log

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

    General

    • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.5 for Debian 10 "Buster", and RHEL/CentOS 7

    • no longer unnecessarily traverses tablespaces list (MDEV-34670)

    • Fix unknown variable defaults-group-suffix= with (MDEV-33265)

    • no longer hangs on macOS ()

    • Control over memory allocated for SP/PS ()

    • now work correctly with bulk insert ()

    • Fix assertion ``table->field[0]->ptr >= table->record[0] && table->field[0]->ptr <= table->record[0] + table->s->reclength'failed invoid handler::assert_icp_limitations(uchar*)` ()

    • - now compatible with ()

    Security

    • Fixes for the following :

      • CVE--``#

    Changelog

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

    Contributors

    For a full list of contributors to MariaDB 10.5.26, see the MariaDB Foundation release announcement.

    Download
    Release Notes
    Changelog
    Overview of 10.5
    MariaDB 10.5
    maintained until
    MariaDB 10.4
    MariaDB 10.5.26
    Stable (GA)

    The most recent release of MariaDB 10.5 is:

    Stable (GA)

    MariaDB 10.5.24 Release Notes

    The most recent release of MariaDB 10.5 is:

    Stable (GA)

    Download Release Notes Changelog Overview of 10.5

    Release date: 7 Feb 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.24 is a Stable (GA) release.

    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

    • Backport SQL service, introduced by ()

    • "plugin already loaded" should be a Warning, not an Error ()

    • mariadb-upgrade should remove mysql.plugin entries for plugins that became bundled ()

    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 Windows Server 2019

    • Upgrade to 12.6.

    • Using two temporary tables in OPTIMIZE TABLE lead to crash ()

    • REGEXP_REPLACE

    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.5.10 Release Notes

    The most recent release of MariaDB 10.5 is:

    Stable (GA)

    Download Release Notes Changelog Overview of 10.5

    Release date: 7 May 2021

    MariaDB 10.5 is the current stable series of MariaDB. 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.10 is a Stable (GA) release.

    Thanks, and enjoy MariaDB!

    Notable Changes

    • for calculating the spherical distance between two geometries (point or multipoint) on a sphere ()

    • Crash with invalid multi-table update of view in 2nd execution of SP ()

    • Incorrect name resolution for subqueries in ON expressions ()

    • Complex query in Store procedure corrupts results ()

    mariadb-backup

    • RENAME TABLE causes "Ignoring data file" messages ()

    InnoDB

    • Deprecated the *innodb and *none options in ()

    • MVCC read from index on CHAR or VARCHAR wrongly omits rows ()

    • Race conditions in persistent statistics (, , )

    Replication

    • Replication Heartbeat event was uncapable to cary 4GB+ offsets ()

    • FLUSH LOGS race against Binlog checkpoint event creation ()

    • slave_compressed_protocol did not work correctly with semi-sync ()

    • DROP TABLE should not cause "Query caused different errors on master and slave" on slave when it failed on master ()

    Galera

    • updated to 26.4.8

    • SET PASSWORD command fail with wsrep api ()

    • Long BF log wait turns on InnoDB Monitor output without telling, never turns it off ()

    • Assertion ``state_ == s_exec'failed inwsrep::client_state::start_transaction` ()

    Packaging & Misc

    • As per the , this will be the last release of for Ubuntu 16.04 Xenial and Fedora 32

    • Ubuntu 21.04 Hirsute and Fedora 34 repositories added

    Security

    • Fixes for the following :

    MongoDB protocol support files for the engine are missing in this release. If you want to use engine with MongoDB, you need to download or and put a path to this file into the connect_class_path in the my.cnf.

    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 .

    The most recent release of MariaDB 10.5 is:

    Stable (GA)

    The most recent release of MariaDB 10.5 is:

    Stable (GA)

    The most recent release of MariaDB 10.5 is:

    Stable (GA)

    The most recent release of MariaDB 10.5 is:

    Stable (GA)

    MariaDB 10.5.13 Release Notes

    Release date: 8 Nov 2021

    is a previous stable series of MariaDB. It is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

    is a release.

    Thanks, and enjoy MariaDB!

    MariaDB 10.5.21 Release Notes

    Release date: 7 Jun 2023

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

    is a release.

    Thanks, and enjoy MariaDB!

    row_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 (MDEV-31574)

  • Crash emitting "Unsupported meta-data version number" error message (MDEV-29972)

  • LeakSanitizer errors in mem_heap_create_block_func upon query from I_S.INNODB_SYS_TABLES with LIMIT ROWS EXAMINED (MDEV-32890)

  • Inplace alter rebuild increases file size (MDEV-26740)

  • BLOB corruption on UPDATE of PRIMARY KEY with FOREIGN KEY (MDEV-31441)

  • GNU libc posix_fallocate() may be extremely slow (MDEV-32268)

  • InnoDB wrong error message (MDEV-32833)

  • Assertion failure on ALTER TABLE…PAGE_COMPRESSED=1 (MDEV-31000)

  • InnoDB after ALTER TABLE…IMPORT TABLESPACE may not be crash safe (MDEV-32269)

  • InnoDB fails to restore tablespace first page from doublewrite buffer when page is empty (MDEV-32968)

  • innodb_fast_shutdown=0 hang after incomplete startup (MDEV-32798)

  • innodb_undo_log_truncate=ON prevents fast shutdown (MDEV-33062)

  • Adaptive flush recommendation ignores dirty ratio and checkpoint age (MDEV-31939)

  • gcol.gcol_purge contaminates further execution of innodb.gap_locks (MDEV-28682)

  • LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE (MDEV-27744)

  • Adaptive flushing is still not getting invoked in 10.5.11 (MDEV-26055)

  • on table to be accessible to those with privileges (MDEV-28367)
    upon PS execution (
    )
  • mysql_json cannot be used on newly created table (MDEV-32235)

  • heap-use-after-free
    in
    spider_link_get_key
    on
    LOCK TABLES
    (
    )
  • Crash when lateral derived is guaranteed to return no rows (MDEV-31279)

  • Bogus error executing PS for query using CTE with renaming of columns (MDEV-31995)

  • Spider: Valid LEFT JOIN results in ERROR 1064 (MDEV-26247)

  • Trying to lock uninitialized mutex or hang upon shutdown after using Spider with query_cache (MDEV-28739)

  • Spider tests failing in asan/valgrind builds (MDEV-32849)

  • Backport fixes to spider init bugs to 10.4-10.6 once they have SQL service (MDEV-29870)

  • Server crash with SIGSEGV or dynamic-stack-buffer-overflow in spider_db_mbase_util::append_table (MDEV-29163)

  • heap-use-after-free in ha_spider::lock_tables(), highly sporadic SIGSEGV in intern_close_table (MDEV-30014)

  • Syntax error upon query with subquery from Spider table (MDEV-30392)

  • Spider doesn't recognize semi JOIN (MDEV-31645)

  • MariaDB, SPIDER engine, usage of REGEXP (MDEV-32986)

  • Spider: variable spider_same_server_link not functioning correctly (MDEV-29718)

  • Spider fails to autodiscover structure (did in <=10.5) and reports ERROR 12500 (HY000): unknown (MDEV-33008)

  • Spider spawns unnecessarily many system threads for stats synchronization (MDEV-29020)

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

  • mariadb-upgrade fails with 'System table spider_tables is different version' => Can't create database 'performance_schema' (MDEV-27103)

  • Spider: SIGSEGV in spider_db_direct_delete, SIGSEGV in spider_db_connect, ASAN: heap-use-after-free in spider_db_direct_delete (MDEV-28683)

  • INSERT ... SELECT Does not produce an optimizer trace (MDEV-29298)

  • No error for DROP TABLE and no warning for DROP TABLE IF EXISTS with absent table when Spider plugin is included (MDEV-30170)

  • ASAN errors in spider_conn_queue_and_merge_loop_check (MDEV-29002)

  • )
    FOREIGN_KEY_CHECKS
    does not prevent non-copy alter from creating invalid FK structure (
    )
  • Assertion !"wrong page type"'` or Assertion "wrong page type" == 0'failed ininnobase_instant_tryonALTER` (MDEV-18322)

  • Assertion (col.vers_sys_end()) upon inplace ALTER with virtual columns (MDEV-20545)

  • DELETE with ORDER BY and semijoin optimization causing crash (MDEV-32212)

  • Invalid expr in cleanup_session_expr() upon INSERT DELAYED (MDEV-29932)

  • SIGSEGV in my_decimal::operator= and Assertion 0'failed inItem_type_holder::val_decimal` on SELECT (MDEV-29070)

  • LONG UNIQUE does not work like unique key when using replace (MDEV-32837)

  • LONG UNIQUE gives error when used with REPLACE (MDEV-32839)

  • Server crash in my_decimal::operator= or unexpected ER_DUP_ENTRY upon comparison with INET6 and similar types (MDEV-32879)

    wsrep_provider_options can be truncated on deep and long directory paths (MDEV-32634)

  • Server crashes in rpl_sql_thread_info::cached_charset_compare / wsrep_apply_events (MDEV-22232)

  • Galera crash when "create a table as select" (MDEV-27806)

  • Cluster is inconsistent after SAVEPOINT statement is rolled back (MDEV-32549)

  • WSREP GTID MODE is inconsistent (MDEV-31905)

  • IST "Donor does not know my secret" with ssl-mode=VERIFY_CA (MDEV-32344)

  • Can Deadlock an Errored Slave (
    )
  • main.rpl_mysqldump_slave Fails with "Master binlog wasn't deleted" Assertion (MDEV-32953)

  • rpl_seconds_behind_master_spike Sensitive to IO Thread Stop Position (MDEV-33327)

  • Binlog Checksum is Zeroed by Zlib if Part of Event Data is Empty (MDEV-33283)

  • treats empty strings different than
    REPLACE
    in ORACLE mode (
    )
  • CREATE UNIQUE INDEX fails with "ERROR 1286 (42000): Unknown storage engine 'partition'" (MDEV-21618)

  • Failure when executing PS for query using IN subquery (MDEV-32569)

  • Potential memory leak on execuing of create view statement (MDEV-32466)

  • Assertion failures (MDEV-32965)

  • Two JSON related tests running in PS mode fail on server built with -DWITH_PROTECT_STATEMENT_MEMROOT=YES (MDEV-32733)

  • Alter sequence 2nd ps fails while alter sequence 2nd time (no ps) succeeds (MDEV-33169)

  • Set TaskMax=inifinity in the MariaDB systemd unit (MDEV-30236)

  • Unreliable autocommit flag on connection creation (MDEV-32875)

  • A connection can control RAND() in following connection (MDEV-33148)

  • THD::rli_fake/rgi_fake not cleared on new connection (MDEV-32844)

  • Assertion failures in tdc_remove_table upon interrupted CREATE TABLE LIKE <sequence> (MDEV-20471)

  • Server crash in find_field_in_table (MDEV-32082)

  • LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE (MDEV-27744)

  • Failure to call SP invoking another SP with parameter requiring type conversion (MDEV-33270)

  • The database part is not case sensitive in SP names (MDEV-33019)

  • EXCHANGE PARTITION with non-matching vcol expression segfault (MDEV-28127)

  • Wrong user in SET DEFAULT ROLE error (MDEV-26875)

  • quote(NULL) returns incorrect result in view ('NU' instead of 'NULL') (MDEV-28651)

  • mysql.slow_log reports incorrect start time (MDEV-11628)

  • Update federated table and column privileges (MDEV-32984)

  • MDEV-29954
    MDEV-28613
    MDEV-29110
    MDEV-20286
    MDEV-33006
    MDEV-24541
    MDEV-32587
    MDEV-29421
    MDEV-29963
    MDEV-28615
    MDEV-31657
    MDEV-29362
    MDEV-33165
    MDEV-32795
    MDEV-22230
    MDEV-26743
    MDEV-32645
    MDEV-24784
    MDEV-19275
    MDEV-27595
    MDEV-32041
    MDEV-32043
    MDEV-31413
    MDEV-32938
    MDEV-28971
    MDEV-33045
    MDEV-27436
    MDEV-26632
    MariaDB Deprecation Policy
    MariaDB 10.5
    MDEV-31523
    MariaDB 10.5.24
    changelog
    MariaDB 10.5.24
    MariaDB Foundation release announcement
    MariaDB 10.5.29
    Download Now
    Alternate download from mariadb.org

    Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    MDEV-21245
    MDEV-32867
    MDEV-31357
    MDEV-29092
    MDEV-10653
    MDEV-29095

    DELETE HISTORY may delete current data on system-versioned table (MDEV-25468)

  • Crashes with nested table value constructors (MDEV-22786)

  • Server crashes in thd_clear_errors() (MDEV-23542)

  • The statement set password=password('') executed in PS mode fails in case it is run by a user with expired password (MDEV-25197)

  • Sequence created by one connection remains invisible to another (MDEV-24545)
  • innodb_flush_method=O_DIRECT fails on compressed tables (MDEV-25121)

  • RESET MASTER hangs (MDEV-24302)

  • InnoDB crash recovery fixes (MDEV-25031, MDEV-25110)

  • Killing server during RESET MASTER may lose MyRocks transaction (MDEV-25305)

    Frequently Crashing Mariadb Cluster 10.4.18 (MDEV-24980)

  • Signal 11 on TABLE_LIST::placeholder() (MDEV-24878)

  • ALTER TABLE not replicated with Galera in MariaDB 10.5.9 (MDEV-24956)

  • "Flush SSL" command doesn't reload wsrep cert (MDEV-22668)

  • Avoid unnecessary rollbacks with SR (MDEV-25553)

  • MDEV-13467
    MDEV-24823
    MDEV-25362
    MDEV-25182
    MDEV-25568
    MDEV-25106
    MDEV-25459
    MDEV-10682
    MDEV-18802
    MDEV-25051
    MDEV-16146
    MDEV-24526
    MDEV-24773
    MDEV-25530
    MDEV-25258
    MDEV-25319
    MDEV-22227
    MariaDB Deprecation Policy
    MariaDB 10.5
    CVE-2021-2166
    CVE-2021-2154
    CVE-2022-21451
    Mongo2.jar
    Mongo3.jar
    MariaDB 10.5.10
    changelog
    MariaDB 10.5.10
    MariaDB Foundation release announcement
    MariaDB 10.5.29
    Download Now
    Alternate download from mariadb.org
    Galera

    Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    Notable Items

    Galera

    • Fix for WSREP: invalid state ROLLED_BACK (FATAL) (MDEV-25114)

    InnoDB

    • ALTER TABLE…IMPORT TABLESPACE fixes (MDEV-18543, MDEV-20931, MDEV-26131, MDEV-26621)

    • innodb_undo_log_truncate fixes (MDEV-26445, MDEV-26450, MDEV-26672, MDEV-26864)

    • Page I/O performance fixes (MDEV-25215, MDEV-26547, MDEV-26626, MDEV-26819)

    • Replication timeouts with XA PREPARE ()

    Replication

    • Memory hogging on slave by ROW event applier is eliminated (MDEV-26712)

    • mysql --binary-mode now properly handles \\0 in data (MDEV-25444)

    • Fixes race condition between SHOW BINARY LOGS and RESET MASTER (MDEV-20215)

    • Missed statement rollback in case transaction drops or create temporary table is corrected ()

    Audit Plugin

    • The QUERY_DDL setting now logs CREATE/DROP [PROCEDURE / FUNCTION / USER] statements. See . (MDEV-23457)

    Packaging & Misc

    • Session tracking flag in OK_PACKET (MDEV-26868)

    • Some views force server (and mysqldump) to generate invalid SQL for their definitions (MDEV-26299)

    Security

    • Fixes for the following :

      • CVE-2021-35604

      • CVE-2021-46667

      • CVE-2021-46662

    Changelog

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

    Contributors

    For a full list of contributors to MariaDB 10.5.13, see the MariaDB Foundation release announcement.

    Download
    Release Notes
    Changelog
    Overview of 10.5
    MariaDB 10.5
    MariaDB 10.4
    MariaDB 10.5.13
    Stable (GA)

    The most recent release of MariaDB 10.5 is:

    MariaDB 10.5.29 Stable (GA) Download Now

    Alternate download from mariadb.org

    Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    Notable Items

    InnoDB

    • Server crashes in st_join_table::choose_best_splitting (MDEV-31403)

    • Crash with condition pushable into derived and containing outer reference (MDEV-31240)

    • InnoDB does not free UNDO after the fix of MDEV-30671 (MDEV-31234)

    • Revert "MDEV-30473 : Do not allow GET_LOCK() / RELEASE_LOCK() in cluster"

    Optimizer

    • Crash with condition pushable into derived and containing outer reference (MDEV-31403 MDEV-31240)

    • Crash with for multi-table update of system table (MDEV-31224)

    Security

    • Fixes for the following :

      • CVE--``#

    Changelog

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

    Contributors

    For a full list of contributors to MariaDB 10.5.21, see the MariaDB Foundation release announcement.

    Download
    Release Notes
    Changelog
    Overview of 10.5
    MariaDB 10.5
    maintained until
    MariaDB 10.4
    MariaDB 10.5.21
    Stable (GA)

    The most recent release of MariaDB 10.5 is:

    MariaDB 10.5.29 Stable (GA) Download Now

    Alternate download from mariadb.org

    Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    MDEV-33770
    MDEV-33795
    MDEV-33512
    MDEV-19044
    MDEV-33802
    MDEV-33889
    MDEV-32489
    MDEV-33397
    MDEV-33277
    MDEV-32445
    MDEV-33214
    MDEV-33679
    MariaDB 10.5
    MariaDB 10.6
    MDEV-33777
    MDEV-28105
    MDEV-33441
    mariadb-backup --prepare
    MDEV-33540
    mariadb-backup --prepare --export
    MDEV-33023
    mariadb-backup
    MDEV-32893
    MDEV-21034
    MDEV-30660
    MDEV-15703
    MDEV-31277
    MDEV-34088
    MDEV-34069
    MDEV-34061
    MDEV-24507
    MDEV-25370
    MDEV-21058
    MDEV-33044
    MariaDB 10.5.29
    Download Now
    Alternate download from mariadb.org

    Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    MDEV-34541
    MDEV-29962
    MDEV-32492
    MDEV-27902
    MDEV-28105
    MDEV-34682
    MDEV-32376
    MDEV-34417
    MDEV-29363
    MDEV-33010
    MDEV-34506
    MDEV-34580
    MDEV-23983
    MDEV-33875
    MDEV-34170
    MDEV-12008
    MDEV-34269
    MDEV-32158
    MDEV-34129
    MDEV-14959
    MDEV-24411
    MDEV-34632
    MDEV-34203
    MariaDB 10.5.29
    Download Now
    Alternate download from mariadb.org

    Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    MariaDB 10.5.29
    Download Now
    Alternate download from mariadb.org

    Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    MariaDB 10.5.29
    Download Now
    Alternate download from mariadb.org

    Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    MariaDB 10.5.29
    Download Now
    Alternate download from mariadb.org

    Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    MariaDB 10.5.29
    Download Now
    Alternate download from mariadb.org

    Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    MariaDB 10.5.29
    Download Now
    Alternate download from mariadb.org

    Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

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

    MariaDB 10.5.29
    Download Now
    Alternate download from mariadb.org

    Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    MariaDB 10.5.11 Release Notes

    The most recent release of MariaDB 10.5 is:

    Stable (GA)

    Download Release Notes Changelog Overview of 10.5

    Release date: 23 Jun 2021

    MariaDB 10.5 is the current stable series of MariaDB. 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.11 is a Stable (GA) release.

    Thanks, and enjoy MariaDB!

    Notable Items

    This version of MariaDB is being released now to fix the following two regressions:

    • Table alias from previous statement interferes later commands ()

    • Join using derived with aggregation returns incorrect results ()

    In addition to the above, this release also contains the following fixes:

    InnoDB

    • InnoDB spatial indexes miss large geometry fields after ()

    • Double free of transaction during truncate operation ()

    • Double free of table when inplace alter FTS add index fails ()

    • Potential hang in purge for virtual columns ()

    Replication

    • Do not replicate killed multi-table when the signal arrives before any table has been processed ()

    • Fix optimistic parallel applier to not deadlock on admin commands ,, and ()

    • Backport parallel slave server shutdown hang ()

    • Removed deprecated --base64-output

    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.5.15 Release Notes

    The most recent release of MariaDB 10.5 is:

    Stable (GA)

    Download Release Notes Changelog Overview of 10.5

    Release date: 12 Feb 2022

    MariaDB 10.5 is a previous stable series of MariaDB. 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.15 is a Stable (GA) release.

    Thanks, and enjoy MariaDB!

    Notable Items

    • This release fixes a blocking problem with the 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 made in , with links to detailed information on each push, see the .

    Contributors

    For a full list of contributors to , see the .

    MariaDB 10.5.0 Release Notes

    Release date: 3 Dec 2019

    is the current development series of MariaDB. It is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

    is an release.

    For an overview of see the page.

    Thanks, and enjoy MariaDB!

    Change buffer records are lost under heavy load (MDEV-25783)

  • Not applying INSERT_REUSE_REDUNDANT (MDEV-25745)

  • InnoDB recovery fails with [ERROR] InnoDB: Not applying INSERT_REUSE_REDUNDANT due to corruption (MDEV-25745)

  • harvests InnoDB: Index 'abdcef' contains 10001 entries, should be 10000 (MDEV-25783)

  • to correct BINLOG clause in
    output (
    )
    MDEV-25672
    MDEV-25714
    MDEV-25459
    MDEV-25758
    MDEV-25663
    MDEV-25721
    MDEV-25664
    MDEV-22530
    MDEV-17515
    MDEV-20821
    MDEV-22370
    CVE-2021-46666
    CVE-2021-46657
    MariaDB 10.5.11
    changelog
    MariaDB 10.5.11
    MariaDB Foundation release announcement
    MariaDB 10.5.29
    Download Now
    Alternate download from mariadb.org

    Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    MDEV-25222

    CVE-2021-46668

  • CVE-2021-46663

  • MariaDB 10.5.14
    MDEV-27789
    MariaDB 10.5.14
    MDEV-27734
    CVE-2021-46665
    CVE-2021-46664
    CVE-2021-46661
    MariaDB 10.5.15
    changelog
    MariaDB 10.5.15
    MariaDB Foundation release announcement
    MariaDB 10.5.29
    Download Now
    Alternate download from mariadb.org

    Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    Notable Changes

    This is the first alpha release in the MariaDB 10.5 series.

    Notable changes of this release include:

    INET 6 Data Type

    • New data type for storing IPv6 addresses (MDEV-274).

    Syntax

    • (MDEV-10014)

    • (MDEV-10014)

    • and (MDEV-18844)

    • Database comments in and statements (MDEV-307)

    • Setup ()

    • Fix in column definition ()

    JSON

    • Add information about packed addon fields in (MDEV-21838)

    S3 Storage Engine

    • , a read-only storage engine that stores its data in Amazon S3 (MDEV-17841)

    Thread Pool

    • Information Schema tables (, and ) for internals of generic threadpool (MDEV-19313)

    InnoDB

    • now defaults to OFF (MDEV-20487)

    • now defaults to full_crc32 (MDEV-19534)

    • has been removed (MDEV-19534)

    • has been deprecated ()

    • has been removed ()

    • has been removed ()

    • has been deprecated ()

    • has been removed ()

    • Set by default ()

    • 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 Refactoring

    • Remove buf_page_t::newest_modification (MDEV-21132)

    • Replace recv_sys_t::addr_hash with a std::map (MDEV-19586)

    • Obsolete internal parser for FK in InnoDB (MDEV-20480)

    • InnoDB thread pool for background tasks (MDEV-16264)

    Binary Log

    • Extended metadata (MDEV-20477)

    Query Optimizer

    • is improved, now it also shows the time spent checking the WHERE clause and doing other auxiliary operations (MDEV-20854)

    • (MDEV-15777)

    Galera

    • Galera 4 Inconsistency voting (MDEV-17048)

    General

    • The has a new column showing from which config file a variable derives its value (MDEV-12684)

    • Switch Perl DBI scripts from DBD::mysql to DBD::MariaDB driver (MDEV-19755)

    • The max key length is now 2000 bytes, compared to 1000 bytes in .

    Do not use alpha releases in production!

    Changelog

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

    Contributors

    For a full list of contributors to MariaDB 10.5.0, see the MariaDB Foundation release announcement.

    Download
    Release Notes
    Changelog
    Overview of 10.5
    MariaDB 10.5
    MariaDB 10.4
    MariaDB 10.5.0
    Alpha
    MariaDB 10.5
    What is MariaDB 10.5?

    The most recent release of MariaDB 10.5 is:

    MariaDB 10.5.29 Stable (GA) Download Now

    Alternate download from mariadb.org

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

    Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    MDEV-26682
    MDEV-26833
    CVE-2022-27385
    CVE-2022-31624
    CVE-2022-31621
    subscribing
    subscribing

    MariaDB 10.5.2 Release Notes

    The most recent release of MariaDB 10.5 is:

    Stable (GA)

    Download Release Notes Changelog Overview of 10.5

    Release date: 26 Mar 2020

    MariaDB 10.5 is the current development series of MariaDB. 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.2 is a Beta release.

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

    Thanks, and enjoy MariaDB!

    Notable Changes

    This is the second beta release in the series.

    Notable changes of this release include:

    Syntax

    • ()

    • ()

    • ()

    • Recursive cycle detection using CYCLE clause ()

    Privileges

    • 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

    • An upgrade will only be possible after a clean shutdown. mariadb-backup --prepare will not work with backups taken before version 10.5.2.

    • Efficient InnoDB redo log record format ()

    • Deprecate and ignore and ()

    • Remove table and deprecate and ignore , , and

    Optimizer

    • Allow packed sort keys in sort buffer ()

    Performance Schema

    • Merge 5.7 P_S transaction instrumentation and tables ()

    • Merge 5.7 P_S memory instrumentation and tables ()

    • Merge 5.7 P_S mdl instrumentation and tables ()

    • Merge 5.7 P_S sxlocks instrumentation and tables ()

    Replication

    • ENFORCE option for ()

    ANALYZE FORMAT=JSON

    • Add information about packed addon fields in ()

    Binaries

    • All binaries previously beginning with mysql now begin with mariadb, with symlinks for the corresponding mysql command. ()

    Galera

    • updated to 26.4.4

    • Galera Cluster Node During IST gets stuck going from "Synced" to "Joining:..." ()

    Other

    • updated to 11.0 ()

    • system variable, for rejecting connections attempted using insecure transport ()

    • session system variable, which adds an implicit IF EXISTS to ALTER, RENAME and DROP of TABLES, VIEWS, FUNCTIONS and PACKAGES. ()

    • transactions must survive client disconnection ()

    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!

    MariaDB 10.5.7 Release Notes

    The most recent release of MariaDB 10.5 is:

    Stable (GA)

    Download Release Notes Changelog Overview of 10.5

    Release date: 3 Nov 2020

    MariaDB 10.5 is the current stable series of MariaDB. 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.7 is a Stable (GA) release.

    Thanks, and enjoy MariaDB!

    Notable Changes

    This release introduced an InnoDB data corruption bug (). If any InnoDB tables contain indexed virtual columns or unique indexes on BLOB or TEXT columns, any InnoDB tables or tablespaces may become irreparably corrupted.

    • Improved write performance (, , )

    • It is now possible to upgrade from MySQL 5.7 Tables containing JSON, by loading the MYSQL_JSON datatype plugin first. See .

    • Update to maturity Gamma

    • option deprecated and defaulted to zero ()

    S3 Storage Engine

    • Update to maturity Gamma

    • Add the and system variables

    Galera

    • updated to 26.4.6

    • Fixed assertion failure on before_commit ()

    • Fixed assertion after ROLLBACK AND CHAIN ()

    • Fixed replication of DROP TRIGGER ()

    Notes

    • As per the , this will be the last release of for CentOS/RHEL 6 and Fedora 31

    • Packages for added

    • Packages for arm64 and ppc64el added

    • Packages for arm64 added

    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.5.3 Release Notes

    The most recent release of MariaDB 10.5 is:

    Stable (GA)

    Download Release Notes Changelog Overview of 10.5

    Release date: 12 May 2020

    MariaDB 10.5 is the current development series of MariaDB. 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.3 is a Release Candidate (RC) release.

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

    Thanks, and enjoy MariaDB!

    Notable Changes

    This is the second beta release in the series.

    Notable changes of this release include:

    Syntax

    • Application period tables: ()

    • Introduce a file format constraint to ALTER TABLE. See ()

    Large Pages

    • Modernise Linux Large Page support (multiplesizes) ()

    Storage Engines

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

    Performance

    • Optimizer flag rowid_filter leads to long query ()

    • WSREP_ON is unnecessarily expensive to evaluate (

    • Misc wsrep performance optimization ()

    Security

    • Added system user for user view which allows to remove root ()

    • WolfSSL updated

    • doesn't remove excess authentication plugins from ()

    • creating empty ()

    Aria

    • Updated to support transactional tables and added the --datadir, --ignore-control-file and --require-control-file options. More details

    ALTER TABLE

    • Error on online ADD PRIMARY KEY after instant DROP/reorder ()

    • Assertion failure in file data0type.cc ()

    • Server aborts upon attempt to create foreign key on spatial field ()

    • DROP COLUMN, DROP INDEX is wrongly claimed to be ALGORITHM=INSTANT ()

    Optimizer

    • Optimizer, Wrong query results with optimizer_switch="split_materialized=on" ()

    • SHOW GRANTS does not quote role names properly ()

    • Paritioning INSERT chooses wrong partition for RANGE partitioning by DECIMAL column ()

    mariadb-backup

    • does not honor ignore_db_dirs from server config ()

    • mariadb-backup --ftwrl-wait-timeout never times out on explicit lock ()

    Crash Recovery

    • Loop of Read redo log up to LSN ()

    • buf_page_get_gen() should apply buffered page initialized redo log during recovery ()

    • Running out of file descriptors and eventual crash ()

    • Efficient InnoDB redo log record format ()

    Other

    • Use MariaDB in error messages instead of MySQL ()

    • FULLTEXT INDEX, Assertion ``!table->fts->in_queue' failed in fts_optimize_remove_table` ()

    • Wrong estimate of affected BLOB columns in update of PRIMARY KEY ()

    • Duplicate key value is silently truncated to 64 characters in

    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.17 Release Notes

    The most recent release of MariaDB 10.5 is:

    Stable (GA)

    Download Release Notes Changelog Overview of 10.5

    Release date: 15 Aug 2022

    MariaDB 10.5 is a previous stable series of MariaDB. 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.17 is a Stable (GA) release.

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

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

      • Subquery semi-join optimization could miss LooseScan or FirstMatch strategies for certain queries.

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

    CONNECT

    • now supports with ()

    mariadb Client

    • New option, -enable-cleartext-plugin. Option does not do anything, and is for MySQL-compatibility purposes only.

    General

    • now also has a session scope, not only global ()

    • MariaDB can be built with OpenSSL 3.0

    • was updated to include the latest content

    • 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.5.12 Release Notes

    The most recent release of MariaDB 10.5 is:

    Stable (GA)

    Download Release Notes Changelog Overview of 10.5

    Release date: 6 Aug 2021

    Warning: This version can cause InnoDB file corruption on FreeBSD and on AIX. If you are using AIX, please, stick to an earlier release, or upgrade to a more recent release. If you are using FreeBSD, upgrade to the bugfix release (the version ends with _1) of the mariadb-server from the Ports Collection. See MDEV-26537.

    MariaDB 10.5 is a previous stable series of MariaDB. 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.12 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 made in , with links to detailed information on each push, see the .

    Contributors

    For a full list of contributors to , see the .

    MariaDB 10.5.19 Release Notes

    The most recent release of MariaDB 10.5 is:

    Stable (GA)

    Download Release Notes Changelog Overview of 10.5

    Release date: 6 Feb 2023

    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.19 is a Stable (GA) release.

    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

    • updated to 26.4.14

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

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

    JSON

    • added as an alias for ()

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

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

    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.5.14 Release Notes

    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 a previous stable series of MariaDB. It is an evolution of with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

    is a release.

    Thanks, and enjoy MariaDB!

    MariaDB 10.5.18 Release Notes

    Release date: 7 Nov 2022

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

    is a release.

    Thanks, and enjoy MariaDB!

    and now support IF EXISTS.

  • The privilege was renamed to . The old syntax is understood for compatibility (MDEV-21743).

  • The statement was renamed to (MDEV-21743). The old syntax is understood for compatibility.

  • A number of statements changed the privileges that they require. The old privileges were historically inappropriately chosen in the upstream. 10.5.2 fixes this problem. Note, these changes are incompatible to previous versions. A number of GRANT commands might be needed after upgrade.

    • now requires the privilege (required prior to 10.5.2).

    • now requires the privilege (required prior to 10.5.2).

    • now requires the or the privilege (required or prior to 10.5.2).

    • now requires the privilege (required prior to 10.5.2).

  • In order to help the server understand which version a privilege record was written by, the field contains a new JSON field, version_id (MDEV-21704)

  • now correctly lists the Delete history privilege, rather than displaying it as Delete versioning rows. (MDEV-20382)

  • (
    )
  • Deprecate and ignore (MDEV-14425)

  • Do not acquire InnoDB record locks when covering table locks exist (MDEV-14479)

  • Issue a message on changing deprecated innodb_log_files_in_group (MDEV-21990)

  • Optimize append only files for NVDIMM (MDEV-17084)

  • Improve innodb redo log group commit performance (MDEV-21534)

  • Punch holes when pages are freed (MDEV-15528)

  • Merge 5.7 P_S user variables instrumentation and tables (MDEV-16439)

  • Merge 5.7 P_S [show] status instrumentation and tables (MDEV-16438)

  • Merge 5.7 P_S ps instrumentation and tables (MDEV-16433)

  • Merge 5.7 P_S sp instrumentation and tables (MDEV-16434)

  • Binary tarball size has been reduced (MDEV-21943)

  • MariaDB 10.5
    MDEV-10569
    MDEV-7318
    MDEV-16290
    MDEV-20632
    MDEV-21743
    MDEV-12353
    MDEV-21870
    MDEV-21580
    MDEV-16435
    MDEV-16431
    MDEV-16432
    MDEV-16436
    MDEV-21833
    MDEV-21838
    MDEV-21303
    MDEV-21002
    MDEV-22032
    MDEV-13362
    MDEV-19964
    MDEV-742
    MariaDB 10.5.2
    changelog
    MariaDB 10.5.2
    MariaDB Foundation release announcement
    MariaDB 10.5.29
    Download Now
    Alternate download from mariadb.org

    Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    MDEV-15528

    maximum index size increased from 1000 to 3500 bytes (MDEV-24017)

  • issue (MDEV-23702)

  • Temporary tables can no longer overwrite existing files. Instead an error is returned should a conflict occur (MDEV-23569)

  • Binlog checksum verification at recovery time (MDEV-23832)

  • Verbose print-out of by (MDEV-22330)

  • from validates when binlog checksummed (MDEV-21839)

  • Freeing memory of (MDEV-23534)

  • Corrected verbose output for multi-record Rows-log-event (MDEV-16372)

  • no longer causes crash (MDEV-20744)

  • that were running an index condition pushdown in InnoDB will now return an error (MDEV-23938)

  • Wrong direxec param data caused crash; Numerous fixes about Mac builds (by Dmitri Shulga) (MDEV-19838)

  • now logs proxy users (MDEV-19443)

  • Crash on SELECT on a table with indexed virtual columns (MDEV-18366)

  • updated to 5.7.32 (MDEV-23989)

  • Bug fixes related to adaptive hash index (MDEV-23452, MDEV-23370)

  • Fixed a bug in the recovery of encrypted tables (MDEV-23456)

  • Fixed a race condition in MVCC reads (MDEV-22924)

  • fixes (MDEV-22277, MDEV-22939, MDEV-23199, MDEV-23356, MDEV-23499, MDEV-23672, MDEV-23685, MDEV-23722)

  • Diskspace not reused for BLOB in data file (MDEV-23072)

  • InnoDB: Failing assertion: !space->referenced() (MDEV-23651)

  • SIGSEGV in maria_create() because of double free (MDEV-23222)

  • CREATE TEMPORARY TABLE .. LIKE (system versioned table) returns error if unique index is defined in the table (MDEV-23968)

  • Error upon querying the view, that selecting from versioned table with partitions (MDEV-23779)

  • CREATE .. SELECT wrong result on join versioned table (MDEV-23799)

  • SIGSEGV in check_fields on UPDATE (MDEV-22805)

  • Parser fix (MDEV-23094)

  • Add CRC-32 code to mysys, giving notable speedup in checksum calculation on x64 (MDEV-19935)

  • Faster CRC-32C checksum calculations (MDEV-23495, MDEV-22749)

  • Fixes to potential corruption bugs (MDEV-23973, MDEV-24054)

  • Fixed delayed replication with S3 storage engine slave (MDEV-23691)

  • Deadlock between BACKUP STAGE BLOCK_COMMIT and parallel replication (MDEV-23586)

  • CREATE fails after DROP without .frm (MDEV-23549)

  • IPv6 SST handling improved (MDEV-21770, MDEV-23576, MDEV-23580, MDEV-23581, MDEV-23574)

  • Fixed SIGSEGV in lock_rec_unlock (MDEV-23101)

  • Fixed replication of timezone if only 1 timezone is loaded (MDEV-22626)

  • Fixed replication of CREATE OR REPLACE TRIGGER (MDEV-21578)

  • Fixed SST FLUSH TABLES WITH READ LOCK timeout (MDEV-22543)

  • Fixes for the following :

    • CVE-2020-14812

    • CVE-2020-14765

    • CVE-2020-14776

    • CVE-2020-14789

    • ()

    • ()

    MDEV-24096
    MDEV-23399
    MDEV-23855
    MDEV-24037
    MDEV-18323
    Making MariaDB understand MySQL JSON
    MDEV-22278
    MDEV-22681
    MDEV-22055
    MDEV-23638
    MariaDB Deprecation Policy
    MariaDB 10.5
    Ubuntu 20.10 "Groovy Gorilla"
    Debian 10 "buster"
    Debian 9 "stretch"
    MariaDB 10.5.7
    changelog
    MariaDB 10.5.7
    MariaDB Foundation release announcement
    MariaDB 10.5.29
    Download Now
    Alternate download from mariadb.org

    Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    Introduce a file format constraint (MDEV-20590)

  • FORCE all partition to rebuild if any one of the partition does rebuild (MDEV-21832)

  • InnoDB aborts while adding instant column for discarded tablespace (MDEV-22446)

  • Misc ALTER TABLE assertion failure (MDEV-22358)

  • Punch holes when pages are freed (MDEV-15528)

    print_keydup_error
    (
    )
  • Session tracking returns incorrectly long tracking data (MDEV-22504)

  • Add pam_user_map.so file to binary tarball package (MDEV-21913)

  • Misc fixes for Mac build (MENT-606)

  • is made aware of the upstream slave tables to issue warnings when that takes place (MDEV-10047)

  • InnoDB fixes (MDEV-21564, MDEV-19092, MDEV-21549)

  • InnoDB FULLTEXT INDEX fixes (MDEV-21563)

  • Corruption for SET GLOBAL innodb_ string variables (MDEV-22393)

  • Test suite, Add JUnit support to MTR to generate XML test result (MDEV-22176)

  • parameter, --ignore-table-data, added (MDEV-22037)

  • Refactored MYSQL_BIN_LOG::xid_count_per_binlog to satisfy UBSAN enabled build (MDEV-20923)

  • Unregister of slave threads disconnected before COM_BINLOG_DUMP (Bug#29915479)

  • Server can fail while replicating conditional comments (Bug#28388217)

  • Added the xml-report option to (MDEV-22176)

  • Packages and repositories for Ubuntu 20.04 "focal" added

  • MariaDB 10.5
    MDEV-16978
    MDEV-20590
    MDEV-18851
    MDEV-22088
    MDEV-21794
    MDEV-22203
    MDEV-7962
    MDEV-19650
    MDEV-21928
    MDEV-21244
    here
    MDEV-21658
    MDEV-20726
    MDEV-21792
    MDEV-22465
    MDEV-21614
    MDEV-20076
    MDEV-21195
    mariadb-backup
    MDEV-19347
    MDEV-20230
    MDEV-21826
    MDEV-21572
    MDEV-18027
    MDEV-12353
    MDEV-17812
    MDEV-21550
    MDEV-22384
    MariaDB 10.5.3
    changelog
    MariaDB 10.5.3
    MariaDB Foundation release announcement
    MariaDB 10.5.29
    Download Now
    Alternate download from mariadb.org

    Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    MDEV-20604

    Crash recovery fixes (MDEV-28668, MDEV-28731)

    sequences related row-format events are made to correspond to binlog_row_image (MDEV-28487)
  • Possible reason of FLUSH BINARY LOGS hang is eliminated (MDEV-28948)

  • Galera should replicate nextval()-related changes in sequences with INCREMENT <> 0, at least NOCACHE ones with engine=InnoDB (MDEV-27862)

    A query with a subuquery in this form could cause a crash:
  • Optimizer uses all partitions after upgrade to 10.3 (MDEV-28246)

    • For multi-table UPDATE or DELETE queries, the optimizer failed to apply Partition Pruning optimization for the table that is updated or deleted from.

  • Range optimizer regression for key IN (const, ....) (MDEV-25020)

    • The issue can be observed on MariaDB 10.5.9 and later versions which have the fix for MDEV-9750. That fix introduceds optimizer_max_sel_arg_weight.

    • If one sets optimizer_max_sel_arg_weight to a very high value or zero (which means "unlimited") and runs queries that produce heavy-weight graphs, they can observe a performance slowdown, e.g.:

  • ALTER TABLE ALGORITHM=NOCOPY does not work after upgrade (MDEV-28727)

  • Server crash upon CREATE VIEW with unknown column in ON condition (MDEV-29088)

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.5 for Debian 10 "Buster" for ppc64el

  • CVE-2022-32081

  • CVE-2018-25032

  • CVE-2022-32091

  • CVE-2022-32084

  • CVE-2022-38791

  • MDEV-28495
    MDEV-20797
    MDEV-28779
    MDEV-26294
    MDEV-29078
    MDEV-21087
    MDEV-21443
    MDEV-28546
    MDEV-25068
    MDEV-20627
    MDEV-23809
    MDEV-29139
    MDEV-26427
    MDEV-28749
    MDEV-28858
    Mysql Table type
    MDEV-27766
    MDEV-29225
    MDEV-29188
    CVE-2023-5157
    CVE-2022-32082
    CVE-2022-32089
    MariaDB 10.5.17
    changelog
    MariaDB 10.5.17
    MariaDB Foundation release announcement
    MariaDB 10.5.29
    Download Now
    Alternate download from mariadb.org
    Galera

    Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    Improved page flushing performance (MDEV-25954, MDEV-25948, MDEV-25801, MDEV-25113, MDEV-26004)

    A query with window function on the left side of the subquery could cause a crash. (MDEV-25630)

  • Fixed the issue fixed in MySQL Bug #76803: DML or locking SELECT statements that use outer joins could produce this warning in the error log: [ERROR] InnoDB: Unlock row could not find a 3 mode lock on the record. (MDEV-26106)

  • MDEV-24393
    MDEV-14180
    MDEV-26205
    MDEV-26110
    MDEV-25858
    MDEV-17783
    MDEV-23937
    MDEV-25969
    MDEV-25969
    MariaDB Deprecation Policy
    MariaDB 10.5
    CVE-2021-2372
    CVE-2021-2389
    CVE-2021-46658
    MariaDB 10.5.12
    changelog
    MariaDB 10.5.12
    MariaDB Foundation release announcement
    MariaDB 10.5.29
    Download Now
    Alternate download from mariadb.org
    Galera

    Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    InnoDB shutdown hangs when the change buffer is corrupted (MDEV-30009)

  • innodb_fast_shutdown=0 fails to report change buffer merge progress (MDEV-29984)

  • Deadlock is resolved on replica involving
    BACKUP STAGE BLOCK_COMMIT
    and a committing user XA (
    )

    In this release repositories for Fedora 37 have been added.

    10.5.18 release notes
    this blog post
    MDEV-25004
    MDEV-29999
    MDEV-30179
    MDEV-30438
    MDEV-24412
    MDEV-25417
    MDEV-29684
    MDEV-30323
    MDEV-29639
    MDEV-25277
    MDEV-19160
    MDEV-30248
    MDEV-30052
    MDEV-29988
    MariaDB Deprecation Policy
    MariaDB 10.5
    MariaDB 10.5.19
    changelog
    MariaDB 10.5.19
    MariaDB Foundation release announcement
    MariaDB 10.5.29
    Download Now
    Alternate download from mariadb.org
    Galera

    Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    MDEV-30423
    Notable Items

    InnoDB

    • does not disallow .isl file creation (MDEV-26870)

    • Indexed columns are broken with NO_PAD (MDEV-25440)

    • insert-intention lock conflicts with waiting ORDINARY lock (MDEV-27025)

    • Crash recovery improvements (, , , )

    Galera

    • Galera updated to 26.4.11

    • Galera SST scripts should use ssl_capath (not ssl_ca) for CA directory (MDEV-27181)

    • Alter Sequence do not replicate to another nodes with in Galera Cluster (MDEV-19353)

    • Galera crash - Assertion. Possible parallel writeset problem (MDEV-26803)

    • CREATE TABLE with FOREIGN KEY constraint fails to apply in parallel ()

    • Galera cluster node consider old server_id value even after modification of server_id [wsrep_gtid_mode=ON] ()

    Replication

    • Seconds behind master corrected from artificial spikes at relay-log rotation (MDEV-16091)

    • Statement rollback in binlog when transaction creates or drop temporary table is set right (MDEV-26833)

    • CREATE-or-REPLACE SEQUENCE is made to binlog with the DDL flag to stabilize its parallel execution on slave (MDEV-27365)

    Packaging & Misc

    • prohibition running two upgrades in parallel (MDEV-27068, MDEV-27107, MDEV-27279)

    • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.5 for Ubuntu 21.04 Hirsute, CentOS 8, and Fedora 33

    • script updated to version 2022-02-08, with the following fixes and enhancements:

      • Default location of the script has been moved to: (old location is deprecated, but still works)

      • The GPG keyring file, used with Debian and Ubuntu repositories, has moved to: and the checksum for the file can be found at:

      • Support for RHEL and SLES aarch64 repositories added

      • New function added to verify that the MariaDB Server version, if specified on the command line, follows the correct naming and that a corresponding repository actually exists.

      • Fixed repository pinning for Ubuntu and Debian repositories

      • MariaDB Server 10.7 is now the default server version

    Docker Library

    • Faster initialization by disabling binary logging during initialization (MDEV-27074)

    • mysql_upgrade can be run if needed using the environment variable MARIADB_AUTO_UPGRADE=1 (MDEV-25670)

    • A healthcheck script /usr/local/bin/healthcheck.sh is installed in the container with various checking options (MDEV-25434)

    • mysql@localhost user is created with the environment variable MARIADB_MYSQL_LOCALHOST_USER=1 and additional grants (beyond USAGE) with MARIADB_MYSQL_LOCALHOST_GRANTS={global grant list} (MDEV-27732)

    • skip innodb buffer pool loads/dumps on temporary startup/shutdown for faster startup/initialization, and accurate "healthcheck.sh --innodb_buffer_pool_loaded"

    • change group ownership on datadir/socket dir ()

    • log note about note on Securing system users, mysql_secure_installation not required ()

    • speed up Docker Library initialization of timezones (, )

    Security

    • Fixes for the following :

      • CVE-2022-24052

      • CVE-2022-24051

      • CVE-2022-24050

    Changelog

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

    Contributors

    For a full list of contributors to MariaDB 10.5.14, see the MariaDB Foundation release announcement.

    Release Notes
    Changelog
    Overview of 10.5
    MDEV-27789
    MariaDB 10.5
    MariaDB 10.4
    MariaDB 10.5.14
    Stable (GA)

    The most recent release of MariaDB 10.5 is:

    MariaDB 10.5.29 Stable (GA) Download Now

    Alternate download from mariadb.org

    Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    Notable Items

    SSL

    • The server no longer tolerates incorrectly configured SSL (MDEV-29811). 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

    • hangs (MDEV-29043)

    • Assertion on info.page_size failed in xb_delta_open_matching_space (MDEV-18589)

    InnoDB

    • InnoDB unnecessarily extends data files (MDEV-13013)

    • Adaptive hash index MDEV-27700, MDEV-29384

    • MVCC and locking MDEV-29666, MDEV-27927

    • Virtual columns MDEV-29299, MDEV-29753

    • InnoDB crash recovery fixes (, )

    • InnoDB crash recovery fixes ()

    • MVCC and locking ()

    • Race condition between KILL and transaction commit ()

    Galera

    • Galera updated to 26.4.13

    • Galera server crashes after 10.3 > 10.4 upgrade (MDEV-29375)

    • status variable prints 0 as port number if the port is not mentioned in system variable (MDEV-28868)

    JSON

    • does not parse NULL properties properly (MDEV-27151)

    Replication

    • minor correction in unsafe warning message (MDEV-28827)

    • False replication error-stop of from a non-existing user on primary (MDEV-28530) in combination with a filtering replica is corrected

    • replication is mended on a replica that filters system tables (MDEV-28294)

    • XA COMMIT is not binlogged when the has not updated any transaction engine (MDEV-25616)

    • Concurrent statements made to binlog without any mixup ()

    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

      • The full fingerprint of the key is: 177F 4010 FE56 CA33 3630 0305 F165 6F24 C74C D1D8

      • The key can be imported now in preparation for this change using the following command:

    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 issue #469

    • The environment variable LANG=C.UTF-8 has been added for those that exec into containers and copy paste UTF8 characters (fixes issue #468.

    • Adds OCI labels to image (fixes issue 436 and users need for version

    • MariaDB config: skip-host-cache and skip-name-resolve moved to /etc/mysql/mariadb.conf.d/05-skipcache.cnf

    Security

    • Fixes for the following :

    Changelog

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

    Contributors

    For a full list of contributors to MariaDB 10.5.18, see the MariaDB Foundation release announcement.

    Download
    Release Notes
    Changelog
    Overview of 10.5
    MariaDB 10.5
    MariaDB 10.4
    MariaDB 10.5.18
    Stable (GA)

    The most recent release of MariaDB 10.5 is:

    MariaDB 10.5.29 Stable (GA) Download Now

    Alternate download from mariadb.org

    Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    MDEV-19903
    MDEV-20729
    MDEV-19543
    MDEV-19544
    MDEV-19551
    MDEV-19570
    MDEV-19570
    MDEV-20907
    MDEV-18582
    MDEV-19940
    MDEV-19738
    MDEV-19514
    subscribing

    MariaDB 10.5.27 Release Notes

    Release date: 1 Nov 2024

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

    is a release.

    Thanks, and enjoy MariaDB!

    ... ANY (SELECT ... GROUP BY (SELECT redundant_subselect_here)) ...
    table.keyXpartY [NOT] IN ( ... )
    sudo rpm --import https://supplychain.mariadb.com/MariaDB-Server-GPG-KEY
    Notable Items

    Storage Engines

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

    • Fix innodb.innodb-lock-inherit-read_commited failure with timeout (MDEV-33106)

    • Fix server crash when calling after is enabled (MDEV-34682)

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

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

    Optimizer

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

    Data Definition - Alter Table

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

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

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

    Galera

    • Galera updated to 26.4.20

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

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

    • Fix galera_ssl_reload failure with warning message (MDEV-32778)

    • When InnoDB gets an assertion failure, WSREP layer is now handled gracefully ()

    Backup

    • Recovery now correctly notes some log corruption (MDEV-34802)

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

    General

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

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

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

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

    • Trigger now works correctly with bulk update ()

    • Fix assertion failure in find_producing_item upon a query from a view ()

    • Add new setting, to the mariadb client for use in --quick mode ()

    Security

    • Fixes for the following :

      • CVE--``#

    Changelog

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

    Contributors

    For a full list of contributors to MariaDB 10.5.27, see the MariaDB Foundation release announcement.

    Download
    Release Notes
    Changelog
    Overview of 10.5
    MariaDB 10.5
    maintained until
    MariaDB 10.4
    MariaDB 10.5.27
    Stable (GA)

    The most recent release of MariaDB 10.5 is:

    MariaDB 10.5.29 Stable (GA) Download Now

    Alternate download from mariadb.org

    Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    CVE-2020-28912
    MDEV-24040
    CVE-2021-2194
    MDEV-18366
    CVE-2022-21427
    MDEV-26784
    MDEV-27022
    MDEV-27183
    MDEV-27610
    MDEV-27276
    MDEV-26223
    mariadb_repo_setup
    mariadb-keyring-2019.gpg
    mariadb-keyring-2019.gpg.sha256
    issue #401
    reddit suggestion
    MDEV-27608
    MDEV-23326
    CVE-2022-24048
    CVE-2021-46659
    CVE-2022-0778
    CVE-2022-21595
    CVE-2022-31622
    CVE-2022-31623
    subscribing
    MDEV-29438
    MDEV-29475
    MDEV-29559
    MDEV-28709
    MDEV-29368
    MDEV-25606
    subscribing

    MariaDB 10.5.5 Release Notes

    The most recent release of MariaDB 10.5 is:

    Stable (GA)

    Download Release Notes Changelog Overview of 10.5

    Release date: 10 Aug 2020

    MariaDB 10.5 is the current stable series of MariaDB. 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.5 is a Stable (GA) release.

    Thanks, and enjoy MariaDB!

    Notable Changes

    Deprecated variables

    InnoDB

    • Fixed corruption in delete buffering ()

    • Fixed a deadlock in ()

    • InnoDB data file extension is not crash-safe ()

    • Minor fixes related to encryption and FULLTEXT INDEX

    Replication

    • Make the binlog dump thread to log into errorlog a requested GTID position ()

    • Fix stop of the optimistic parallel slave at requested START-SLAVE-UNTIL position ()

    • Properly handle RESET MASTER TO value, when the value exceeds the max allowed 2147483647 ()

    Optimizer

    • Improve Protocol performance for numeric data by avoiding unnecessary character string conversions ()

    • ALTER TABLE ... ANALYZE PARTITION ... with EITS reads and locks all rows ... ()

    • Print ranges in the optimizer trace created for non-indexed columns when Now the optimizer trace shows the ranges constructed while getting estimates from EITS ()

    • LATERAL DERIVED

    Other

    • is now taken into account for all intermediate calculations. Previously results could be unpredictable. Note that this means results will have a lower precision in some cases - see ()

    • data type qualifier allowing MariaDB native date types in an SQL_MODE that has conflicting data type translations.

    • MariaDB could crash after changing the query_cache size ()

    • Errors and SIGSEGV on CREATE TABLE w/ various charsets (

    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.5.16 Release Notes

    The most recent release of MariaDB 10.5 is:

    Stable (GA)

    Download Release Notes Changelog Overview of 10.5

    Release date: 20 May 2022

    MariaDB 10.5 is a previous stable series of MariaDB. 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.16 is a Stable (GA) release.

    Thanks, and enjoy MariaDB!

    Notable Items

    InnoDB

    • removed ()

    • InnoDB gap locking fixes (, )

    • InnoDB performance improvements (, )

    Replication

    • Server initialization time gtid_slave_pos purge related reason of crashing in binlog background thread is removed ()

    • Shutdown of the semisync master can't produce inconsistent state anymore ()

    • Binlogs disappear after rsync IST ()

    • master crash is eliminated in compressed semisync replication protocol with packet counting amendment ()

    Backup

    • Incorrect binlogs after Galera SST using rsync and ()

    • does not detect multi-source replication slave ()

    • Useless warning "InnoDB: Allocated tablespace ID for , old maximum was 0" during backup stage ()

    • prepare fails for incrementals if a new schema is created after full backup is taken ()

    Optimizer

    • A SEGV in Item_field::used_tables/update_depend_map_for_order... ()

    • ANALYZE FORMAT=JSON fields are incorrect for UNION ALL queries ()

    • Subquery in an UPDATE query uses full scan instead of range ()

    • Assertion `item1->type() == Item::FIELD_ITEM ... ()

    General

    • Server are ()

    • For RHEL/CentOS 7, non x86_64 architectures are no longer supported upstream and so our support will also be dropped with this release

    • As per the , this will be the last release of for Debian 9 "Stretch", Ubuntu 21.10 "Impish", and Fedora 34

    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 .

  • (MDEV-23379)

  • Dropping the adaptive hash index may cause DDL to lock up InnoDB (MDEV-22456)

  • is not crash safe (MDEV-21347)

  • Mariadb service won't shutdown when it's running and the OS datetime updated backwards (MDEV-17481)

  • Doublewrite recovery can corrupt data pages (MDEV-11799)

  • Fixed race conditions related to buffer pool resizing

  • ALTER TABLE fixes (MDEV-22637, MDEV-23244, MDEV-22988, MDEV-23295, MDEV-22771, MDEV-22811, MDEV-22899)

  • Slow InnoDB shutdown on large instance (MDEV-22778)

  • Fixes to performance regressions introduced in MariaDB 10.5.4 (MDEV-23017, MDEV-23369, MDEV-23410)

  • Performance improvements (MDEV-22110, MDEV-22930, MDEV-23379, MDEV-22778)

  • Correctly implemented the scrubbing of freed pages (MDEV-8139)

  • Crash recovery fixes (MDEV-21347, MDEV-23190, MDEV-11799)

  • Correct 'relay-log.info' updating by concurrent parallel workers (MDEV-22806)
  • Eliminate deadlock involving parallel workers, STOP SLAVE and FLUSH TABLES WITH READ LOCK (MDEV-23089)

  • Correct master-slave automatic reconnection by slave to always pass through all steps of the initial connect. Specifically, do not skip master notification about slave binlog checksum awareness (MDEV-14203)

  • Refine mysqlbinlog output to print out START TRANSACTION at Gtid_log_event processing which satisfies clients that submit the output with sql_mode=oracle (MDEV-23108)

  • Replication aborts with ER_SLAVE_CONVERSION_FAILED upon CREATE ... SELECT in ORACLE mode (MDEV-19632)

  • is not clearly visible in
    , make LATERAL DERIVED tables visible in EXPLAIN FORMAT=JSON output (
    )
  • Crash on large query (MDEV-22748)

  • Crash with Prepared Statement with a '?' parameter inside a re-used CTE (MDEV-22779)

  • )
  • Crash in CREATE TABLE AS SELECT when the precision of returning type = 0 (MDEV-22502)

  • XA: Reject DDL operations between PREPARE and COMMIT (MDEV-22420)

  • Stop mariadb-backup --prepare on errors during innodb redo log applying (MDEV-22354)

  • Server crashes in mysql_alter_table upon adding a non-null date column under NO_ZERO_DATE with ALGORITHM=INPLACE (MDEV-18042)

  • Can't uninstall plugin if the library file doesn't exist (MDEV-21258)

  • mariadb-backup parameter cleanup (MDEV-18215, MDEV-21298, MDEV-21301, MDEV-22894)

  • Rounding functions return wrong datatype (MDEV-23366, MDEV-23367, MDEV-23368, MDEV-23350, MDEV-23351, MDEV-23337, MDEV-23323)

  • Create mariadb.sys user on each update even is the user is not needed (MDEV-23102)

  • required SUPER instead PROCESS privilege (MDEV-23003)

  • Reinforce DDL operation rejection after XA PREPARE (MDEV-22420)

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.5 for Ubuntu 19.10 Eoan and Fedora 30

  • Fixes for the following :

    • CVE-2021-2022

  • MDEV-22497
    MDEV-22890
    MDEV-23190
    MDEV-20428
    MDEV-15152
    MDEV-22451
    MDEV-23162
    MDEV-21472
    MDEV-22665
    MDEV-19232
    MDEV-5924
    MariaDB 10.5.5
    changelog
    MariaDB 10.5.5
    MariaDB Foundation release announcement
    MariaDB 10.5.29
    Download Now
    Alternate download from mariadb.org

    Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    MDEV-17568
    MDEV-22111

    OPTIMIZE on a sequence does not cause counterfactual ER_BINLOG_UNSAFE_STATEMENT anymore (MDEV-24617)

  • Automatically generated Gtid_log_list_event is made to recognize within replication event group as a formal member (MDEV-28550)

  • using two or more unique key values at a time with is corrected (MDEV-28310)

  • stops issuing unnecessary "Unsafe statement" with (MDEV-21810)

  • Incomplete replication event groups are detected to error out by the slave IO thread (MDEV-27697)

  • now flushes the result file to disk after each processed event so the file can be listed with the actual bytes (MDEV-14608)

  • Server crashes in Expression_cache_tracker::fetch_current_stats (MDEV-28268)

  • MariaDB server crash at Item_subselect::init_expr_cache_tracker (MDEV-26164, MDEV-26047)

  • Crash with union of my_decimal type in ORDER BY clause (MDEV-25994)

  • SIGSEGV in st_join_table::cleanup (MDEV-24560)

  • Assertion `!eliminated' failed in Item_subselect::exec (MDEV-28437)

  • CVE-2022-27378

  • CVE-2022-27379

  • CVE-2022-27380

  • CVE-2022-27381

  • CVE-2022-27382

  • CVE-2022-27383

  • CVE-2022-27384

  • CVE-2022-27386

  • CVE-2022-27387

  • CVE-2022-27444

  • CVE-2022-27445

  • CVE-2022-27446

  • CVE-2022-27447

  • CVE-2022-27448

  • CVE-2022-27449

  • CVE-2022-27451

  • CVE-2022-27452

  • CVE-2022-27455

  • CVE-2022-27456

  • CVE-2022-27457

  • CVE-2022-27458

  • CVE-2022-32087

  • CVE-2022-32086

  • CVE-2022-32085

  • CVE-2022-32083

  • CVE-2022-32088

  • MDEV-25975
    MDEV-20605
    MDEV-28422
    MDEV-27557
    MDEV-28185
    MDEV-26473
    MDEV-11853
    MDEV-28583
    MDEV-25580
    MDEV-27524
    MDEV-21037
    MDEV-27343
    MDEV-28446
    MDEV-26402
    MDEV-27699
    MDEV-22377
    MDEV-19398
    MDEV-28227
    MariaDB Deprecation Policy
    MariaDB 10.5
    CVE-2021-46669
    CVE-2022-27376
    CVE-2022-27377
    MariaDB 10.5.16
    changelog
    MariaDB 10.5.16
    MariaDB Foundation release announcement
    MariaDB 10.5.29
    Download Now
    Alternate download from mariadb.org

    Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    MDEV-32363
    MDEV-34718
    MDEV-35276
    MDEV-34704
    subscribing

    MariaDB 10.5.9 Release Notes

    The most recent release of MariaDB 10.5 is:

    Stable (GA)

    Download Release Notes Changelog Overview of 10.5

    Release date: 22 Feb 2021

    Last month long-time MariaDB VP of Engineering, Rasmus Johansson, passed due to complications from cancer. His loss has been felt keenly by the whole MariaDB team. Our thoughts are with his family during this difficult time and this release is dedicated to his memory.

    MariaDB 10.5 is the current stable series of MariaDB. 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.9 is a Stable (GA) release.

    Thanks, and enjoy MariaDB!

    Notable Changes

    InnoDB

    • - Hang in buf_page_create() after reusing a previously freed page

    • - analyze forces full scan forcing lock crash

    • - Corruption of system tablespace or last recovered page

    • - InnoDB hangs with

    Galera

    • updated to 26.4.7

    • - Server hang due to Galera lock conflict resolution

    • - BF-BF Conflict issue because of UK GAP locks

    • - Plugin system variables and activation options can break

    Replication

    • - relay-log is corrected to rotate past 999999

    • - fixed slave applier for row-based events with FK constraints on virtual columns

    • - Relay_Log_Space of Show-Slave-Status is made thread-safe

    • - add master host/port info to slave thread exit messages

    ColumnStore

    • MariaDB ColumnStore updated to 5.5.1

    • MariaDB ColumnStore deb and rpm packages now have a version of 10.5.9-5.5.1 so one can see both the server version (10.5.9) and the plugin version (5.5.1) without needing to check the table in the ColumnStore docs

    • The MariaDB ColumnStore plugin is no longer provided for 32-bit x86 (i386) builds

    Misc

    • MariaDB is fixed to build on the Apple M1 CPU

    • MariaDB is fixed to build on AIX

    • - anomalies in mysql.user tables on previously 5.7 MySQL versions corrected

    • - Detect during if type_mysql_json.so is needed and load it

    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 .

  • MDEV-24537 - lost its special meaning

  • Fixed bugs in the handling of freed pages - MDEV-24569, MDEV-24695, MDEV-24765, MDEV-24864

  • MDEV-12227 - Defer writes to the InnoDB temporary tablespace

  • MDEV-24469 - Assertion active() == false failed with "XA START.."

  • MDEV-23647 - Garbd can't initiate SST anymore in 10.5

  • MDEV-25179 - and system variables are now read-only

  • MDEV-23846 - improves error message issuing

  • MDEV-24087 - replication of ALTER PARTITION corrected

  • MDEV-23610 - New privilege (also accessible as SLAVE MONITOR)

  • Binary tarballs now use WolfSSL v4.6.0 and pcre2-10.36

  • MDEV-23630 - option

  • Fixes for the following :

    • CVE-2021-27928

  • MDEV-24188
    MDEV-24275
    MDEV-24449
    MDEV-24109
    MDEV-23328
    MDEV-23851
    MDEV-20717
    MDEV-8134
    MDEV-23033
    MDEV-4633
    MDEV-10272
    Available Versions
    MDEV-24122
    MDEV-24093
    MariaDB 10.5.9
    changelog
    MariaDB 10.5.9
    MariaDB Foundation release announcement
    MariaDB 10.5.29
    Download Now
    Alternate download from mariadb.org
    Galera

    Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    MariaDB 10.5.22 Release Notes

    Release date: 14 Aug 2023

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

    is a release.

    Thanks, and enjoy MariaDB!

    Notable Items

    General

    • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.5 for Ubuntu 18.04 LTS "Bionic"

    • doesn't ignore error as it should (MDEV-31092)

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

    • SQL/PL package body does not appear in I_S.ROUTINES.ROUTINE_DEFINITION ()

    • Unexpected result when combining , subselect and ()

    • variables do not get assigned from subselects ()

    • Crash after setting global session_track_system_variables to an invalid value ()

    • ODKU of non-versioning column inserts history row ()

    • UPDATE not working properly on transaction precise system versioned table ()

    • Assertion ``const_item_cache == true'failed inItem_func::fix_fields` ()

    • ANALYZE doesn't work with pushed derived tables ()

    • get_partition_set is never executed in ha_partition::multi_range_key_create_key due to bitwise & with 0 constant ()

    • Client can crash the server with a mysql_list_fields("view") call ()

    • I_S.parameters not immediatly changed updated after procedure change ()

    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 (MDEV-28384)

    • Possibly wrong result or Assertion 0' failed in Item_func_round::native_op` (MDEV-23838)

    • Assertion ``(length % 4) == 0'failed inmy_lengthsp_utf32onSELECT` ()

    • UBSAN: negation of -X cannot be represented in type 'long long int'; cast to an unsigned type to negate this value to itself in Item_func_mul::int_op and Item_func_round::int_op ()

    • Assorted assertion failures in json_find_path with certain collations ()

    InnoDB

    • innochecksum dies with Floating point exception (MDEV-31641)

    • Deadlock with 3 concurrent by (MDEV-10962)

    • innodb protection against dual processes accessing data insufficient (MDEV-31568)

    • Assertion ``!strcmp(index->table->name.m_name, "SYS_FOREIGN") || !strcmp(index->table->name.m_name, "SYS_FOREIGN_COLS")'failed inbtr_node_ptr_max_size` ()

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

    • Freed data pages are not always being scrubbed ()

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

    • fil_ibd_create() may hijack the file handle of an old file ()

    • recovery results in a corrupted undo log ()

    • Foreign Key Constraint actions don't affect Virtual Column ()

    Aria

    • Various crashes upon INSERT/UPDATE after changing Aria settings (MDEV-28054)

    • Various crashes/asserts/corruptions when Aria encryption is enabled/used, but the encryption plugin is not loaded (MDEV-26258)

    Spider

    • SIGSEGV in spider_db_open_item_field and SIGSEGV in spider_db_print_item_type, on SELECT (MDEV-29447)

    • that double as table params overriding mechanism is buggy (MDEV-31524)

    Optimizer

    • Assertion ``last_key_entry >= end_pos'failed in virtual boolJOIN_CACHE_HASHED::put_record()` (MDEV-31348)

    • Problem with open ranges on prefix blobs keys (MDEV-31800)

    • Equal on two create wrong result (MDEV-20010)

    • Recursive CTE execution is interrupted without errors or warnings ()

    • Assertion ``s->table->opt_range_condition_rows <= s->found_records'failed inapply_selectivity_for_table` ()

    • Inconsistency between MRR and SQL layer costs can cause poor query plan ()

    • MAX_SEL_ARG memory exhaustion is not visible in the optimizer trace ()

    • not working properly with lower_case_table_names=2 ()

    • Segfault on select query using index for group-by and filesort ()

    • Server crash in store_length, assertion failure in Type_handler_string_result::sort_length ()

    Replication

    • Parallel Slave SQL Thread Can Update Seconds_Behind_Master with Active Workers (MDEV-30619)

    • ends up in optimistic parallel slave binlog out-of-order (MDEV-31503)

    • takes very long time on a busy system (MDEV-13915)

    • On slave fail to return an error in read-only mode (MDEV-30978)

    • rpl.rpl_manual_change_index_file occasionally fails in BB with Result length mismatch ()

    Galera

    • Node has been dropped from the cluster on Startup / Shutdown with async replica (MDEV-31413)

    • KILL QUERY maintains nodes data consistency but breaks GTID sequence (MDEV-31075)

    • MariaDB stuck on starting commit state (waiting on commit order critical section) (MDEV-29293)

    • Assertion state() == s_aborting || state() == s_must_replay failed in int wsrep::transaction::after_rollback() ()

    • Assertion !wsrep_has_changes(thd) || (thd->lex->sql_command == SQLCOM_CREATE_TABLE && !thd->is_current_stmt_binlog_format_row()) || thd->wsrep_cs().transaction().state() == wsrep::transaction::s_aborted failed ()

    • Server crashes when wsrep_sst_donor and wsrep_cluster_address set to NULL ()

    • Create temporary sequence can cause inconsistency ()

    • Galera 4 unable to query cluster state if not primary component ()

    Security

    • Fixes for the following :

      • CVE--``#

    Changelog

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

    Contributors

    For a full list of contributors to MariaDB 10.5.22, see the MariaDB Foundation release announcement.

    Download
    Release Notes
    Changelog
    Overview of 10.5
    MariaDB 10.5
    maintained until
    MariaDB 10.4
    MariaDB 10.5.22
    Stable (GA)

    The most recent release of MariaDB 10.5 is:

    MariaDB 10.5.29 Stable (GA) Download Now

    Alternate download from mariadb.org

    Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    MariaDB 10.5.20 Release Notes

    The most recent release of MariaDB 10.5 is:

    Stable (GA)

    Download Release Notes Changelog Overview of 10.5

    Release date: 10 May 2023

    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.20 is a Stable (GA) release.

    For an overview of MariaDB 10.5 see theWhat is MariaDB 10.5? 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 ().

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

    • A GROUP BY query with MIN(primary_key) in select list and primary_key<>const in the WHERE could produce wrong result when executed with "Using index for group-by" strategy ()

    Docker Official Images

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

    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 .

    Galera wsrep library
    Galera wsrep library
    Galera wsrep library
    wsrep_incoming_addresses
    wsrep_node_incoming_address
    mysqld --wsrep_recover
    wsrep_provider
    wsrep_notify_cmd

    MariaDB 10.5 Changes & Improvements

    MariaDB 10.5 is no longer maintained. Please use a .

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

    Upgrading

    • See and .

    InnoDB recovery hangs when buffer pool ran out of memory (MDEV-30551)

  • InnoDB undo log truncation fails to wait for purge of history (MDEV-30671

  • Fix miscount of doublewrites by (MDEV-31124)

  • Refined optimistic parallel slave to error-exit without any hang (MDEV-30780)

  • Ensured SHOW-SLAVE-STATUS is processed on the parallel slave having a necessary mutex always intialized (MDEV-30620)

  • Fixed the slave applier to report a correct error when gtid_slave_pos insert fails for some (engine) reasons (MDEV-31038)

  • EXPLAIN could erroneously report that is used for partitioned tables. Partitioned tables do not support it. (MDEV-30596)

  • A bug in selectivity computations for SINGLE/DOUBLE_PREC_HB histograms could cause wrong estimates to be produced. This could cause the optimizer to pick sub-optimal query plans (MDEV-31067).

  • MDEV-30882
    MDEV-30034
    MDEV-30567
    MDEV-23855
    MDEV-30775
    MDEV-28187
    MDEV-29050
    MDEV-30968
    MDEV-30860
    MDEV-29621
    MDEV-31077
    MDEV-30430
    MDEV-28798
    MDEV-26301
    MDEV-20057
    MDEV-30605
    MDEV-29762
    CVE-2022-47015
    MariaDB 10.5.20
    changelog
    MariaDB 10.5.20
    MariaDB Foundation release announcement
    MariaDB 10.5.29
    Download Now
    Alternate download from mariadb.org

    Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    Implemented Features

    See the Differences in MariaDB Enterprise Server 10.5 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 MariaDB ColumnStore 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. (MDEV-21303)

    • 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

    • Same for the mariadbd-safe wrapper script. Even when called via the mysqld_safe symlink, it will start the actual server process as mariadbd, not mysqld now. This also affects startup via system service init scripts on platforms that don't yet have switched to SystemD

    INET 6 Data Type

    • New data type for storing IPv6 addresses (MDEV-274)

    Amazon S3

    • The allows one to archive MariaDB tables in Amazon S3, or any third-party public or private cloud that implements S3 API ( MDEV-22606)

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

    Privileges Made More Granular

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

    • The privilege was renamed to . The old syntax is understood for compatibility ().

    • The statement was renamed to (). The old syntax is understood for compatibility.

    • A number of statements changed the privileges that they require. The old privileges were historically inappropriately chosen in the upstream. 10.5.2 fixes this problem. Note, these changes are incompatible to previous versions. A number of GRANT commands might be needed after upgrade.

      • now requires the privilege (required prior to 10.5.2).

      • now requires the privilege (required prior to 10.5.2).

    • In order to help the server understand which version a privilege record was written by, the field contains a new JSON field, version_id ()

    • now correctly lists the Delete history privilege, rather than displaying it as Delete versioning rows. ()

    InnoDB: Performance Improvements etc.

    • Extend LIKE 'Innodb_%' (MDEV-18582)

    • Clean up tables (MDEV-19940)

    • Doublewrite buffer is unnecessarily used for newly (re)initialized pages (MDEV-19738)

    • Defer change buffer merge until pages are requested (MDEV-19514)

    • Remove dummy tablespace for the ()

    • Optimize access to InnoDB page header fields ()

    • Remove multiple instances ()

      • Columns that indicated the buffer pool instance from the Information Schema , , , and tables now return a dummy value of 0.

    • Remove buf_page_t::newest_modification ()

    • Replace recv_sys_t::addr_hash with a std::map ()

    • Obsolete internal parser for FK in InnoDB ()

    • InnoDB thread pool for background tasks ()

    • An upgrade will only be possible after a clean shutdown. mariadb-backup --prepare will not work with backups taken before version 10.5.2.

    • Efficient InnoDB redo log record format ()

    • Improve InnoDB redo log group commit performance ()

    • Do not acquire InnoDB record locks when covering table locks exist ()

    • Issue a message on changing deprecated innodb_log_files_in_group ()

    • Optimize append only files for NVDIMM ()

    • Avoid writing freed InnoDB pages ()

    InnoDB New Defaults for Variables

    • now defaults to OFF (MDEV-20487)

    • now defaults to full_crc32 (MDEV-19534)

    InnoDB Removed or Deprecated Variables

    • (MDEV-19534)

    • (MDEV-19544)

    • (MDEV-19543)

    • ( & )

    • ()

    • ()

    • and ()

    • Remove table and deprecate and ignore:

    • ()

    • ()

    • ()

    • ()

    Performance Schema Updates to Match MySQL 5.7 Instrumentation and Tables

    • Memory (MDEV-16431)

    • Meta data locking (MDL) (MDEV-16432)

    • Prepared statements (ps) (MDEV-16433)

    • [show] status instrumentation and tables (MDEV-16438)

    • Stored procedures ()

    • Sxlocks ()

    • Transactions ()

    • User variables ()

    Galera: Full GTID Support

    • Add full support to Galera cluster (commit). 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 (MDEV-20051)

    • Galera: Replicate MariaDB GTID to other nodes in the cluster (MDEV-20720)

    Binary Log and Replication: More Metadata

    • now defaults to optimistic (MDEV-18648).

    • Make REPLICA a synonym for (MDEV-20601)

    • ENFORCE option for (MDEV-21833)

    • Extended metadata () to include new fields. This was done to solve replication issues when the Master and Slave table had different definitions for a column which could lead to data loss (). It also enables us to do better replication with pluggable data types in the future.

      • The new metadata fields are:

        • Signedness of Numeric Columns

        • Character Set of Character Columns and Binary Columns

        • Column Name

    • Binary log DDL entries can now be marked that they should be ignored if the target table doesn't exist (implicit IF EXISTS).

    • output is extended to show all replication flags. Example of output: SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1, @@session.sql_if_exists=0/*!*/.

    • and are extended to show replication flags.

    Syntax

    • (MDEV-10014) - returns SELECT of inserted rows (analogous to )

    • (MDEV-10014)

    • and (MDEV-18844)

    • Application period tables: (MDEV-16978)

    • Setup ()

    • Database comments in and statements ()

    • ()

    • ()

    • and now support IF EXISTS.

    • Add in CREATE TABLE ()

    • Recursive cycle detection using CYCLE clause ()

    • hold by ()

    • Fix in column definition ()

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

    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.

    • Improve connect speed (up to 25%). ()

    Query Optimizer

    • Improve Protocol performance for numeric data by avoiding unnecessary character string conversions (MDEV-23162, MDEV-23478)

    • is improved, now it also shows the time spent checking the WHERE clause and doing other auxiliary operations (MDEV-20854)

    • (MDEV-15777)

    • Allow packed sort keys and values of non-sorted fields in the sort buffer (MDEV-21263 & MDEV-21580)

      • Makes filesort temporary files much smaller when , or are used!

    General

    • The has a new column showing from which config file a variable derives its value (MDEV-12684)

    • Switch Perl DBI scripts from DBD::mysql to DBD::MariaDB driver (MDEV-19755)

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

    • Accelerated crc32() function for AMD64, ARMv8, POWER 8 ()

    • Binary tarball size has been reduced ()

    PCRE (Perl Compatible Regular Expressions)

    • Migrate to (MDEV-14024), 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 (MDEV-12684).

    • Port from MySQL 5.6 (MDEV-19906). 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 (MDEV-18650)

    Security Vulnerabilities Fixed in MariaDB 10.5

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

    • CVE-2025-21490: MariaDB 10.5.28

    • CVE-2024-21096: MariaDB 10.5.25

    • CVE-2023-5157: MariaDB 10.5.17

    • CVE-2023-22084: MariaDB 10.5.23

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    Resources

    • 10.5 and beyond (video presentation by Sergei Golubchik)

    List of All MariaDB 10.5 Releases

    Date
    Release
    Status
    Release Notes
    Changelog

    8 May 2025

    Stable (GA)

    4 Feb 2025

    Stable (GA)

    more recent release
    MariaDB 10.5
    maintained until

    The most recent release of MariaDB 10.5 is:

    MariaDB 10.5.29 Stable (GA) Download Now

    Alternate download from mariadb.org

    MDEV-30662
    MDEV-28285
    MDEV-31250
    MDEV-25237
    MDEV-23100
    MDEV-25644
    MDEV-31319
    MDEV-29284
    MDEV-24712
    MDEV-30159
    MDEV-31064
    MDEV-29019
    MDEV-30932
    MDEV-23187
    MDEV-19216
    MDEV-31086
    MDEV-31487
    MDEV-31442
    MDEV-31256
    MDEV-31253
    MDEV-31355
    MDEV-31382
    MDEV-29967
    MDEV-31347
    MDEV-31373
    MDEV-18114
    MDEV-31214
    MDEV-31449
    MDEV-31479
    MDEV-30964
    MDEV-30765
    MDEV-30143
    MDEV-31743
    MDEV-30214
    MDEV-30013
    MDEV-30388
    MDEV-28433
    MDEV-31335
    MDEV-21479
    subscribing

    MariaDB 10.5.23 Release Notes

    Release date: 13 Nov 2023

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

    is a release.

    Thanks, and enjoy MariaDB!

    now requires the or the privilege (required or prior to 10.5.2).
  • now requires the privilege (required prior to 10.5.2).

  • String Value of SET Columns

  • String Value of ENUM Columns

  • Primary Key

  • Character Set of SET Columns and ENUM Columns

  • Geometry Type

  • Also added a new global variable, to control the amount of metadata logged. Possible values are:

    • FULL - all metadata is logged

    • MINIMAL - only metadata required by a worker is logged

    • NO_LOG - No metadata is logged (default)

  • 1 Nov 2024

    MariaDB 10.5.27

    Stable (GA)

    Release Notes

    Changelog

    8 Aug 2024

    MariaDB 10.5.26

    Stable (GA)

    Release Notes

    Changelog

    16 May 2024

    MariaDB 10.5.25

    Stable (GA)

    Release Notes

    Changelog

    7 Feb 2024

    MariaDB 10.5.24

    Stable (GA)

    Release Notes

    Changelog

    13 Nov 2023

    MariaDB 10.5.23

    Stable (GA)

    Release Notes

    Changelog

    14 Aug 2023

    MariaDB 10.5.22

    Stable (GA)

    Release Notes

    Changelog

    7 Jun 2023

    MariaDB 10.5.21

    Stable (GA)

    Release Notes

    Changelog

    10 May 2023

    MariaDB 10.5.20

    Stable (GA)

    Release Notes

    Changelog

    6 Feb 2023

    MariaDB 10.5.19

    Stable (GA)

    Release Notes

    Changelog

    7 Nov 2022

    MariaDB 10.5.18

    Stable (GA)

    Release Notes

    Changelog

    15 Aug 2022

    MariaDB 10.5.17

    Stable (GA)

    Release Notes

    Changelog

    20 May 2022

    MariaDB 10.5.16

    Stable (GA)

    Release Notes

    Changelog

    12 Feb 2022

    MariaDB 10.5.15

    Stable (GA)

    Release Notes

    Changelog

    9 Feb 2022

    MariaDB 10.5.14

    Stable (GA)

    Release Notes

    Changelog

    8 Nov 2021

    MariaDB 10.5.13

    Stable (GA)

    Release Notes

    Changelog

    6 Aug 2021

    MariaDB 10.5.12

    Stable (GA)

    Release Notes

    Changelog

    23 Jun 2021

    MariaDB 10.5.11

    Stable (GA)

    Release Notes

    Changelog

    7 May 2021

    MariaDB 10.5.10

    Stable (GA)

    Release Notes

    Changelog

    22 Feb 2021

    MariaDB 10.5.9

    Stable (GA)

    Release Notes

    Changelog

    11 Nov 2020

    MariaDB 10.5.8

    Stable (GA)

    Release Notes

    Changelog

    3 Nov 2020

    MariaDB 10.5.7

    Stable (GA)

    Release Notes

    Changelog

    7 Oct 2020

    MariaDB 10.5.6

    Stable (GA)

    Release Notes

    Changelog

    10 Aug 2020

    MariaDB 10.5.5

    Stable (GA)

    Release Notes

    Changelog

    24 Jun 2020

    MariaDB 10.5.4

    Stable (GA)

    Release Notes

    Changelog

    12 May 2020

    MariaDB 10.5.3

    RC

    Release Notes

    Changelog

    26 Mar 2020

    MariaDB 10.5.2

    Beta

    Release Notes

    Changelog

    14 Feb 2020

    MariaDB 10.5.1

    Beta

    Release Notes

    Changelog

    3 Dec 2019

    MariaDB 10.5.0

    Alpha

    Release Notes

    Changelog

    MDEV-21743
    MDEV-21743
    MDEV-21704
    MDEV-20382
    MDEV-18115
    MDEV-21133
    MDEV-15058
    MDEV-21132
    MDEV-19586
    MDEV-20480
    MDEV-16264
    MDEV-12353
    MDEV-21534
    MDEV-14479
    MDEV-21990
    MDEV-17084
    MDEV-15528
    MDEV-14425
    MDEV-20907
    MDEV-19747
    MDEV-19570
    MDEV-21870
    MDEV-15528
    MDEV-19551
    MDEV-19570
    MDEV-23379
    MDEV-16434
    MDEV-16436
    MDEV-16435
    MDEV-16439
    MDEV-20477
    MDEV-19708
    MDEV-19903
    MDEV-307
    MDEV-7318
    MDEV-16290
    MDEV-22199
    MDEV-20632
    MDEV-10569
    MDEV-20729
    MDEV-19515
    MDEV-22669
    MDEV-21943
    CVE-2022-47015
    MariaDB 10.5.20
    CVE-2022-38791
    MariaDB 10.5.17
    CVE-2022-32091
    MariaDB 10.5.17
    CVE-2022-32089
    MariaDB 10.5.17
    CVE-2022-32088
    MariaDB 10.5.16
    CVE-2022-32087
    MariaDB 10.5.16
    CVE-2022-32086
    MariaDB 10.5.16
    CVE-2022-32085
    MariaDB 10.5.16
    CVE-2022-32084
    MariaDB 10.5.17
    CVE-2022-32083
    MariaDB 10.5.16
    CVE-2022-32082
    MariaDB 10.5.17
    CVE-2022-32081
    MariaDB 10.5.17
    CVE-2022-31624
    MariaDB 10.5.13
    CVE-2022-27458
    MariaDB 10.5.16
    CVE-2022-27457
    MariaDB 10.5.16
    CVE-2022-27456
    MariaDB 10.5.16
    CVE-2022-27455
    MariaDB 10.5.16
    CVE-2022-27452
    MariaDB 10.5.16
    CVE-2022-27451
    MariaDB 10.5.16
    CVE-2022-27449
    MariaDB 10.5.16
    CVE-2022-27448
    MariaDB 10.5.16
    CVE-2022-27447
    MariaDB 10.5.16
    CVE-2022-27446
    MariaDB 10.5.16
    CVE-2022-27445
    MariaDB 10.5.16
    CVE-2022-27444
    MariaDB 10.5.16
    CVE-2022-27387
    MariaDB 10.5.16
    CVE-2022-27386
    MariaDB 10.5.16
    CVE-2022-27385
    MariaDB 10.5.13
    CVE-2022-27384
    MariaDB 10.5.16
    CVE-2022-27383
    MariaDB 10.5.16
    CVE-2022-27382
    MariaDB 10.5.16
    CVE-2022-27381
    MariaDB 10.5.16
    CVE-2022-27380
    MariaDB 10.5.16
    CVE-2022-27379
    MariaDB 10.5.16
    CVE-2022-27378
    MariaDB 10.5.16
    CVE-2022-27377
    MariaDB 10.5.16
    CVE-2022-27376
    MariaDB 10.5.16
    CVE-2022-24052
    MariaDB 10.5.14
    CVE-2022-24051
    MariaDB 10.5.14
    CVE-2022-24050
    MariaDB 10.5.14
    CVE-2022-24048
    MariaDB 10.5.14
    CVE-2022-21595
    MariaDB 10.5.14
    CVE-2022-21451
    MariaDB 10.5.10
    CVE-2022-21427
    MariaDB 10.5.7
    CVE-2022-0778
    MariaDB 10.5.14
    CVE-2021-46669
    MariaDB 10.5.16
    CVE-2021-46668
    MariaDB 10.5.15
    CVE-2021-46667
    MariaDB 10.5.13
    CVE-2021-46666
    MariaDB 10.5.11
    CVE-2021-46665
    MariaDB 10.5.15
    CVE-2021-46664
    MariaDB 10.5.15
    CVE-2021-46663
    MariaDB 10.5.15
    CVE-2021-46662
    MariaDB 10.5.13
    CVE-2021-46661
    MariaDB 10.5.15
    CVE-2021-46659
    MariaDB 10.5.14
    CVE-2021-46658
    MariaDB 10.5.12
    CVE-2021-46657
    MariaDB 10.5.11
    CVE-2021-35604
    MariaDB 10.5.13
    CVE-2021-27928
    MariaDB 10.5.9
    CVE-2021-2389
    MariaDB 10.5.12
    CVE-2021-2372
    MariaDB 10.5.12
    CVE-2021-2194
    MariaDB 10.5.7
    CVE-2021-2166
    MariaDB 10.5.10
    CVE-2021-2154
    MariaDB 10.5.10
    CVE-2021-2022
    MariaDB 10.5.5
    CVE-2020-28912
    MariaDB 10.5.7
    CVE-2020-15180
    MariaDB 10.5.6
    CVE-2020-14812
    MariaDB 10.5.7
    CVE-2020-14789
    MariaDB 10.5.7
    CVE-2020-14776
    MariaDB 10.5.7
    CVE-2020-14765
    MariaDB 10.5.7
    CVE-2018-25032
    MariaDB 10.5.17
    MariaDB 10.5.29
    Release Notes
    Changelog
    MariaDB 10.5.28
    Release Notes
    Changelog
    Notable Items

    InnoDB

    • followed by may corrupt data (MDEV-32132)

    • ROW_FORMAT=COMPRESSED table: InnoDB: 2048 bytes should have been read. Only 0 bytes read. (MDEV-31875)

    • Server aborts during alter operation when table doesn't have foreign index (MDEV-32527)

    • row_merge_fts_doc_tokenize() handles FTS plugin parser inconsistently (MDEV-32578)

    • InnoDB: tried to purge non-delete-marked record of an index on a virtual column prefix ()

    • lock_row_lock_current_waits counter in information_schema.innodb_metrics may become negative ()

    • SET GLOBAL innodb_max_purge_lag_wait=… hangs if innodb_read_only=ON ()

    • Auto-increment no longer works for explicit FTS_DOC_ID ()

    • Assertion `pos < table->n_def' failed in dict_table_get_nth_col ()

    • innochecksum man pages seem to be inconsistent with the binary (10.2.25) ()

    • innodb_compression_algorithm=0 (none) increments Innodb_num_pages_page_compression_error ()

    • wrong table name in innodb's "row too big" errors ()

    • Optimize is_file_on_ssd() to speedup opening tablespaces on Windows ()

    • Race condition between page write completion and log checkpoint ()

    • After crash recovery, Checksum mismatch + Failing assertion: !i || prev_id + 1 == space_id, ()

    • Deadlock due to log_free_check(), involving trx_purge_truncate_rseg_history() and trx_undo_assign_low() ()

    • Write-ahead logging is broken for freed pages ()

    • X-lock on supremum for prepared transaction for RR ()

    Optimizer

    • Crash when HAVING in a correlated subquery references columns in the outer query (MDEV-29731)

    • Server crashes at TABLE::add_tmp_key (MDEV-32320)

    • Server crashes inside filesort at my_decimal::to_binary (MDEV-32324)

    • Assertion `bitmap_is_set(&m_part_info->read_partitions, m_part_spec.start_part)' failed in ha_partition::handle_ordered_index_scan (MDEV-24283)

    • Crash when searching for the best split of derived table ()

    • Test case from opt_tvc.test fails with statement memory protection ()

    • Significant slowdown for query with many outer joins ()

    • test_if_skip_sort_order() should catch the join types JT_EQ_REF, JT_CONST and JT_SYSTEM and skip sort order for these ()

    Replication

    • rpl.rpl_parallel_temptable failure due to incorrect commit optimization of temptables (MDEV-10356)

    • Lock wait timeout with INSERT-SELECT, autoinc, and statement-based replication (MDEV-31482)

    • strings/ctype-ucs2.c:2336: my_vsnprintf_utf32: Assertion `(n % 4) == 0' failed in my_vsnprintf_utf32 on INSERT (MDEV-32249)

    • Assertion fails in MDL_context::acquire_lock upon parallel replication of CREATE SEQUENCE (MDEV-31792)

    • SHOW SLAVE STATUS Last_SQL_Errno Race Condition on Errored Slave Restart ()

    • seconds_behind_master is inaccurate for Delayed replication ()

    • detailize the semisync replication magic number error ()

    • Parallel replication deadlock victim preference code errorneously removed ()

    Galera

    • Galera updated to 26.4.16

    • Assertion `state() == s_executing || state() == s_prepared || state() == s_committing || state() == s_must_abort || state() == s_replaying' failed. (MDEV-24912)

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

    • wsrep_sst_mariadb-backup not working on FreeBSD (MDEV-31467)

    • Galera library 26.4.16 fails with every server version ()

    • Galera node remains paused after interleaving FTWRLs ()

    • Failed to insert streaming client ()

    • When set at runtime, accepts any value ()

    • galera needs packaging script changes to successfully build ()

    • replication breaks when using optimistic replication and replica is a galera node ()

    • McAfee database vulnerability scan caused MariaDB crash with signal 6 (system abort) ()

    Data Definition

    • MariaDB crash on calling function (MDEV-23902)

    • ASAN errors in grn_obj_unlink / ha_mroonga::clear_indexes upon index operations (MDEV-31970)

    • vcol circular references lead to stack overflow (MDEV-31112)

    Scripts and Clients

    • (mysqlbinlog) option (MDEV-25369)

    • (mysqladmin) wrong error with (MDEV-22418)

    • shows warning on missing directory $pamtooldir/auth_pam_tool_dir (MDEV-32142)

    • main.mysql_client_test, main.mysql_client_test_comp failed on ASAN build with error: 5888, status: 23, errno: 2 (MDEV-19369)

    • (mysql_install_db) doesn't properly grant to all default root user accounts ()

    Tests

    • main.events_stress or events.events_stress fails with view-protocol (MDEV-31455)

    • main.delete_use_source fails (hangs) with view-protocol (MDEV-31457)

    • main.sum_distinct-big and main.merge-big fail with timeout with view-protocol (MDEV-31465)

    • main.secure_file_priv_win fails with 2nd execution PS protocol (MDEV-32023)

    • Windows : mtr output on is messed up with large MTR_PARALLEL ()

    • main.mysql_client_test_comp failed in buildbot, error on exec ()

    • main.order_by_pack_big fails with view-protocol ()

    mariadb-backup

    • mariadb-backup full backup failed with InnoDB: Failing assertion: success in storage/innobase/fil/fil0fil.cc line 657 (MDEV-18200)

    • mbstream breaks page compression on XFS (MDEV-25734)

    Character Sets, Data Types, Collations

    • Prefix keys for CHAR work differently for MyISAM vs InnoDB (MDEV-30048)

    • Inconsistent results of DISTINCT with NOPAD (MDEV-30050)

    • Assertion `(length % 4) == 0' failed in my_lengthsp_utf32 on INSERT (MDEV-28835)

    • Compressed varchar values lost on joins when sorting on columns from joined table(s) (MDEV-31724)

    • UBSAN shift exponent X is too large for 64-bit type 'long long int' in sql/field.cc ()

    • Wrong bit encoding using COALESCE ()

    Spider

    • Spider UBSAN runtime error: applying non-zero offset x to null pointer in st_spider_param_string_parse::restore_delims (MDEV-31117)

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

    • ASAN errors in spider_fields::free_conn_holder or spider_create_group_by_handler (MDEV-28998)

    • ASAN: heap-buffer-overflow & stack-buffer-overflow in spider_db_mbase_row::append_to_str | SIGSEGV's in memmove_avx_unaligned_erms from memcpy in Binary_string::q_append, in Static_binary_string::q_append and my_strntoull10rnd_8bit | Unknown error 12801 ()

    General

    • option breaks importing sql dumps (MDEV-29989)

    • Crashes in MDL_key::mdl_key_init with lower-case-table-names=2 (MDEV-32025)

    • getting error 'Illegal parameter data types row and bigint for operation '+' ' when using ITERATE in a FOR..DO (MDEV-32275)

    • Assertion `arena_for_set_stmt== 0' failed in LEX::set_arena_for_set_stmt upon SET STATEMENT (MDEV-17711)

    • main.mysqlcheck fails on ARM with ASAN use-after-poison in my_mb_wc_filename ()

    • main.delayed fails with wrong error code or timeout when executed after main.deadlock_ftwrl ()

    • Assertion failed: !pfs->m_idle || (state == PSI_SOCKET_STATE_ACTIVE) ()

    • MyISAM wrong server status flags ()

    • Server crashes in check_sequence_fields upon CREATE TABLE .. SEQUENCE=1 AS SELECT .. ()

    • slow log Rows_examined out of range ()

    • "rpm --setugids" breaks PAM authentication ()

    • incorrect examined rows in case of stored function usage ()

    • Compilation failing on MacOS (unknown warning option -Wno-unused-but-set-variable) ()

    • Server crash upon inserting into Mroonga table with compressed column ()

    • hash unique corrupts index on virtual blobs ()

    • insert into an empty table fails with hash unique ()

    • Valgrind/MSAN warnings in dynamic_column_update_move_left ()

    • Memory leak showed in test suite ()

    • Test from subselect.test fails with statement memory protection ()

    • Memory leak when executing PS for query with IN subquery ()

    • Allow the setting of Auto_increment on FK referenced columns ()

    • mariadb-upgrade fails with sql_safe_updates = on ()

    • Assertion `!(thd->server_status & (1U | 8192U))' failed in MDL_context::release_transactional_locks ()

    • Information schema leaks table names and structure to unauthorized users ()

    • Missing CHACHA20-POLY1305 support in WolfSSL ()

    • incorrect error about cyclic reference about JSON type virtual column ()

    • Disable TLS v1.0 and 1.1 for MariaDB ()

    • Better indication of refusing to start because of ProtectHome ()

    • Database upgrade fails: slow_log table ()

    • myrocks_hotbackup.1 and test suite files installed when engine is disabled ()

    • client_ed25519.dll isn't inluded for HeidiSQL. ()

    • Assertion `!m_null_value' failed in int FixedBinTypeBundle::cmp_item_fbt::compare or in cmp_item_inet6::compare ()

    • type_test.type_test_double fails with 'NUMERIC_SCALE NULL' ()

    • LeakSanitizer errors in get_quick_select or Assertion `status_var.local_memory_used == 0 || !debug_assert_on_not_freed_memory' failed ()

    • Update signal hander user info more compassion and correct url ()

    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 mariadb-backup -

    • Refactor docker_mariadb_init in the entrypoint for extending the MariaDB image

    • CIS failure due to world-writable directory /var/run/mysqld, added sticky bit - reported by @ollie1

    • Add for root@MARIADB_ROOT_HOST - reported by Matthieu Gusmini

    • added --galera_online test, to match what the does.

    Security

    • Fixes for the following :

      • CVE-2023-22084

    Changelog

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

    Contributors

    For a full list of contributors to MariaDB 10.5.23, see the MariaDB Foundation release announcement.

    Download
    Release Notes
    Changelog
    Overview of 10.5
    MariaDB 10.5
    maintained until
    MariaDB 10.4
    MariaDB 10.5.23
    Stable (GA)

    The most recent release of MariaDB 10.5 is:

    MariaDB 10.5.29 Stable (GA) Download Now

    Alternate download from mariadb.org

    Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    MDEV-30024
    MDEV-30658
    MDEV-31813
    MDEV-32017
    MDEV-32337
    MDEV-20583
    MDEV-30825
    MDEV-32128
    MDEV-32228
    MDEV-32511
    MDEV-31851
    MDEV-32049
    MDEV-32552
    MDEV-30165
    MDEV-32064
    MDEV-32225
    MDEV-32351
    MDEV-32475
    MDEV-31177
    MDEV-32265
    MDEV-32365
    MDEV-31655
    MDEV-32024
    MDEV-32282
    MDEV-32051
    MDEV-31470
    MDEV-32642
    MDEV-31833
    MDEV-27004
    MDEV-21194
    MDEV-32387
    MDEV-16641
    MDEV-31460
    MDEV-32226
    MDEV-32244
    MDEV-29502
    MDEV-26494
    MDEV-27523
    MDEV-28561
    MDEV-28820
    MDEV-29771
    MDEV-30820
    MDEV-30904
    MDEV-31742
    MDEV-31890
    MDEV-31966
    MDEV-32012
    MDEV-32015
    MDEV-32140
    MDEV-6146
    MDEV-32223
    MDEV-32245
    MDEV-32369
    MDEV-32018
    MDEV-29914
    MDEV-32541
    MDEV-32500
    MDEV-31653
    MDEV-32586
    MDEV-31369
    MDEV-25177
    MDEV-27757
    MDEV-29993
    MDEV-31315
    MDEV-27207
    MDEV-22243
    MDEV-32476
    MDEV-32535
    mariadb-operator
    subscribing
    wsrep_sst_method
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    error messages
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    security vulnerabilities
    InnoDB
    Memory
    Replication
    mariadb-binlog
    mariadb-binlog
    Character Sets
    Audit Plugin
    ed25519 authentication plugin
    CREATE TRIGGER table1_after_insert AFTER INSERT
    security vulnerabilities
    security vulnerabilities
    security vulnerabilities
    redo log
    InnoDB buffer pool
    innodb_buffer_pool_instances
    innodb_page_cleaners
    slave_parallel_mode
    SLAVE in SQL statements
    GTID
    PCRE2
    multi_range_count
    thread_concurrency
    timed_mutexes
    innodb_buffer_page
    innodb_buffer_page_lru
    innodb_buffer_pool_stats
    innodb_cmpmem
    innodb_cmpmem_reset
    innodb_log_optimize_ddl
    S3 storage engine
    independent maturity levels
    independent maturity levels
    Spider Storage Engine
    DROP TABLE
    innodb_encryption_threads
    max_sort_length
    data types
    DOUBLE
    BIGINT
    DROP TABLE
    mariadb-dump
    sandbox
    ALTER TABLE…DISCARD TABLESPACE
    Federated
    Spider
    TIMESTAMPDIFF
    CASE
    innodb_encrypt_tables
    Character Sets
    Data Types
    ORDER BY
    GROUP_CONCAT
    AVG
    YEAR
    datetime
    JSON_ARRAYAGG
    JSON_TYPE
    JSON_REMOVE
    JSON_EXTRACT
    audit plugin
    AUTO_INCREMENT
    UPDATE
    UPDATE
    mariadb --sandbox
    mariadb-dump
    mariadb-dump
    security vulnerabilities
    Spider variables
    innodb_log_file_size
    GREATEST()
    LEAST()
    NULLs
    TIMESTAMP
    strict mode
    time zones
    alter_algorithm
    Aria
    Replication
    DELETE
    HEAP
    XA transactions
    replicate_do_db
    CHANGE MASTER TO
    server_uid
    error log
    IMPORT TABLESPACE
    mariadb-secure-installation
    security vulnerabilities
    mariadb-install-db
    Triggers
    sandbox mode
    --binary-mode
    HeidiSQL
    security vulnerabilities
    BACKUP LOCKS
    database LOCK TABLES
    spider_table_crd_thread_count
    spider_table_sts_thread_count
    ST_DISTANCE_SPHERE
    innodb_checksum_algorithm
    security vulnerabilities
    CONNECT
    CONNECT
    server_audit_events
    MariaDB Audit Plugin - Log Settings
    security vulnerabilities
    EXPLAIN EXTENDED
    security vulnerabilities
    OPTIMIZE TABLE
    OPTIMIZE
    REPAIR
    ANALYZE
    security vulnerabilities
    CHECK TABLE
    mysqlbinlog
    mariadb-upgrade
    innodb_change_buffering=none
    security vulnerabilities
    INET6
    INSERT ... RETURNING
    REPLACE ... RETURNING
    EXCEPT ALL
    INTERSECT ALL
    CREATE DATABASE
    ALTER DATABASE
    JSON_ARRAYAGG
    JSON_OBJECTAGG
    ANALYZE FORMAT=JSON
    S3 Storage Engine
    THREADPOOL_GROUPS
    THREADPOOL_QUEUES
    THREADPOOL_STATS
    innodb_adaptive_hash_index
    innodb_checksum_algorithm
    innodb_checksums
    binlog
    ANALYZE for statements
    Inferred IS NOT NULL predicates can be used by the range optimizer
    Information Schema SYSTEM_VARIABLES Table
    Aria
    MyISAM
    default partitions for system versioning
    REFERENCES constraint
    innodb_log_checksums
    innodb_locks_unsafe_for_binlog
    innodb_stats_sample_pages
    innodb_undo_logs
    innodb_rollback_segments
    innodb_log_files_in_group=1
    SHOW STATUS
    INFORMATION_SCHEMA.INNODB_
    RELEASE_ALL_LOCKS
    ALTER TABLE ... RENAME INDEX / KEY
    ALTER TABLE ... RENAME COLUMN
    CTE
    privilege
    BINLOG ADMIN
    BINLOG REPLAY
    CONNECTION ADMIN
    innodb_scrub_log
    innodb_scrub_log_speed
    INFORMATION_SCHEMA.INNODB_TABLESPACES_SCRUBBING
    innodb-background-scrub-data-uncompressed
    innodb-background-scrub-data-compressed
    innodb-background-scrub-data-interval
    innodb-background-scrub-data-check-interval
    slave_run_triggers_for_rbr
    ANALYZE FORMAT=JSON
    HeidiSQL
    require_secure_transport
    sql_if_exists
    XA PREPARE
    ALTER TABLE
    RENAME TABLE
    FEDERATED ADMIN
    READ_ONLY ADMIN
    REPLICATION MASTER ADMIN
    REPLICATION SLAVE ADMIN
    SET USER
    REPLICATION CLIENT
    BINLOG MONITOR
    SHOW MASTER STATUS
    SHOW BINLOG STATUS
    SHOW BINLOG EVENTS
    BINLOG MONITOR
    REPLICATION SLAVE
    SHOW SLAVE HOSTS
    REPLICATION MASTER ADMIN
    REPLICATION SLAVE
    mysql.global_priv.priv
    SHOW PRIVILEGES
    innodb_log_files_in_group
    SHOW SLAVE STATUS
    REPLICATION SLAVE ADMIN
    SUPER
    REPLICATION CLIENT
    SUPER
    SHOW RELAYLOG EVENTS
    REPLICATION SLAVE ADMIN
    REPLICATION SLAVE
    S3 engine
    mariadbd --temp-pool
    S3 engine
    s3_use_http
    s3_port
    BLACKHOLE Storage Engine
    Calculating (auto rounding)
    Geometry types
    mysqlbinlog
    SHOW BINLOG EVENTS
    replicate_do_table
    mysqlbinlog
    SET GLOBAL replicate_do_db = DEFAULT
    User killed queries
    server_audit plugin
    InnoDB
    ALTER TABLE
    security vulnerabilities
    WITHOUT OVERLAPS
    innodb_instant_alter_column_allowed
    S3 tables
    ALTER USER
    mysql.global_priv
    mysql_upgrade
    global_priv table
    aria_pack
    mysql_upgrade
    ALTER TABLE
    mysqldump
    mysql-test-run
    explicit_defaults_for_timestamp
    CONNECT Engine
    INSERT IGNORE
    mariadb client
    explicit_defaults_for_timestamp
    HELP
    JSON_EXTRACT
    security vulnerabilities
    security vulnerabilities
    GPG
    Full-text index
    system versioning
    innodb_undo_log_truncate=ON
    InnoDB buffer pool
    Seconds_Behind_Master
    JSON_PRETTY
    JSON_DETAILED
    security vulnerabilities
    --skip-symbolic-links
    CHAR
    collations
    mariadb_repo_setup
    security vulnerabilities
    mariadb-backup --compress
    JSON_VALUE()
    REVOKE PRIVILEGES
    SET DEFAULT ROLE
    XA transaction
    GPG key
    security vulnerabilities
    CREATE TRIGGER
    InnoDB
    Spider
    spider UDF
    aria_encrypt_tables
    mariadbd
    security vulnerabilities
    --quick-max-column-width
    innodb_thread_concurrency
    innodb_commit_concurrency
    innodb_replication_delay
    innodb_concurrency_tickets
    FLUSH TABLES…FOR EXPORT
    optimizer_use_condition_selectivity >2
    div_precision_increment
    div_precision_increment
    mariadb_schema
    innodb_thread_sleep_delay
    innodb_adaptive_max_sleep_delay
    innodb_log_optimize_ddl=OFF
    EXPLAIN FORMAT=JSON
    WITH RECURSIVE
    INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION
    security vulnerabilities
    innodb_disallow_writes
    mariadb-backup
    mariadb-backup
    mariadb-backup
    now available in Chinese
    security vulnerabilities
    Replication unsafe
    INSERT .. ON DUPLICATE KEY UPDATE
    MIXED format binlogging
    Replication unsafe
    INSERT .. ON DUPLICATE KEY UPDATE
    MIXED binlog format
    mysqlbinlog --stop-never --raw
    InnoDB persistent stats
    mysql_upgrade
    innodb_flush_sync=OFF
    innodb_max_dirty_pages_pct_lwm=0
    mysqlbinlog
    S3
    REPLICA MONITOR
    mysqldump --system
    security vulnerabilities
    mariadb-dump --force
    DELETEs
    unique key
    Spider variables
    RANK
    window functions
    ALTER SEQUENCE
    STOP SLAVE
    XA COMMIT/XA ROLLBACK
    security vulnerabilities
    DISTINCT
    LIMIT
    ROW
    innodb_undo_log_truncate=ON
    innodb_undo_log_truncate=ON
    innodb_undo_log_truncate=ON
    innodb_read_ahead_threshold
    innodb_undo_log_truncate=ON
    SHOW TABLES
    ROLLBACK
    ROW_FORMAT=COMPRESSED
    Split Materialized
    security vulnerabilities
    Innodb_data_written
    Rowid Filter optimization
    Upgrading Between Major MariaDB Versions
    Upgrading from MariaDB 10.4 to MariaDB 10.5
    independent maturity levels
    INET6
    S3 storage engine
    partitioned
    privilege
    BINLOG ADMIN
    BINLOG REPLAY
    CONNECTION ADMIN
    SHOW STATUS
    INFORMATION_SCHEMA.INNODB_
    innodb_adaptive_hash_index
    innodb_checksum_algorithm
    innodb_buffer_pool_instances
    innodb_checksums
    innodb_locks_unsafe_for_binlog
    innodb_log_checksums
    GTID
    slave_parallel_mode
    SLAVE in SQL statements
    slave_run_triggers_for_rbr
    INSERT ... RETURNING
    DELETE ... RETURNING
    REPLACE ... RETURNING
    EXCEPT ALL
    INTERSECT ALL
    WITHOUT OVERLAPS
    JSON_ARRAYAGG
    JSON_OBJECTAGG
    THREAD_POOL_GROUPS
    THREAD_POOL_QUEUES
    THREAD_POOL_STATS
    THREAD_POOL_WAITS
    ANALYZE for statements
    Inferred IS NOT NULL predicates can be used by the range optimizer
    Information Schema SYSTEM_VARIABLES Table
    Aria
    MyISAM
    DROP TABLE
    PCRE2
    System Variables Added in MariaDB 10.5
    Status Variables Added in MariaDB 10.5
    Information Schema SYSTEM_VARIABLES Table
    show_old_temporals
    Security Vulnerabilities Fixed in MariaDB
    FEDERATED ADMIN
    READ_ONLY ADMIN
    REPLICATION MASTER ADMIN
    REPLICATION SLAVE ADMIN
    SET USER
    REPLICATION CLIENT
    BINLOG MONITOR
    SHOW MASTER STATUS
    SHOW BINLOG STATUS
    SHOW BINLOG EVENTS
    BINLOG MONITOR
    REPLICATION SLAVE
    SHOW SLAVE HOSTS
    REPLICATION MASTER ADMIN
    REPLICATION SLAVE
    mysql.global_priv.priv
    SHOW PRIVILEGES
    redo log
    InnoDB buffer pool
    innodb_buffer_page
    innodb_buffer_page_lru
    innodb_buffer_pool_stats
    innodb_cmpmem
    innodb_cmpmem_reset
    innodb_log_files_in_group
    innodb_log_optimize_ddl
    innodb_rollback_segments
    innodb_scrub_log
    innodb_scrub_log_speed
    INFORMATION_SCHEMA.INNODB_TABLESPACES_SCRUBBING
    innodb-background-scrub-data-uncompressed
    innodb-background-scrub-data-compressed
    innodb-background-scrub-data-interval
    innodb-background-scrub-data-check-interval
    innodb_stats_sample_pages
    innodb_undo_logs
    innodb_thread_concurrency
    innodb_commit_concurrency
    innodb_replication_delay
    innodb_concurrency_tickets
    innodb_thread_sleep_delay
    innodb_adaptive_max_sleep_delay
    binlog
    mariadb-binlog
    SHOW BINLOG EVENTS
    SHOW RELAYLOG EVENTS
    default partitions for system versioning
    CREATE DATABASE
    ALTER DATABASE
    ALTER TABLE ... RENAME INDEX / KEY
    ALTER TABLE ... RENAME COLUMN
    ALTER TABLE
    RENAME TABLE
    VISIBLE attribute for indexes
    CTE
    RELEASE_ALL_LOCKS
    GET_LOCK()
    REFERENCES constraint
    VARCHAR
    CHAR
    BLOBs
    multi_range_count
    thread_concurrency
    timed_mutexes
    SHOW SLAVE STATUS
    REPLICATION SLAVE ADMIN
    SUPER
    REPLICATION CLIENT
    SUPER
    SHOW RELAYLOG EVENTS
    REPLICATION SLAVE ADMIN
    REPLICATION SLAVE
    binlog_row_metadata
    DROP INDEX
    CREATE INDEX
    mariadb-binlog -T/--table
    mariadb-admin
    simple_password_check
    mariadb-install-db
    binlog_do_db
    healthcheck.sh
    sql_mode=ANSI_QUOTES
    healthcheck.sh
    instructions
    security vulnerabilities
    mariadb-install-db
    proxy privileges
    PROXY privileges
    healthcheck.sh

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL