MariaDB 10.8.0 Release Notes

Download 10.8.0 Release Notes Changelog Overview of 10.8

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

Stored procedures INOUT parameters

• add support IN, OUT, INOUT parameter qualifiers for stored functions (MDEV-10654). This was a contribution by ManoharKB.

Lag free ALTER TABLE in replication

• Normally, ALTER TABLE gets fully executed on the master 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 master, not when it finishes. This way the replication lag caused by a heavy ALTER 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 the LIMIT or INTERVAL clause, that is, when the server automatically switches to the new history partition when the previous one becomes full, one can now use an AUTO keyword to tell the server to create more history partitions automatically as needed. (MDEV-17554)

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 an internal refactoring work. As a result one can now declare spider connections using REMOTE_SERVER, REMOTE_DATABASE, and REMOTE_TABLE attributes and not abuse the COMMENT field for that. This works both for the whole table and per partition (MDEV-5271, MDEV-27106)

Misc features

• CRC32C() function, second argument for the CRC() function. (MDEV-27208)
• @@keep_files_on_create variable is deprecated and will be removed in the future (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

• numerous improvements to using non-latin1 codepage and non-latin1 characters with the mariadb client on Windows