MariaDB 11.0.2 Release Notes

The most recent release of MariaDB 11.0 is:MariaDB 11.0.6 Stable (GA) Download Now

Download 11.0.2Release NotesChangelogOverview of 11.0

Release date: 6 Jun 2023

MariaDB 11.0 is a current short-term stable series of MariaDB and will be maintained until June 2024. It is an evolution of MariaDB 10.11 with several entirely new features.

MariaDB 11.0.2 is a Stable (GA) release.

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

Thanks, and enjoy MariaDB!

Notable Items

Functions

• Given a time in picoseconds, the new function FORMAT_PICO_TIME returns a human-readable time value and unit indicator (MDEV-19629)

InnoDB

• InnoDB does not free UNDO after the fix of MDEV-30671 (MDEV-31234)

• InnoDB hang fixes (MDEV-31158, MDEV-31343, MDEV-31350)

• Innodb_buffer_pool_read_requests is not updated correctly (MDEV-31309)

• InnoDB monitor trx_rseg_history_len was accidentally disabled by default (MDEV-31308)

• Revert "MDEV-30473 : Do not allow GET_LOCK() / RELEASE_LOCK() in cluster"

Optimizer

• Split Materialized optimization is improved to re-fill the materialized table only if necessary. The fewer number of table refills is taken into account when choosing query plan, too (MDEV-26301)

• New optimizer_switch option, hash_join_cardinality, is added. It is ON by default. When set to ON, the optimizer will produce tighter bounds for hash join output cardinality. (MDEV-30812)

• Crash with condition pushable into derived and containing outer reference (MDEV-31403 MDEV-31240)

• Crash with EXPLAIN EXTENDED for multi-table update of system table (MDEV-31224)

• ANALYZE FORMAT=JSON now prints more information about Block Nested Loop joins: block-nl-join element now has r_loops, r_effective_rows and r_other_time_ms fields (MDEV-30806, MDEV-30830, MDEV-30972).

Variables

• New status variable: max_used_connections_time (MDEV-30543)

Security

• Fixes for the following security vulnerabilities:

  • CVE-`-```

Changelog

For a complete list of changes made in MariaDB 11.0.2, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 11.0.2, see the MariaDB Foundation release announcement.

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.

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