Skip to content

Percona Server for MySQL 8.0.31-23 (2023-02-09)

Release date February 9, 2023
Install instructions Install Percona Server for MySQL
Download this version Percona Server for MySQL

Percona Server for MySQL 8.0.31-23 includes all the features and bug fixes available in the MySQL 8.0.31 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. It delivers more value to MySQL server users with optimized performance, greater performance scalability and availability, enhanced backups, and increased visibility.

For training, contact Percona Training - Start learning now.

Release highlights

Improvements and bug fixes introduced by Oracle for MySQL 8.0.31 and included in Percona Server for MySQL are the following:

  • MySQL adds support for the SQL standard INTERSECT and EXCEPT table operators.

  • 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 STATEMENT_ANALYSIS and X$STATEMENT_ANALYSIS views:

    • MAX_CONTROLLED_MEMORY

    • MAX_TOTAL_MEMORY

    The controlled_by_default flag has been added to the PROPERTIES column of the SETUP_INSTRUMENTS table.

    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 FLAGS column of SETUP_INSTRUMENTS.

    SQL> UPDATE PERFORMANCE_SCHEMA.SETUP_INTRUMENTS SET FLAGS="controlled" 
    WHERE NAME='memory/sql/NET::buff';
    
  • The audit_log_flush variable 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.

Improvements

Bug fixes

  • PS-1098: Manually rotating the log files by calling audit_log_flush multiple times resulted in using a wrong log file.

  • PS-7923: Assertion owned_gtids.is_owned_by(thd->owned_gtid, thd->thread_id()) failed.

  • PS-8106: MySQL exited when the replication was stopped on replicating a CREATE TABLE AS statement.

  • PS-8128: An in-place upgrade of views that refer to performance_schema tables failed.

  • PS-8328: MySQL 8.0 exited when using group_concat with group by with rollup.

  • PS-8503: checkpoint_age related status had no value. (Thanks to Huang Zhiyong for reporting this issue.)

  • PS-8547: Added a space after the binary name to count all active processes, including processes started by the binary. (Thanks to user Elbandi for reporting this issue.)

  • PS-8589: The replica crashed with fatal signal 11.

  • PS-8327: The usage of ALTER TABLE ... CHECK PARTITION inside stored procedure failed.

  • PS-8442: A fix for a crash in buf_pool_invalidate_instance().

Deprecated and removed

This release removes the following features, system variables, status variables, and options:

  • innodb_encryption_redo_key_version

  • innodb_encryption_rotation_pages_read_from_cache

  • innodb_encryption_rotation_pages_read_from_disk

  • innodb_encryption_rotation_pages_modified

  • innodb_encryption_rotation_pages_flushed

  • innodb_encryption_rotation_estimated_iops

  • innodb_encryption_rotation_list_length

  • innodb_num_pages_encrypted

  • innodb_num_pages_decrypted

  • innodb_encryption_threads

  • innodb_encryption_rotate_key_age

  • innodb_encryption_rotation_loops

  • innodb_default_encryption_key_id

  • rotate_system_key and any dependencies

This release changes the following system variable options:

  • ONLINE_TO_KEYRING and ONLINE_FROM_KEYRING_TO_UNENCRYPTED options are removed in the default_table_encryption variable.

  • The innodb_sys_tablespace_encrypt variable data type is changed to Boolean.

The Percona Server for MySQL GitHub location

Contribute to the documentation

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.


Last update: 2023-09-27