MariaDB 10.11.0 Release Notes

The most recent release of MariaDB 10.11 is:MariaDB 10.11.11 Stable (GA) Download NowAlternate download from mariadb.org

DownloadRelease NotesOverview of 10.11

Release date: 26 Sep 2022

Do not use alpha releases in production!

MariaDB 10.11 is a current development series of MariaDB. It is an evolution of MariaDB 10.10 with several entirely new features.

Unlike recent new releases, MariaDB 10.11.0 is a single preview release. Features are to be considered preview, and none are guaranteed to make it into MariaDB 10.11.

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

For an overview of MariaDB 10.11 see theWhat is MariaDB 10.11? page.

Thanks, and enjoy MariaDB!

Authentication

• Windows - passwordless login for mariadb root user, for OS admin users, using the gssapi authentication plugin (MDEV-26715)

• GRANT to PUBLIC (MDEV-5215) (blog post)

• Separate SUPER and READ ONLY ADMIN privileges (MDEV-29596)

Optimizer

• Semi-join optimization for single-table update/delete statements (MDEV-7487)

• Allow pushdown of queries involving UNIONs in outer select to foreign engines (MDEV-25080)

• Make ANALYZE FORMAT=JSON show time spent in the query optimizer (MDEV-28926)

Information Schema

• Performance Issues reading the Information Schema Parameters table (MDEV-29104)

• Full table scan in the Information Schema Parameters and Information Schema Routines tables (MDEV-20609)

System versioning

• System versioning setting, system_versioning_insert_history, to allow history modification (MDEV-16546)

• mariadb-dump: dump and restore historical data (MDEV-16029)

InnoDB

• innodb_write_io_threads and innodb_read_io_threads are now dynamic, and their values can be changed without restarting the server (MDEV-11026)

General

• Rename slow queries variables (MDEV-7567)

  • log_slow_min_examined_row_limit (min_examined_row_limit)

  • log_slow_query (slow_query_log)

  • log_slow_query_file_name (slow_query_log_file) This will be renamed to log_slow_query_file in the next MariaDB 10.11 release.

  • log_slow_query_time (long_query_time)

• replicate_rewrite_db is now a system variable, no longer just an option (MDEV-15530)

Do not use alpha releases on production systems! For a complete list of changes made in MariaDB 10.11.0, with links to detailed information on each push, see the changelog.

Be notified of new MariaDB Server releases automatically by subscribing 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 Distributions which Include MariaDB page.