Skip to content
Percona Software for MySQL Documentation
Rate this page
☆ ☆ ☆ ☆ ☆
Thanks for your feedback
Thank you! The feedback has been submitted.

For help, click the link below to get free database assistance or contact our experts for personalized support.

Get help from Percona

Percona Server for MySQL 9.7.2-2 (2026-09-28)

Get started with Quickstart Guide for Percona Server for MySQL.

Percona Server for MySQL 9.7.2-2 includes all the features and bug fixes available in the MySQL 9.7.2 Community Edition and enterprise-grade features developed by Percona.

A note on MySQL 9.7.3

After a thorough review of the updates included in MySQL 9.7.3, Percona has decided not to release a corresponding Percona Server for MySQL 9.7.3. MySQL 9.7.3 is a Critical Security Patch Update (CSPU) — a targeted security release that Oracle can issue between quarterly Critical Patch Updates (CPUs) when needed. The fixes included in this CSPU do not affect Percona Server for MySQL.

Release highlights

MySQL 9.7.2

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

  • Under certain circumstances, when adding an AUTO_INCREMENT column to an existing table, some records in that table could be skipped, resulting in inaccurate values in the AUTO_INCREMENT column. (Bug #115136, Bug #37105825)

  • During a buffer-pool resize, Adaptive Hash Index could be disabled in mysqld-auto.cnf even though innodb_adaptive_hash_index=ON. (Bug #39157211)

  • Fixed a debug assertion in row_upd_rec_in_place() for non-versioned ROW_FORMAT=REDUNDANT rows. (Bug #39165747)

  • Fixed an issue relating to table maintenance and clean-up. (Bug #39091376)

  • Fixed an issue relating to unique indexes. (Bug #38501299)

Find the complete list of bug fixes and changes in the MySQL 9.7.2 release notes

New features

  • PS-10849, PS-10999, PS-11065, PS-11220, and PS-11316: Percona Server for MySQL 9.7 now supports OpenID Connect (OIDC), allowing users to authenticate through compatible external identity providers. The server validates JWTs and audience claims, maps identity-provider groups to MySQL roles, and supports proxy users. The OIDC plugin also includes telemetry and memory instrumentation to improve monitoring and operational visibility. See Connect OIDC.

  • PS-11167: Added SQL functions for calculating the distance between vector values. Applications can use these functions to measure vector similarity and support search, recommendation, and other vector-based workloads. See DISTANCE()

Improvements

  • PS-11120: Reduced page-level mutex contention when many concurrent sessions perform range-select queries against the same InnoDB pages. This change improves throughput and reduces waits for workloads that repeatedly access hot data.

  • PS-11216: Group Replication communication debug traces now include timestamps. Administrators can more easily identify, sequence, and correlate events when troubleshooting large GCS_DEBUG_TRACE files.

  • PS-11413: Improved validation and logging for errors in JSON-based OIDC configuration files. Invalid configuration sections are no longer silently ignored, and the server log provides clearer information to help diagnose configuration problems.

  • PS-11444: Reduced the time that InnoDB holds the buffer pool LRU list mutex during physical page reads. This change decreases serialization and improves scalability for I/O-intensive workloads.

  • PS-11445: Restored a dedicated LRU manager thread for each buffer pool instance. Moving LRU flushing work away from page-cleaner threads improves buffer pool maintenance under heavy workloads.

  • PS-11446: Corrected an LRU boundary check that caused scans to restart unnecessarily. LRU scans now continue through eligible pages as intended, reducing repeated work and improving flushing efficiency.

  • PS-11447: Improved how InnoDB obtains free pages while an LRU batch flush is running. User threads can perform a controlled single-page flush when necessary and avoid repeated waits, improving responsiveness when the buffer pool is under pressure. New monitoring counters provide visibility into single-page flushes and LRU flush waits.

Bug Fixes

  • PS-8822: Fixed a performance regression affecting queries that use JOIN operations. The associated InnoDB optimizations reduce unnecessary processing and improve query performance.

  • PS-11135: Corrected a misleading error reported for invalid audit log filter definitions. The server now provides a more accurate message describing the configuration problem instead of incorrectly recommending a different event mode.

  • PS-11143: Fixed a server crash that could occur under connection-heavy workloads when the thread pool and certain Performance Schema instruments were enabled.

  • PS-11182: Starting a new audit_log_read() sequence now implicitly closes the previous sequence. Users no longer need to close each sequence manually before reading from another position.

  • PS-11186: The audit_log_read() function now honors the max_array_length setting when audit events use the JSON FULL or REDUCED format, ensuring that the returned result contains no more than the requested number of events.

  • PS-11202: The server now handles corrupted page-tracking files gracefully. It reports a warning and continues without the unavailable tracking information instead of exiting.

  • PS-11209: Fixed failures in concurrent Common Table Expression (CTE) queries that could incorrectly report error 1146 for missing internal temporary tables.

  • PS-11217: The Group Replication GCS_DEBUG_TRACE file can now be rotated and recreated without restarting Group Replication, simplifying extended debugging sessions.

  • PS-11248: Updated the documentation to clarify how externally assigned LDAP and OIDC roles are handled when group membership changes or authentication does not complete successfully.

  • PS-11253: Fixed a memory-safety issue in the external role-grant mechanism used by authentication plugins such as LDAP and OIDC. The server no longer accesses released memory while adding these roles to the privilege cache.

  • PS-11273: Fixed a secondary server crash that could occur while startup was being stopped because of an invalid authentication configuration. The server now reports the configuration error and exits cleanly.

  • PS-11297: Removed unnecessary record-offset validation from production builds, reducing InnoDB processing overhead and improving performance by up to 4.6% in tested Percona Server for MySQL 9.7 workloads.

Install Percona Server for MySQL 9.7

Upgrade Percona Server for MySQL

The Percona Server for MySQL GitHub repository

Download product binaries, packages, and tarballs at Percona Software Downloads

Contribute to the documentation

For training, contact Percona Training - Start learning now