Skip to content
MySQL 5.7 will reach its EOL stage in October 2023.

Do you need help upgrading to MySQL 8.0? Do you need to stay on MySQL 5.7 a bit longer? We will support you either way. Learn more
logo
Percona Server for MySQL
Home
Initializing search
    percona/psmysql-docs
    percona/psmysql-docs
    • Home
      • For Monitoring and Management
      • 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.42-46 (2023-06-01)
      • Percona Server for MySQL 5.7.42-45 (2023-05-23)
      • Percona Server for MySQL 5.7.41-44 (2023-03-02)
      • Percona Server for MySQL 5.7.40-43 (2022-11-28)
      • 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

    • For Monitoring and Management

    Percona Server for MySQL 5.7 Documentation¶

    This documentation is for the latest release: Percona Server for MySQL 5.7.42-46 (Release Notes).

    Percona Server for MySQL is a freely available, fully compatible, enhanced, and open source drop-in replacement for any MySQL database. It provides superior and optimized performance, greater scalability, and availability, enhanced backups, increased visibility and instrumentation.

    Percona Server for MySQL is trusted by thousands of enterprises to provide better performance and concurrency for their most demanding workloads.

    For Monitoring and Management¶

    Percona Monitoring and Management (PMM )monitors and provides actionable performance data for MySQL variants, including Percona Server for MySQL, Percona XtraDB Cluster, Oracle MySQL Community Edition, Oracle MySQL Enterprise Edition, and MariaDB. PMM captures metrics and data for the InnoDB, XtraDB, and MyRocks storage engines, and has specialized dashboards for specific engine details.

    Install PMM and connect your server instances to it.

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