What’s new and changed with MariaDB 10.8?

What's new and changed with MariaDB 10.8?

---

Added support for IN,OUT and INOUT qualifying parameters for stored functions in MariaDB 10.8, MariaDB already supports IN, OUT and INOUT parameters. This contribution was made by ManoharKB The lag-free ALTER TABLE MariaDB Replication: In MariaDB 10.8, ALTER TABLE gets replicated and starts executing on replicas when it starts executing on the primary, not when it finishes. So the replication lag caused by a heavy ALTER TABLE can be completely eliminated (MDEV-11675). MariaDB 10.8 support Descending Indexes: You can now explicitly sort individual columns in ascending or descending order improving performance on selected ORDER BY cases (MDEV-13756, MDEV-26938, MDEV-26939, MDEV-26996)

InnoDB redo log improvements:

• innodb_buffer_pool_chunk_size (MDEV-25342) autosize
• More optimal and efficient redo log (MDEV-14425) concurrency

JSON storage for Histograms in the statistics table  Histograms in the statistics table are stored as JSON and not binary (MDEV-21130, MDEV-26519, blog post). Improvements on Spider Storage Engine  You can now declare Spider connections with REMOTE_SERVER, REMOTE_DATABASE, and REMOTE_TABLE attributes and not abuse the COMMENT field for that. This feature works for both the whole table and per partition (MDEV-5271, MDEV-27106). MariaDB 10.8 mariadb-binlog with GTID support  MariaDB 10.8 binary logs/mysqlbinlog (mariadb-binlog) GTID support 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). MariaDB 10.8 new system variables  For a detailed list of all new MariaDB 10.8 variables, Please check  System Variables Added in MariaDB 10.8 and Status Variables Added in MariaDB 10.8.