The Ultimate Guide to High Availability with MariaDB

MariaDB 10.5.2 Release Notes

You are viewing an old version of this article. View the current version here.

Note: This page describes features in the source repository for MariaDB 10.5. There are currently no official packages or binaries available for download which contain the features. If you want to try out any of the new features described here you will need to get and compile the code yourself.

MariaDB 10.5 is the current development series of MariaDB. It is an evolution of MariaDB 10.4 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.5.2 is a Beta release.

Do not use beta releases in production!

For an overview of MariaDB 10.5 see the What is MariaDB 10.5? page.

Thanks, and enjoy MariaDB!

Notable Changes

Notable changes of this release include:

Syntax

Privileges

  • Split SUPER privilege to smaller privileges (MDEV-21743). New privileges were added so that more fine grained tuning of what each user can do can be applied:
    • BINLOG ADMIN
    • BINLOG REPLAY
    • CONNECTION ADMIN
    • FEDERATED ADMIN
    • READ_ONLY ADMIN
    • REPLICATION MASTER ADMIN
    • REPLICATION SLAVE ADMIN
    • SET USER
  • The REPLICATION CLIENT privilege was renamed to BINLOG MONITOR. The old syntax is understood for compatibility (MDEV-21743).
  • The SHOW MASTER STATUS statement was renamed to SHOW BINLOG STATUS (MDEV-21743). The old syntax is understood for compatibility.
  • A number of statements changed the privileges that they require. The old privileges were historically inappropriately chosen in the upstream. 10.5.2 fixes this problem. Note, these changes are incompatible to previous versions. A number of GRANT commands might be needed after upgrade.
    • SHOW BINLOG EVENTS now requires the BINLOG MONITOR privilege (requred REPLICATION SLAVE prior to 10.5.2).
    • SHOW SLAVE HOSTS now requires the REPLICATION MASTER ADMIN privilege (required REPLICATION SLAVE prior to 10.5.2).
    • SHOW SLAVE STATUS now requires the REPLICATION SLAVE ADMIN or the SUPER privilege (required REPLICATION CLIENT or SUPER prior to 10.5.2).
    • SHOW RELAYLOG EVENTS now requires the REPLICATION SLAVE ADMIN privilege (required REPLICATION SLAVE prior to 10.5.2).
  • In order to help the server understand which version a privilege record was written by, the mysql.global_priv.priv field contains a new JSON field, version_id (MDEV-21704)
  • SHOW PRIVILEGES now correctly lists the Delete history privilege, rather than displaying it as Delete versioning rows. (MDEV-20382)

InnoDB

Optimizer

  • Allow packed sort keys in sort buffer (MDEV-21580)

Performance Schema

  • Merge 5.7 P_S transaction instrumentation and tables (MDEV-16435)
  • Merge 5.7 P_S memory instrumentation and tables (MDEV-16431)
  • Merge 5.7 P_S mdl instrumentation and tables (MDEV-16432)
  • Merge 5.7 P_S sxlocks instrumentation and tables (MDEV-16436)
  • Merge 5.7 P_S user variables instrumentation and tables (MDEV-16439)
  • Merge 5.7 P_S [show] status instrumentation and tables (MDEV-16438)
  • Merge 5.7 P_S ps instrumentation and tables (MDEV-16433)
  • Merge 5.7 P_S sp instrumentation and tables (MDEV-16434)

Replication

ANALYZE FORMAT=JSON

Clients

  • All binaries previously beginning with mysql now begin with mariadb, with symlinks for the corresponding mysql command. (MDEV-21303)

Changelog

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

Do not use beta releases in production!

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.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.