Merge 5.7 P_S status instrumentation and tables ( MDEV-16438).Merge 5.7 P_S user variables instrumentation and tables ( MDEV-16439).Merge 5.7 P_S sxlocks instrumentation and tables ( MDEV-16436).Merge 5.7 P_S mdl instrumentation and tables ( MDEV-16432).Merge 5.7 P_S memory instrumentation and tables ( MDEV-16431).Merge 5.7 P_S transaction instrumentation and tables ( MDEV-16435).Allow packed sort keys in sort buffer ( MDEV-21580).Punch holes when pages are freed ( MDEV-15528).Improve innodb redo log group commit performance ( MDEV-21534).Optimize append only files for NVDIMM ( MDEV-17084).Issue a message on changing deprecated innodb_log_files_in_group ( MDEV-21990).Do not acquire InnoDB record locks when covering table locks exist ( MDEV-14479).Deprecate and ignore innodb_log_files_in_group ( MDEV-14425).Remove INFORMATION_SCHEMA.INNODB_TABLESPACES_SCRUBBING table and deprecate and ignore innodb-background-scrub-data-uncompressed, innodb-background-scrub-data-compressed, innodb-background-scrub-data-interval and innodb-background-scrub-data-check-interval ( MDEV-15528).Deprecate and ignore innodb_scrub_log and innodb_scrub_log_speed ( MDEV-21870).Efficient InnoDB redo log record format ( MDEV-12353).mariabackup -prepare will not work with backups taken before version 10.5.2.
#10.5.2SU4 RELEASE NOTEA UPGRADE#
An upgrade will only be possible after a clean shutdown. SHOW PRIVILEGES now correctly lists the Delete history privilege, rather than displaying it as Delete versioning rows. 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 RELAYLOG EVENTS now requires the REPLICATION SLAVE 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 SLAVE HOSTS now requires the REPLICATION MASTER ADMIN privilege (required REPLICATION SLAVE prior to 10.5.2). SHOW BINLOG EVENTS now requires the BINLOG MONITOR privilege (required REPLICATION SLAVE prior to 10.5.2). A number of GRANT commands might be needed after upgrade. Note, these changes are incompatible to previous versions. The old privileges were historically inappropriately chosen in the upstream. A number of statements changed the privileges that they require. The old syntax is understood for compatibility. The SHOW MASTER STATUS statement was renamed to SHOW BINLOG STATUS ( MDEV-21743). The old syntax is understood for compatibility ( MDEV-21743). The REPLICATION CLIENT privilege was renamed to BINLOG MONITOR. New privileges were added so that more fine grained tuning of what each user can do can be applied: Split SUPER privilege to smaller privileges ( MDEV-21743). ALTER TABLE and RENAME TABLE now support IF EXISTS. Recursive CTE cycle detection using CYCLE clause ( MDEV-20632). Notable changes of this release include: Syntax This is the second beta release in the MariaDB 10.5 series.
0 kommentar(er)
