Skip to content

List of features available in Percona Server for MySQL releases

Percona Server for MySQL 5.7 Percona Server for MySQL 8.0
Improved Buffer Pool Scalability Improved Buffer Pool Scalability
Improved InnoDB I/O Scalability Improved InnoDB I/O Scalability
Multiple Adaptive Hash Search Partitions Multiple Adaptive Hash Search Partitions
Atomic write support for Fusion-io devices Atomic write support for Fusion-io devices
Query Cache Enhancements Feature not implemented
Improved NUMA support Feature not implemented
Thread Pool Thread Pool
Suppress Warning Messages Suppress Warning Messages
Ability to change the database for mysqlbinlog Ability to change the database for mysqlbinlog
Fixed Size for the Read Ahead Area Fixed Size for the Read Ahead Area
Improved MEMORY Storage Engine Improved MEMORY Storage Engine
Restricting the number of binlog files Restricting the number of binlog files
Ignoring missing tables in mysqldump Ignoring missing tables in mysqldump
Too Many Connections Warning Too Many Connections Warning
Handle Corrupted Tables Handle Corrupted Tables
Lock-Free SHOW SLAVE STATUS Lock-Free SHOW REPLICA STATUS
Expanded Fast Index Creation Expanded Fast Index Creation
Percona Toolkit UDFs Percona Toolkit UDFs
Support for Fake Changes Support for Fake Changes
Kill Idle Transactions Kill Idle Transactions
XtraDB changed page tracking XtraDB changed page tracking
Enforcing Storage Engine Replaced with upstream implementation
Utility user Utility user
Extending the secure-file-priv server option Extending the secure-file-priv server option
Expanded Program Option Modifiers Feature not implemented
PAM Authentication Plugin PAM Authentication Plugin
Log Archiving for XtraDB Log Archiving for XtraDB
User Statistics User Statistics
Slow Query Log Slow Query Log
Count InnoDB Deadlocks Count InnoDB Deadlocks
Log All Client Commands (syslog) Log All Client Commands (syslog)
Response Time Distribution Feature not implemented
Show Storage Engines Show Storage Engines
Show Lock Names Show Lock Names
Process List Process List
Misc. INFORMATION_SCHEMA Tables Misc. INFORMATION_SCHEMA Tables
Extended Show Engine InnoDB Status Extended Show Engine InnoDB Status
Thread Based Profiling Thread Based Profiling
XtraDB Performance Improvements for I/O-Bound Highly-Concurrent Workloads XtraDB Performance Improvements for I/O-Bound Highly-Concurrent Workloads
Page cleaner thread tuning Page cleaner thread tuning
Statement Timeout Statement Timeout
Extended SELECT INTO OUTFILE/DUMPFILE Extended SELECT INTO OUTFILE/DUMPFILE
Per-query variable statement Per-query variable statement
Extended mysqlbinlog Extended mysqlbinlog
Slow Query Log Rotation and Expiration Slow Query Log Rotation and Expiration
Metrics for scalability measurement Feature not implemented
Audit Log Audit Log
Backup Locks Backup Locks
CSV engine mode for a standard-compliant quote and comma parsing CSV engine mode for a standard-compliant quote and comma parsing
Super read-only Super read-only

Other Reading


Last update: 2022-09-27