MariaDB 11.8 Changes & Improvements

MariaDB 11.8 is a long-term release, maintained until June 2028.

This list includes all features since the previous long-term release, MariaDB 11.4 (those introduced in the MariaDB 11.5, MariaDB 11.6 and MariaDB 11.7 rolling releases, and in MariaDB 11.8).

Upgrading

• Note that if you are using system versioned tables, all rows and indexes has to be updated in these to use the extended timestamp range ('2106-02-07 06:28:15 UTC'). Upgrading to 11.8 can take a long time if you have many rows in your system versioned tables!

• If you are not using system versioned tables and you are upgrading from 10.0 and up, the upgrade should just take a few seconds.

• See Also: and .

Downgrading

• If you have system versioned tables, downgrading is not trivial. In other cases see .

New Features

Vectors

• Functions and

• Functions , , for calculating either a Euclidean or Cosine distance between two vectors. The last one automatically uses Euclidean or Cosine, depending on the underlying index type ()

• Vector indexes can use x86_64 (AVX2 and AVX512), aarch64 neon () and Powerpc64 AltiVec (

Character Sets

• The default has been changed from latin1 to utf8mb4 (, )

• Change to uca1400_ai_ci, a modern Unicode collation with proper support for SMP characters (including emoji)(, )

Optimizer

• Optimization improvement for single-table UPDATE/DELETE: make cost-based choice between subquery strategies ()

• The is now on by default ()

• Optimizer can now take advantage of queries of the format ()

• Add basic optimizer support for - see ()

System-Versioned Tables

• Allow a to be converted from implicit to explicit row_start/row_end columns ()

Temporary files and tables

• (, )

  • There are two system variables used for controlling this feature ():

    • : Limits the temporary space allowance per user

Data Types

• The range of values was extended. The maximal allowed value for timestamps was '2038-01-19 03:14:07 UTC', and is now '2106-02-07 06:28:15 UTC'. This does not change the storage format, and new tables can be read by old MariaDB servers as long as timestamp values are within the old timestamp range. At the moment this is only supported on 64-bit platforms (, ). Note that if you are using system versioned tables, all rows have to be updated in these to use the new end range. This can take a long time if you have many rows in your system versioned tables!

Authentication

• (, )

• Extend to support authentication_string (, )

InnoDB

• Fix scalability with multiple threads ()

Backup and Restore

• Parallel dump of multiple databases via with the --dir option (, )

• Parallel import of multiple databases via with the --dir option (, )

  • Added the related --database, --ignore-database

Replication

• When is enabled, committing a large transaction no longer freezes all other transactions until completed (, )

• has been deprecated (, )

• Async rollback prepared transactions during binlog crash recovery (, )

• New variable, , for aborting long-running queries on a replica (

Galera

• Automatic SST user account management (, )

UUID

• New function for generating version 4 UUIDs (, )

• New function for generating version 7 UUIDs (, )

Other Functions

• New function. Given a byte count, returns a string consisting of a value and the units in a human-readable format ()

Protocol

• Permit bulk implementation to return ALL individual results (, )

• Send initial values of system variables in first OK packet (, )

Observability

• New in the Information Schema for storing information about users, , and the limits set by (, , )

• Add more columns to Information Schema , and tables (, )

• Add QUERIES column to Information Schema table (, )

• Additional features for Sequences (, )

  • permits creating as any type (including ), extending the range

  • Parser accepts larger and smaller values for and

System-Versioned Tables

• Allow a to be converted from implicit to explicit row_start/row_end columns (, )

Stored Routines

• ROW data type for stored function return values (, )

• Stored routines parameters can have default values ()

• Update triggers can optionally have a list of columns an update of which executes the trigger. Updating other columns does not execute the trigger ()

Derived Tables

• Add optional correlation column list for (, )

[SHOW] CREATE SERVER

• Implement (, )

• Allow arbitrary options in (, )

Slow Query Log

• New variable, , for specifying that all queries longer than this time are logged to the , regardless of and (, )

Information Schema

• When querying the , that have the same name as a native function no longer generate a warning ()

Spider

• The Spider variables and have been deprecated (, )

• Deprecate (, )

General

• , which used to be an alias for now shows the value of when the session was created (, )

• CURRENT_TIMESTAMP should return a TIMESTAMP (WITH TIME ZONE?) (, )

• A warning has been added when is exceeded. (, )

• Single-table

Variables

• Deprecate and ignore the system variable (, )

• For a list of all new variables, see

Removed Features

The following deprecated features have been removed:

• <data type> <character set clause> ... COMPRESSED... ()

  • the correct syntax is <data type> COMPRESSED... <character set clause> ...

• ()

List of All Releases