Percona Server for MySQL 8.0.27-18 (2022-03-02)¶
- 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.
The following lists a number of the bug fixes for MySQL 8.0.27, provided by Oracle, and included in Percona Server for MySQL:
default_authentication_pluginis deprecated. Support for this plugin may be removed in future versions. Use the
binaryoperator is deprecated. Support for this operator may be removed in future versions. Use
CAST(... AS BINARY).
Fix for when a parent table initiates a cascading
SET NULLoperation on the child table, the virtual column can be set to NULL instead of the value derived from the parent table.
Find the full list of bug fixes and changes in the MySQL 8.0.27 Release Notes.
PS-7960: Documented the
rocksdb_bulk_load_partial_indexvariable, and the
PS-2346: LP #720547: Implemented an option to allow queries with specific error codes to add entries to the Slow Query Log.
PS-7955: Enabled ZenFS functionality on standard Percona Server packages on Debian 11 and Ubuntu 20.04.
PS-7931: Implemented a Slow Query Log Rotation and Expiration in Percona Server for MySQL 8.0.
PS-6730: The ‘Last_errno:’ field in the Slow Query Log contains only error information.
PS-8076: Added a deprecation warning when using XtraDB changed page tracking.
ALTERquery caused a server exit when
PS-8007: Percona Server for MySQL can fail to start if the server starts before the network mounts the datadir or a local mount of the datadir.
PS-7977: The AppArmor profile is broken after an 8.0.22-13 to 8.0.23-14 upgrade. (Thanks to Alex Kompel for reporting this issue)
SELECTstatement using a Full-Text Search index with a special character caused a server exit.
PS-7940: The initialization of a virtual column template if a child table had a virtual column caused a restart loop. This initialization prevented a server exit when there was an
ON DELETE CASCADEstatement in the parent table and the child table had virtual columns. (Upstream #105290)
PS-7975: Fix to allow test main.mtr_unit_tests to complete successfully (Thanks to Thomas Deutschmann for reporting this issue)
PS-5168 Fix for when the Slow Query Log reports
zenfsutility backup and restore requirements for the
--pathcommand line option, the
--backup_pathcommand-lne option, and the
restore_pathcommand-line option. For more information, see Installing and configuring Percona Server for MySQL with ZenFS support.
- Red Hat Enterprise Linux 6 (and derivative Linux distributions) are no longer supported.
The RPM packages for Red Hat Enterprise Linux 7 (and compatible derivatives) do not support TLSv1.3, as it requires OpenSSL 1.1.1, which is currently not available on this platform.
The Documentation Contribution Guide describes the methods available to contribute to the Percona Server for MySQL documentation.
For free technical help, visit the Percona Community Forum.
To report bugs or submit feature requests, open a JIRA ticket.
Get expert help¶
If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.