MariaDB 10.8.0 Release Notes
The most recent release of MariaDB 10.8 is:
MariaDB 10.8.8 Stable (GA) Download Now
Download 10.8.0 Release Notes Changelog Overview of 10.8
Release date: 21 Dec 2021
Do not use alpha releases in production!
MariaDB 10.8 is the current development series of MariaDB. It is an evolution of MariaDB 10.7 with several entirely new features.
MariaDB 10.8.0 is not a single release, but is instead a number of feature preview releases based on feature branches. Each should be considered as having a maturity of an Alpha release. Read more about feature preview releases here.
Thanks, and enjoy MariaDB!
List of packages
Remember, these features are in separate preview packages. The subsection header text corresponds to the preview package name.
Stored Procedures INOUT Parameters
- Stored procedures already have support for the IN, OUT and INOUT parameter qualifiers. Added as well for stored functions and (IN only) cursors (MDEV-10654). This was a contribution by ManoharKB.
Lag free ALTER TABLE in replication
- Normally, ALTER TABLE gets fully executed on the primary first and only then it is replicated and starts executing on replicas. With this feature
ALTER TABLE
gets replicated and starts executing on replicas when it starts executing on the primary, not when it finishes. This way the replication lag caused by a heavyALTER TABLE
can be completely eliminated (MDEV-11675).
Descending indexes
- Individual columns in the index can now be explicitly sorted in the ascending or descending order. This can be useful for optimizing certain ORDER BY cases (MDEV-13756, MDEV-26938, MDEV-26939, MDEV-26996).
InnoDB redo log improvements
- autosize innodb_buffer_pool_chunk_size (MDEV-25342).
- Improve the redo log for concurrency (MDEV-14425).
Auto create partition
- For system versioned tables that are partitioned
BY SYSTEM_TIME
with theLIMIT
orINTERVAL
clause, that is, when the server automatically switches to the new history partition when the previous one becomes full, one can now use anAUTO
keyword to tell the server to create more history partitions automatically as needed (MDEV-17554). - Note that this feature was not included in MariaDB 10.8.1.
JSON Histograms
- Histograms in the statistics tables are more precise and stored as JSON, not binary (MDEV-21130, MDEV-26519, blog post).
Spider Storage Engine Improvements
- This was mostly internal refactoring work. As a result one can now declare Spider connections using the
REMOTE_SERVER
,REMOTE_DATABASE
, andREMOTE_TABLE
attributes and not abuse theCOMMENT
field for that. This works both for the whole table and per partition (MDEV-5271, MDEV-27106).
Misc. features
- Add an optional argument to the CRC32() function, as well as the CRC32C() function, which uses the Castagnoli polynomial. (MDEV-27208). Note: The order of the 2-ary arguments was swapped after the preview release:
crc32('MariaDB')=crc32(crc32('Maria'),'DB')
- Deprecate the keep_files_on_create variable (MDEV-23570).
- my_print_defaults now handles
--default-*
options in exactly the same way as other MariaDB tools (MDEV-26238). - UCA collations are now notably faster (MDEV-27266, MDEV-27265).
mysqlbinlog GTID support
- mariadb-binlog (or
mysqlbinlog
as it was called back when the task was created) now supports both filtering events by GTID ranges through--start-position
and--stop-position,
and validating a binary log's ordering of GTIDs through--gtid-strict-mode
(MDEV-4989).
Windows - Improved i18n support
- On newer versions of Windows (Windows 10 1903 or later), the
mariadb
client defaults to the utf8mb4 character set. Several problems with Unicode input and output in client were fixed. Command line utilities now accept all Unicode characters in user names, database names, file names etc (in the past, characters were restricted to the current ANSI codepage).
Do not use alpha 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 the
Distributions which Include MariaDB
page.