Percona Server for MySQL 8.0.26-16 (2021-10-20)¶
- Installation Installing Percona Server for MySQL
Percona Server for MySQL® is a free, fully compatible, enhanced and open source drop-in replacement for any MySQL database. It provides superior performance, scalability and instrumentation.
Percona Server for MySQL is trusted by thousands of enterprises to provide better performance and concurrency for their most demanding workloads, and delivers greater value to MySQL server users with optimized performance, greater performance scalability and availability, enhanced backups and increased visibility. Commercial support contracts are available.
We have integrated a ZenFS RocksDB plugin to Percona Server for MySQL. This plugin places files on a raw zoned block device (ZBD) using the MyRocks File System interface. For more information, see Installing and configuring Percona Server for MySQL with ZenFS support.
The following list are some of the bug fixes for MySQL 8.0.26, provided by Oracle, and included in Percona Server for MySQL:
#104575: In the PERFORMANCE_SCHEMA.Threads table, the
srv_worker_threadvalues are duplicated.
#104387: When using REGEX comparison, a CHARACTER_SET_MISMATCH error is thrown.
#104576: Accessing the second index in a partition table with many columns can create a high CPU load.
Find the full list of bug fixes and changes in MySQL 8.0.26 Release Notes.
PS-7757: Integrate ZenFS RocksDB plugin into Percona Server
PS-7777: Document RocksDB variable
PS-7765: Document RocksDB variable
The TokuDB Storage Engine was declared deprecated for Percona Server for MySQL. Starting with Percona Server 8.0.26-16, the plugins are available in the binary builds and packages but are disabled. The plugins will be removed from the binary builds and packages in a future version.
New options have been added to enable the plugins if they are needed to migrate the data to another storage engine.
The instructions on how to enable the plugins and more information are available at the beginning of each TokuDB topic.
PS-7526: Fix the unexpected quoting and dropping of comments in DROP TABLE commands
PS-7706: Add options to explicitly enable TokuDB and TokuDB Backup that are
PS-1344: LP #1160436: Fix if the
log_slow_statementis called unconditionally
PS-1346: LP #1163232: Fix an anomaly with the
PS-7500: Fix the
SELECT COUNT(\*)is slow in MyRocks.
PS-7742: Fix when enabling binary log encryption breaks the basic replication setup on Percona Server for MySQL.
PS-7746: Fix for a possible double call to free_share() in ha_innobase::open()
PS-7778: Fix for denied commands when triggers with
PS-1955: LP #1088529: Update the
log_slow_verbosityhelp text to add the missing the “minimal”, “standard”, and “full” options
PS-2433: LP #1234346: Include a timestamp in the slow query log file when initializing a new file
PS-7790: Fix that disallows certain roles the ability to bypass the ProcFS access boundary with .. instead of
PS-7784: Fix that reset the status variables
PS-7785: Fix that reset the default value for
procfs_files_specwhich had the same value.
PS-7788: Fix improves wildcard globbing in
PS-7917: Fix for installing the TokuDB storage engine with ps-admin.