Changes and Improvements in MariaDB 10.5

MariaDB 10.5 will be the next major development version. There are currently no releases. MariaDB 10.4 is currently stable and feature-complete, so new features will be going into 10.5.

• Plans for MariaDB 10.5
• 10.5 Features/fixes by vote

Implemented Features

Syntax

• INSERT ... RETURNING (MDEV-10014)
• REPLACE ... RETURNING (MDEV-10014)

Storage Engines

• The S3 storage engine allows one to archive MariaDB tables in Amazon S3, or any third-party public or private cloud that implements S3 API.
• The Aria max key length is now 2000 bytes, compared to 1000 bytes in MyISAM.

Thread Pool

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

InnoDB

• innodb_adaptive_hash_index now defaults to OFF (MDEV-20487).
• innodb_checksum_algorithm now defaults to full_crc32 (MDEV-19534).
• innodb_checksums has been removed (MDEV-19534).
• innodb_log_checksums has been deprecated (MDEV-19543).
• innodb_locks_unsafe_for_binlog has been removed (MDEV-19544).
• innodb_stats_sample_pages has been removed (MDEV-19551).
• innodb_undo_logs has been deprecated (MDEV-19570).
• innodb_rollback_segments has been removed (MDEV-19570).

Binary Log

• Extended binlog metadata (MDEV-20477)

General

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

Variables

• For a list of all new variables, see System Variables Added in MariaDB 10.5 and Status Variables Added in MariaDB 10.5.
• The Information Schema SYSTEM_VARIABLES Table has a new column showing from which config file a variable derives its value (MDEV-12684).