Skip to content
logo
Percona Server for MySQL
Percona Server for MySQL 5.7.40-43 (2022-11-28)
Initializing search
    percona/psmysql-docs
    percona/psmysql-docs
    • Home
      • List of features available in Percona Server for MySQL releases
      • The Percona XtraDB Storage Engine
      • Percona Server for MySQL Feature Comparison
      • Changed in Percona Server 5.7
      • Understand version numbers
      • Installing Percona Server for MySQL 5.7
      • Installing Percona Server for MySQL 5.7 on Debian and Ubuntu
      • Installing Percona Server for MySQL 5.7 on Red Hat Enterprise Linux and CentOS
      • Installing _Percona Server for MySQL_ 5.7 from a Binary Tarball
      • Installing _Percona Server for MySQL_ 5.7 from a Source Tarball
      • Compiling Percona Server for MySQL 5.7 from Source
      • Installing Percona Server for MySQL 5.7 from the Git Source Tree
      • Running Percona Server for MySQL 5.7 in a Docker Container
      • Upgrade from earlier versions
      • Performing a Distribution upgrade in-place on a System with installed Percona packages
      • Upgrading using the Percona repositories
      • Upgrading using Standalone Packages
      • Percona Server In-Place Upgrading Guide: From 5.6 to 5.7
      • Post-Installation steps for Percona Server for MySQL 5.7
      • User Statistics
      • Slow Query Log
      • Extended Show Engine InnoDB Status
      • Show Storage Engines
      • Process List
      • Misc. INFORMATION_SCHEMA Tables
      • Thread Based Profiling
      • Metrics for scalability measurement
      • Response Time Distribution
      • InnoDB Page Fragmentation Counters
      • Using libcoredumper
      • Stacktrace
      • Suppress Warning Messages
      • Improved MEMORY Storage Engine
      • Restricting the number of binlog files
      • Extended mysqldump
      • Extended SELECT INTO OUTFILE/DUMPFILE
      • Per-query variable statement
      • Extended mysqlbinlog
      • Slow Query Log Rotation and Expiration
      • CSV engine mode for standard-compliant quote and comma parsing
      • Support for PROXY protocol
      • Per-session server-id
      • Compressed columns with dictionaries
      • InnoDB Full-Text Search improvements
      • Binlogging and replication improvements
      • Percona Toolkit UDFs
      • Kill Idle Transactions
      • Enforcing Storage Engine
      • Expanded Program Option Modifiers
      • XtraDB changed page tracking
      • Expanded Fast Index Creation
      • Backup Locks
      • Audit Log Plugin
      • Start transaction with consistent snapshot
      • Extended SHOW GRANTS
      • Utility user
      • PS-Admin script
      • Percona MyRocks Introduction
      • Percona MyRocks Installation Guide
      • MyRocks Limitations
      • Differences between Percona MyRocks and Facebook MyRocks
      • MyRocks Server Variables
      • MyRocks status variables
      • Gap locks detection
      • Data Loading
      • Multiple page asynchronous I/O requests
      • Query Cache Enhancements
      • Limiting the Estimation of Records in a Query
      • Improved NUMA support
      • Thread Pool
      • XtraDB Performance Improvements for I/O-Bound Highly-Concurrent Workloads
      • Prefix Index Queries Optimization
      • Too Many Connections Warning
      • Handle Corrupted Tables
      • Improved Buffer Pool Scalability
      • Improved InnoDB I/O Scalability
      • Data at Rest Encryption
      • PAM Authentication Plugin
      • SSL Improvements
      • Data Masking
      • TokuDB Introduction
      • TokuDB Installation
      • Using TokuDB
      • Fast Updates with TokuDB
      • TokuDB files and file types
      • TokuDB file management
      • TokuDB Background ANALYZE TABLE
      • TokuDB Variables
      • TokuDB Status Variables
      • TokuDB Fractal Tree Indexing
      • TokuDB Troubleshooting
      • TokuDB Performance Schema Integration
      • Percona TokuBackup
      • Frequently Asked Questions
      • Removing TokuDB storage engine
      • Release notes index
      • Percona Server for MySQL 5.7.41-44 (2023-03-02)
      • Percona Server for MySQL 5.7.40-43 (2022-11-28)
        • Release highlights
        • Bug fixes
        • Platform support
        • Useful links
      • Percona Server for MySQL 5.7.39-42 (2022-08-15)
      • Percona Server for MySQL 5.7.38-41 (2022-06-02)
      • Percona Server for MySQL 5.7.37-40 (2022-03-31)
      • Percona Server for MySQL 5.7.36-39 (2021-12-22)
      • Percona Server for MySQL 5.7.35-38 (2021-08-18)
      • Percona Server for MySQL 5.7.34-37 (2021-05-26)
      • Percona Server for MySQL 5.7.33-36 (2021-03-02)
      • Percona Server for MySQL 5.7.32-35 (2020-11-24)
      • Percona Server for MySQL 5.7.31-34 (2020-08-24)
      • Percona Server for MySQL 5.7.30-33 ((2020-05-20)
      • Percona Server for MySQL 5.7.29-32 (2020-02-05)
      • Percona Server for MySQL 5.7.28-31 (2019-11-13)
      • Percona Server for MySQL 5.7.27-30 (2019-08-22)
      • Percona Server for MySQL 5.7.26-29 (2019-05-27)
      • Percona Server for MySQL 5.7.25-28 (2019-02-18)
      • Percona Server for MySQL 5.7.24-27 (2018-12-18)
      • Percona Server 5.7.24-26 (2018-12-04)
      • Percona Server 5.7.23-25 (2018-11-21)
      • Percona Server 5.7.23-24 (2018-11-09)
      • Percona Server 5.7.23-23 (2018-09-12)
      • Percona Server 5.7.22-22 (2018-05-31)
      • Percona Server 5.7.21-21 (2018-04-24)
      • Percona Server 5.7.21-20 (2018-02-19)
      • Percona Server 5.7.20-19 (2018-01-03)
      • Percona Server 5.7.20-18 (2017-12-14)
      • Percona Server 5.7.19-17 (2017-08-31)
      • Percona Server for MySQL 5.7.18-16 (2017-07-28)
      • Percona Server for MySQL 5.7.18-15 (2017-05-26)
      • Percona Server for MySQL 5.7.18-14 (2017-05-12)
      • Percona Server for MySQL 5.7.17-13 (2017-04-05)
      • Percona Server for MySQL 5.7.17-12 (2017-03-24)
      • Percona Server for MySQL 5.7.17-11 (2017-02-03)
      • Percona Server for MySQL 5.7.16-10 (2016-11-28)
      • Percona Server for MySQL 5.7.15-9 (2016-10-21)
      • Percona Server for MySQL 5.7.14-8 (2016-09-21)
      • Percona Server for MySQL 5.7.14-7 (2016-08-23)
      • Percona Server for MySQL 5.7.13-6 (2016-07-16)
      • Percona Server for MySQL 5.7.12-5 (2016-06-06)
      • Percona Server for MySQL 5.7.11-4 (2016-03-15)
      • Percona Server for MySQL 5.7.10-3 (2016-02-23)
      • Percona Server for MySQL 5.7.10-2 (2016-02-05)
      • Percona Server for MySQL 5.7.10-1 (2015-12-14)
      • List of upstream MySQL bugs fixed in Percona Server for MySQL 5.7
      • List of variables introduced in Percona Server 5.7
      • Development of Percona Server for MySQL
      • Trademark policy
      • Index of INFORMATION_SCHEMA Tables
      • Frequently Asked Questions
      • Copyright and licensing information
      • Glossary

    • Release highlights
    • Bug fixes
    • Platform support
    • Useful links

    Percona Server for MySQL 5.7.40-43 (2022-11-28)¶

    Release date November 28, 2022
    Install instructions Install Percona Server for MySQL
    Download this version Percona Server for MySQL

    Percona Server for MySQL 5.7.40-43 includes all the features and bug fixes available in MySQL 5.7.40 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 paid support, managed services or consulting services, contact Percona Sales

    For training, contact Percona Training - Start learning now

    Release highlights¶

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

    • ISO 8601 timestamps in log messages did not consider daylight saving time when --log-timestamps=SYSTEM was used.

    • The GRANT OPTION privilege was treated as related to database operations.

    • In specific cases, a TRUNCATE TABLE operation failed to release an acquired mutex.

    • A descending b-tree scan raised a debug assertion failure in debug builds.

    Find the full list of bug fixes and changes in the MySQL 5.7.40 Release Notes.

    Bug fixes¶

    • PS-1098: Manually rotating the log files by calling audit_log_flush multiple times caused incorrect file rotation and the wrong log file to be used.
    • PS-8327: ALTER TABLE ... CHECK PARTITION inside the stored procedure caused a server exit.

    Platform support¶

    Percona Server for MySQL 5.7.40-43 does not support Ubuntu 22.04.

    Useful links¶

    The Percona Server for MySQL GitHub location

    Contribute to the documentation

    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: 2022-11-28
    Percona LLC, © 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.