MariaDB 10.5.3 Release Notes

The most recent release of MariaDB 10.5 is:MariaDB 10.5.28 Stable (GA) Download NowAlternate download from mariadb.org

DownloadRelease NotesChangelogOverview 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!

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

Thanks, and enjoy MariaDB!

Notable Changes

This is the second beta release in the MariaDB 10.5 series.

Notable changes of this release include:

Syntax

• Application period tables: WITHOUT OVERLAPS (MDEV-16978)

• Introduce a file format constraint to ALTER TABLE. See innodb_instant_alter_column_allowed (MDEV-20590)

Large Pages

• Modernise Linux Large Page support (multiplesizes) (MDEV-18851)

Storage Engines

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

Performance

• Optimizer flag rowid_filter leads to long query (MDEV-21794)

• WSREP_ON is unnecessarily expensive to evaluate (MDEV-22203

• Misc wsrep performance optimization (MDEV-7962)

Security

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

• WolfSSL updated

• ALTER USER doesn't remove excess authentication plugins from mysql.global_priv (MDEV-21928)

• mysql_upgrade creating empty global_priv table (MDEV-21244)

Aria

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

ALTER TABLE

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

• Assertion failure in file data0type.cc (MDEV-20726)

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

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

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

Optimizer

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

• SHOW GRANTS does not quote role names properly (MDEV-20076)

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

mariadb-backup

• mariadb-backup does not honor ignore_db_dirs from server config (MDEV-19347)

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

Crash Recovery

• Loop of Read redo log up to LSN (MDEV-21826)

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

• Running out of file descriptors and eventual crash (MDEV-18027)

• Efficient InnoDB redo log record format (MDEV-12353)

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

Other

• Use MariaDB in error messages instead of MySQL (MDEV-17812)

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

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

• Duplicate key value is silently truncated to 64 characters in print_keydup_error (MDEV-20604)

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

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

• InnoDB ALTER TABLE 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)

• mysqldump 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 mysql-test-run (MDEV-22176)

• Packages and repositories for Ubuntu 20.04 "focal" added

Changelog

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

Contributors

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

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

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 theDistributions which Include MariaDB page.