Skip to content
logo
Percona Distribution for MySQL
Percona Distribution for MySQL 8.0.31 using Percona Server for MySQL (2023-02-09)
Initializing search
    /percona/pdmysql-docs
    /percona/pdmysql-docs
    • Home
      • Components
      • Deployment variants
      • Install Percona Distribution for MySQL
      • Upgrade Percona Distribution for MySQL
      • Downgrade Percona Distribution for MySQL
      • Technical overview
      • Architecture and components
      • Measurement and monitoring
      • Deployment
      • Replication manager for Percona XtraDB Cluster
      • Replication manager troubleshooting
      • Single replica manager for Percona XtraDB Cluster
      • Uninstalling Percona Distribution for MySQL
      • Release notes index
        • Percona Distribution for MySQL 8.0.32 using Percona Server for MySQL Second Update (2023-04-04)
        • Percona Distribution for MySQL 8.0.32 using Percona Server for MySQL Update (2023-03-28)
        • Percona Distribution for MySQL 8.0.32 using Percona Server for MySQL (2023-03-20)
        • Percona Distribution for MySQL 8.0.31 using Percona Server for MySQL Update (2023-02-15)
        • Percona Distribution for MySQL 8.0.31 using Percona Server for MySQL (2023-02-09)
          • Release highlights
          • Supplied components
        • Percona Distribution for MySQL 8.0.30 using Percona Server for MySQL Second Update (2023-01-23)
        • Percona Distribution for MySQL 8.0.30 using Percona Server for MySQL Update (2023-01-06)
        • Percona Distribution for MySQL 8.0.30 using Percona Server for MySQL (2022-11-29)
        • Percona Distribution for MySQL 8.0.29 using Percona Server for MySQL (2022-08-09)
        • Percona Distribution for MySQL 8.0.28 using Percona Server for MySQL Update (2022-06-20)
        • Percona Distribution for MySQL 8.0.28 using Percona Server for MySQL (2022-05-12)
        • Percona Distribution for MySQL 8.0.27 using Percona Server for MySQL (2022-03-03)
        • Percona Distribution for MySQL 8.0.26 using Percona Server for MySQL (2021-10-20)
        • Percona Distribution for MySQL 8.0.25 using Percona Server for MySQL (2021-07-13)
        • Percona Distribution for MySQL 8.0.23 using Percona Server for MySQL (2021-05-12)
        • Percona Distribution for MySQL 8.0.22 using Percona Server for MySQL (2020-12-14)
        • Percona Distribution for MySQL 8.0.21 using Percona Server for MySQL (2020-10-13)
        • Percona Distribution for MySQL 8.0.20 using Percona Server for MySQL (2020-07-21)
        • None
        • Percona Distribution for MySQL 8.0.32 using Percona XtraDB Cluster Update (2023-05-24)
        • Percona Distribution for MySQL 8.0.32 using Percona XtraDB Cluster (2023-04-18)
        • Percona Distribution for MySQL 8.0.31 using Percona XtraDB Cluster Second Update (2023-04-04)
        • Percona Distribution for MySQL 8.0.31 using Percona XtraDB Cluster Update (2023-03-28)
        • Percona Distribution for MySQL 8.0.31 using Percona XtraDB Cluster (2023-03-15)
        • Percona Distribution for MySQL 8.0.30 using Percona XtraDB Cluster Update (2023-01-23)
        • Percona Distribution for MySQL 8.0.30 using Percona XtraDB Cluster (2022-12-28)
        • Percona Distribution for MySQL 8.0.29 using Percona XtraDB Cluster Update (2022-12-01)
        • Percona Distribution for MySQL 8.0.29 using Percona XtraDB Cluster (2022-09-12)
        • Percona Distribution for MySQL 8.0.28 using Percona XtraDB Cluster (2022-07-19)
        • Percona Distribution for MySQL 8.0.27 using Percona XtraDB Cluster (2022-04-11)
        • Percona Distribution for MySQL 8.0.26 using Percona XtraDB Cluster (2022-01-17)
        • Percona Distribution for MySQL 8.0.25 using Percona XtraDB Cluster (2021-11-22)
        • Percona Distribution for MySQL 8.0.23 using *Percona XtraDB Cluster* Update (2021-09-15)
        • Percona Distribution for MySQL 8.0.23 using Percona XtraDB Cluster (2021-06-09)
        • Percona Distribution for MySQL 8.0.22 using Percona XtraDB Cluster (2021-03-22)
        • Percona Distribution for MySQL 8.0.21 using Percona XtraDB Cluster (2020-12-28)
        • Percona Distribution for MySQL 8.0.20 using Percona XtraDB Cluster Second Update (2020-10-22)
        • Percona Distribution for MySQL 8.0.20 using Percona XtraDB Cluster Update (2020-10-09)
        • Percona Distribution for MySQL 8.0.20 using Percona XtraDB Cluster (2020-10-01)
        • Percona Distribution for MySQL 8.0.19 (2020-06-22)
      • Copyright and Licensing Information
      • Trademark Policy
      • Glossary

    • Release highlights
    • Supplied components

    Percona Distribution for MySQL 8.0.31 using Percona Server for MySQL (2023-02-09)¶

    Release date February 9, 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 Server for MySQL-based deployment variation. It is based on Percona Server for MySQL 8.0.31-23.

    Release highlights¶

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

    • A replica can add a Generated Invisible Primary Keys(GIPK) to any InnoDB table. To achieve this behavior, the GENERATE value is added as a possible value for the CHANGE REPLICATION SOURCE TO statement’s REQUIRE_TABLE_PRIMARY_KEY_CHECK option.

      REQUIRE_TABLE_PRIMARY_KEY_CHECK = GENERATE option can be used on a per-channel basis.

      Setting sql_generate_invisible_primary_key on the source is ignored by a replica because this variable is not replicated. This behavior is inherited from the previous releases.

    • 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.

    Supplied components¶

    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:

    Component Version Description
    Orchestrator 3.2.6-7 The replication topology manager for Percona Server for MySQL
    ProxySQL 2.4.4-1.2 A high performance, high-availability, protocol-aware proxy for MySQL
    Percona XtraBackup 8.0.31-24 An open-source hot backup utility for MySQL-based servers
    Percona Toolkit 3.5.1 The set of scripts to simplify and optimize database operation
    MySQL Shell 8.0.31 An advanced client and code editor for MySQL Server
    MySQL Router 8.0.31 Lightweight middleware that provides transparent routing between your application and back-end MySQL servers

    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: 2023-05-24
    Percona LLC and/or its affiliates, © 2023
    Made with Material for MkDocs

    Cookie consent

    We use cookies to recognize your repeated visits and preferences, as well as to measure the effectiveness of our documentation and whether users find what they're searching for. With your consent, you're helping us to make our documentation better.