Release Notes for MariaDB Community Server 10.5.2

MariaDB Community Server is the community release of MariaDB Server.

MariaDB Community Server 10.5.2 was released on 2020-03-26. It is the third community release of the MariaDB Server 10.5 series. It is a beta release.

New Features

  • Command-line binaries previously beginning with mysql now begin with mariadb, with symbolic links to the legacy mysql commands. (MDEV-21303)

  • Support for RELEASE_ALL_LOCKS() function. (MDEV-10569)

  • Support for RENAME INDEX and RENAME KEY clauses added to ALTER TABLE statements. (MDEV-7318)

  • Support for RENAME COLUMN clause added to ALTER TABLE statements. (MDEV-16290)

  • Support added for recursive CTE cycle detection using the CYCLE clause. (MDEV-20632)

  • Support added for IF EXIST keywords in ALTER TABLE and RENAME TABLE statements.

  • InnoDB optimizes append-only files for NVDIMM. (MDEV-17084)

  • Improvements to Group Commit performance for InnoDB Redo Log. (MDEV-21534)

  • Optimizer now allows packed sort keys in sort buffer. (MDEV-21580)

  • Support added for require_secure_transport system variable, for rejecting connections attempted using insecure transport. (MDEV-13362)

  • Merges Performance Schema transaction instrumentation and tables from MySQL 5.7. (MDEV-16435)

  • Merges Performance Schema memory instrumentation and tables from MySQL 5.7. (MDEV-16431)

  • Merges Performance Schema mdl instrumentation and tables from MySQL 5.7. (MDEV-16432)

  • Merges Performance Schema sxlocks instrumentation and tables from MySQL 5.7. (MDEV-16436)

  • Merges Performance Schema user variables instrumentation and tables from MySQL 5.7. (MDEV-16439)

  • Merges Performance Schema [show] status instrumentation and tables from MySQL 5.7. (MDEV-16438)

  • Merges Performance Schema ps instrumentation and tables from MySQL 5.7. (MDEV-16433)

  • Merges Performance Schema sp instrumentation and tables from MySQL 5.7. (MDEV-16434)

  • Support added for ENFORCE option with slave_run_triggers_for_rbr system variable. (MDEV-21833)

  • Information added to ANALYZE FORMAT=JSON on packed add-on fields.

  • MariaDB Cluster now uses the Galera wsrep Provider version 26.4.4.

  • Support added for sql_if_exists session system variable, which provides an implicit IF EXISTS to SQL statements altering, renaming, or dropping tables, views, functions, and packages. (MDEV-19964)

  • XA PREPARE statements can now survive client disconnections. (MDEV-742)

Changed Features

  • Upgrades to InnoDB tables only possible after clean shutdown. mariabackup --prepare does not work with backups taken before version 10.5.2.

  • SUPER privilege split into several smaller privileges, allowing for more fine grained tuning of what each user can do: BINLOG ADMIN, BINLOG REPLAY, CONNECTION ADMIN, FEDERATED ADMIN, READ_ONLY ADMIN, REPLICATION MASTER ADMIN, REPLICATION SLAVE ADMIN, and SET USER. (MDEV-21743)

  • REPLICATION CLIENT privilege renamed to the BINLOG MONITOR privilege. The old syntax still understood for compatibility. (MDEV-21743)

  • SHOW MASTER STATUS statement renamed to SHOW BINLOG STATUS. The old syntax still understood for compatibility. (MDEV-21743)

  • Several statements changed required privileges, may require a number of GRANT statements to be issued after upgrade.

    • SHOW BINLOG EVENTS now requires BINLOG MONITOR privilege, instead of REPLICATION SLAVE.

    • SHOW SLAVE HOSTS now requires REPLICATION SLAVE ADMIN or SUPER privileges, instead of REPLICATION CLIENT or SUPER.

    • SHOW SLAVE STATUS now requires REPLICATION SLAVE ADMIN or SUPER privileges, instead of REPLICATION CLIENT or SUPER.

  • SHOW RELAYLOG EVENTS now requires REPLICATION SLAVE ADMIN privilege, instead of REPLICATION SLAVE.

  • Adds version_id JSON field to mysql.global_priv system table. (MDEV-21704)

  • Improvements to efficiency in InnoDB Redo Log format. (MDEV-12353)

  • InnoDB no longer acquires record locks when covering table locks exist. (MDEV-14479)

  • Issues a message on changing deprecated innodb_log_files_in_group system variable. (MDEV-21990)

Deprecated Features

Bug Fixes

  • SHOW PRIVILEGES statement now correctly lists the Delete history privilege, rather than displaying it as Delete versioning rows. (MDEV-20382)

  • Fixes writing of freed InnoDB pages. (MDEV-15528)

  • Fixes MariaDB Cluster node getting stuck during IST while going from the Synced to Joining node states. (MDEV-21002)

  • Fixes HediSQL update to 11.0. (MDEV-22032)

Platforms

In alignment to the MariaDB Corporation Engineering Policy, MariaDB Community Server 10.5.2 is provided for:

  • Red Hat Enterprise Linux 8

  • Red Hat Enterprise Linux 7

  • Red Hat Enterprise Linux 6

  • CentOS 8

  • CentOS 7

  • CentOS 6

  • Ubuntu 20.04

  • Ubuntu 18.04

  • Ubuntu 16.04

  • Debian 10

  • Debian 9

  • Debian 8

  • SUSE Linux Enterprise Server 15

  • SUSE Linux Enterprise Server 12

  • Microsoft Windows