Skip to content
Percona Software for MySQL Documentation

Percona Server for MySQL 8.0.40-31 (2024-12-12)

Get started with Quickstart Guide for Percona Server for MySQL.

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

Release highlights

This release merges the MySQL 8.0.40 code base. Percona has implemented the Agile Release Train Strategy. This strategy allows us to deliver software updates more frequently, ensuring you receive the latest features and improvements as soon as they’re ready. This approach helps us respond quickly to your needs and provide a better overall experience with our product.

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

  • Changes in MySQL 8.0.33 caused queries using joins on InnoDB tables to perform worse because refactoring affected functions that were previously inline.

  • The server crashed when it tried to update columns altered with NULL as the default value using the INSTANT algorithm.

  • The server could crash during DELETE or UPDATE operations if a column was dropped using the INSTANT algorithm.

  • Importing a table created under a different sql_mode sometimes led to schema mismatches, risking data corruption in secondary indexes. The fix now includes integrity checks on the imported tablespace.

  • Rebuilding tables with secondary indexes required more file I/O operations compared to MySQL 8.0.26, which slowed down query performance.

Find the complete list of bug fixes and changes in the MySQL 8.0.40 Release Notes.

Bug Fixes

  • PS-9323: A file name change in the documentation broke a link to Percona Toolkit UDFs in package install output.

  • PS-9369: The Audit plugin caused a memory leak. This occurred when threads remained connected to the database for extended periods.

  • PS-9382: After an upgrade, the telemetry daemon ran continuously. The telemetry daemon was manually stopped and the service was disabled. Adding percona_telemetry_disable=1 to the configuration file and restarting MySQL led to the server becoming unresponsive and required a forced termination.

  • PS-9453: The percona_telemetry tool caused a long wait on COND_thd_list if the root user is absent.

Install Percona Server for MySQL 8.0

Upgrade Percona Server for MySQL from 5.7 to 8.0

The Percona Server for MySQL GitHub repository

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

Contribute to the documentation

For training, contact Percona Training - Start learning now

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.

Community Forum Get a Percona Expert

Last update: 2024-11-15