Changes and Improvements in MariaDB 11.6

MariaDB 11.6 is a rolling release.

Notable Items

Vectors

• Vectors are a feature that allow MariaDB Server to perform as a relational vector database. In MariaDB 10.6, only available in the Vector preview release.
• Vector Search was added to MariaDB 11.7.

Character Sets

• The default character set has been changed from latin1 to utf8mb4 (MDEV-19123)

Backup and Restore

• Added the --dir option to mariadb-import, allowing one to restore all tables from a backup directory created using mariadb-dump --dir (MDEV-33627)
  • Added the related --database, --ignore-database, --table and --ignore-table options.
  • Refactor mariadb-import threading
• Automatic SST user account management (MDEV-31809)

Optimizer

• Improve selectivity computations for multi-part keys (MDEV-33697)

Syntax

• Single-table DELETEs now support table aliases (MDEV-33988)

Authentication

• New authentication plugin (MDEV-32618)
• Extend Unix socket authentication to support authentication_string (MDEV-33479)

Replication

• New definition for Seconds_Behind_Master (MDEV-33856)
  • Added three variables to SHOW ALL REPLICAS STATUS
  • New Information Schema SLAVE_STATUS Table

General

• Set thread names for MariaDB Server threads (MDEV-32537)

List of All MariaDB 11.6 Releases