arrow-left

All pages
gitbookPowered by GitBook
1 of 1

Loading...

MariaDB 11.5.0 Release Notes

circle-info

The most recent release of MariaDB 11.5 is:

hashtag
MariaDB 11.5.2 Stable (GA) Download Now

Release date: 18 March 2024

triangle-exclamation

Do not use non-stable (non-GA) releases in production!

is an upcoming development series of MariaDB. It is an evolution of with several entirely new features.

is a single preview release. Features are to be considered preview, and none are guaranteed to make it into .

The preview is available as a container quay.io/mariadb-foundation/mariadb-devel:11.5-preview.

Thanks, and enjoy MariaDB!

hashtag
New Features

hashtag
Temporary files and tables

  • ()

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

    • : Limits the temporary space allowance per user

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

hashtag
Optimizer

  • is now supported for partitioned tables ()

  • ANALYZE FORMAT=JSON now ()

hashtag
Protocol

  • Permit bulk implementation to return ALL individual results ()

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

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

hashtag

  • Additional features for Sequences ()

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

hashtag
Other

  • ()

  • Deprecate and ignore the system variable ()

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

circle-info

Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

This page is licensed: CC BY-SA / Gnu FDL

: Limits the temporary space allowance for all users.

Add ()

  • Provide statistics ()

    • Including a number of .

  • Show variable deprecation for output ()

  • Extend to be compatible with Percona server ()

  • New variable, for additional control over what is logged to the . This setting did not make it into , but was added in ()

  • Parser accepts larger and smaller values for and

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

  • Download
    Release Notes
    Overview of 11.5
    MariaDB 11.5
    MariaDB 11.4
    MariaDB 11.5.0
    MariaDB 11.5
    MDEV-9101arrow-up-right
    MDEV-32188arrow-up-right
    MDEV-12404arrow-up-right
    MDEV-18478arrow-up-right
    MDEV-30366arrow-up-right
    MDEV-31609arrow-up-right
    MDEV-23729arrow-up-right
    MDEV-32218arrow-up-right
    MDEV-33151arrow-up-right
    MDEV-33152arrow-up-right
    MDEV-28152arrow-up-right
    MDEV-33449arrow-up-right
    MDEV-33655arrow-up-right
    MDEV-25829arrow-up-right
    subscribingarrow-up-right
    MDEV-33145arrow-up-right
    MDEV-32841arrow-up-right
    MDEV-28671arrow-up-right
    MDEV-33501arrow-up-right
    MariaDB 11.5
    MariaDB 11.7
    MDEV-33144arrow-up-right
    MDEV-33625arrow-up-right
    MDEV-31789arrow-up-right
    spinner
    Distributions which Include MariaDB
    Limit size of created disk temporary files and tables
    max_tmp_space_usage
    TIMESTAMP
    Index condition pushdown
    shows selectivity of pushed index condition
    USERS table
    password expiry
    max_password_errors
    TABLE_STATISTICS
    CLIENT_STATISTICS
    USER STATISTICS
    INDEX_STATISTICS
    Sequences
    CREATE SEQUENCE ... AS
    INT
    BIGINT UNSIGNED
    Information Schema Sequences table
    REPAIR TABLE ... FORCE
    alter_algorithm
    default Unicode collation
    max_total_tmp_space_usage
    FLUSH GLOBAL STATUS
    InnoDB async IO
    status variables
    mariadbd --help
    Query Response Time plugin
    log_slow_always_query_time
    slow query log
    MINVALUE
    MAXVALUE
    mariadb-dump
    spider_casual_read