Percona Distribution for MySQL 8.0.31 using Percona XtraDB Cluster (2023-03-15)¶
|Release date||March 15, 2023|
|Install instructions||Installing Percona Distribution for MySQL|
Percona Distribution for MySQL is the most stable, scalable and secure open-source MySQL distribution, with two download options: one based on Percona Server for MySQL and one based on Percona XtraDB Cluster.
This release is focused on the Percona XtraDB Cluster-based deployment variation. It is based on Percona XtraDB Cluster 8.0.31-23
Improvements and bug fixes introduced by Oracle for MySQL 8.0.31 and included in Percona XtraDB Cluster and Percona Distribution for MySQL are the following:
InnoDB supports parallel index builds. This improves index build performance. The sorted index entries are loaded into a B-tree in a multithread. In previous releases, this action was performed by a single thread.
The Performance and sys schemas show metrics for the global and session memory limits introduced in MySQL 8.0.28.
The following columns have been added to the Performance Schema tables:
Performance Schema tables Columns SETUP_INSTRUMENTS FLAGS THREADS CONTROLLED_MEMORY, MAX_CONTROLLED_MEMORY, TOTAL_MEMORY, MAX_TOTAL_MEMORY EVENTS_STATEMENTS_CURRENT, EVENTS_STATEMENTS_HISTORY, EVENTS_STATEMENTS_HISTORY_LONG MAX_CONTROLLED_MEMORY, MAX_TOTAL_MEMORY Statement Summary Tables MAX_CONTROLLED_MEMORY, MAX_TOTAL_MEMORY Performance Schema Connection Tables MAX_SESSION_CONTROLLED_MEMORY, MAX_SESSION_TOTAL_MEMORY PREPARED_STATEMENTS_INSTANCES MAX_CONTROLLED_MEMORY, MAX_TOTAL_MEMORY
The following columns have been added to the sys schema
controlled_by_defaultflag has been added to the
PROPERTIEScolumn of the
Now, you can add and remove non-global memory instruments to the set of controlled-memory instruments. To do this, set the value of the
SQL> UPDATE PERFORMANCE_SCHEMA.SETUP_INTRUMENTS SET FLAGS="controlled" WHERE NAME='memory/sql/NET::buff';
audit_log_flushvariable has been deprecated and will be removed in future releases.
Find the full list of bug fixes and changes in the MySQL 8.0.31 Release Notes.
Review each component’s release notes for What’s new, improvements, or bug fixes. The following is a list of the components supplied with the Percona Server for MySQL-based variation of the Percona Distribution for MySQL:
|Percona XtraBackup||8.0.31-24||An open-source hot backup utility for MySQL-based servers that doesn’t lock your database during the backup.|
|HAProxy||2.5.12||A high-availability and load-balancing solution for Percona XtraDB Cluster. This is a default proxy.|
|ProxySQL||2.4.8||A high performance, high-availability, protocol-aware proxy for MySQL.|
|Percona Toolkit||3.5.1||The set of scripts to simplify and optimize database operation.|
|relication_manager.sh||1.0||A tool to manage multi-source replication between multiple Percona XtraDB Cluster clusters.|