Percona Server for MySQL 8.0.26-16 (2021-10-20)

• Installation Installing Percona Server for MySQL

Percona Server for MySQL 8.0.26-16 includes all the features and bug fixes available in the MySQL 8.0.26 Community Edition. in addition to enterprise-grade features developed by Percona.

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.

Release Highlights

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_purge_thread and srv_worker_thread values 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.

New Features

• PS-7757: Integrate ZenFS RocksDB plugin into Percona Server

• PS-7777: Document RocksDB variable rocksdb_manual_compaction_bottommost_level.

• PS-7765: Document RocksDB variable rocksdb_fault_injection_options

Deprecated Features

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.

Improvements

• 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 FALSE by default.

Bugs Fixed

• PS-1344: LP #1160436: Fix if the log_slow_statement is called unconditionally

• PS-1346: LP #1163232: Fix an anomaly with the opt_log_slow_slave_statements.

• 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 DEFINER are used.

• PS-1955: LP #1088529: Update the log_slow_verbosity help 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 /proc or /sys.

• PS-7784: Fix that reset the status variables procfs_access_violations and procfs_queries

• PS-7785: Fix that reset the default value for procfs_files_spec which had the same value.

• PS-7788: Fix improves wildcard globbing in proc_files_spec.

• PS-7917: Fix for installing the TokuDB storage engine with ps-admin.

Contact us

For free technical help, visit the Percona Community Forum.

To report bugs or submit feature requests, open a JIRA ticket.

For paid support and managed or consulting services , contact Percona Sales.

---

Last update: 2022-09-22