MariaDB 11.5 Changes & Improvements

MariaDB 11.5 is an old rolling release and is no longer maintained. Please use a more recent release.

Upgrading

• See and .

New Features

Temporary files and tables

• ()

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

  • : Limits the temporary space allowance per user

  • : Limits the temporary space allowance for all users.

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 ().

Optimizer

• is now supported for partitioned tables ()

• ANALYZE for statement should show selectivity of pushed index condition ()

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

Other

• ()

• Deprecate and ignore the system variable ()

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

• Parallel dump of multiple databases via with the --dir

Removed Features

The following deprecated features have been removed:

• ... COMPRESSED...

  • the correct syntax is COMPRESSED... ...

• (and the related variable).

Variables

• For a list of all new variables, see and .

Security Vulnerabilities Fixed in

For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the page. Add listcve macro here - removed for performance reasons

List of All Releases