Release date: 26 Mar 2020
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.
Thanks, and enjoy MariaDB!
This is the second beta release in the series.
Notable changes of this release include:
()
()
()
Recursive cycle detection using CYCLE clause ()
Split SUPER to smaller privileges (). New privileges were added so that more fine grained tuning of what each user can do can be applied:
An upgrade will only be possible after a clean shutdown. mariadb-backup --prepare will not work with backups taken before version 10.5.2.
Efficient InnoDB redo log record format ()
Deprecate and ignore and ()
Remove table and deprecate and ignore , , and
Allow packed sort keys in sort buffer ()
Merge 5.7 P_S transaction instrumentation and tables ()
Merge 5.7 P_S memory instrumentation and tables ()
Merge 5.7 P_S mdl instrumentation and tables ()
Merge 5.7 P_S sxlocks instrumentation and tables ()
ENFORCE option for ()
Add information about packed addon fields in ()
All binaries previously beginning with mysql now begin with mariadb, with symlinks for the corresponding mysql command. ()
updated to 26.4.4
Galera Cluster Node During IST gets stuck going from "Synced" to "Joining:..." ()
updated to 11.0 ()
system variable, for rejecting connections attempted using insecure transport ()
session system variable, which adds an implicit IF EXISTS to ALTER, RENAME and DROP of TABLES, VIEWS, FUNCTIONS and PACKAGES. ()
transactions must survive client disconnection ()
For a complete list of changes made in , with links to detailed information on each push, see the .
For a full list of contributors to , see the .
Do not use beta releases in production!
and now support IF EXISTS.
The privilege was renamed to . The old syntax is understood for compatibility (MDEV-21743).
The statement was renamed to (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.
now requires the privilege (required prior to 10.5.2).
now requires the privilege (required prior to 10.5.2).
now requires the or the privilege (required or prior to 10.5.2).
now requires the privilege (required prior to 10.5.2).
In order to help the server understand which version a privilege record was written by, the field contains a new JSON field, version_id (MDEV-21704)
now correctly lists the Delete history privilege, rather than displaying it as Delete versioning rows. (MDEV-20382)
Deprecate and ignore (MDEV-14425)
Do not acquire InnoDB record locks when covering table locks exist (MDEV-14479)
Issue a message on changing deprecated innodb_log_files_in_group (MDEV-21990)
Optimize append only files for NVDIMM (MDEV-17084)
Improve innodb redo log group commit performance (MDEV-21534)
Punch holes when pages are freed (MDEV-15528)
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)
Binary tarball size has been reduced (MDEV-21943)
Do not use non-stable (non-GA) releases in production!
This page is licensed: CC BY-SA / Gnu FDL