1.. _ps_versions_comparison: 2 3================================================================= 4List of features available in Percona Server for MySQL releases 5================================================================= 6 7.. tabularcolumns:: p{5cm}|p{5cm}| 8 9.. list-table:: 10 :header-rows: 1 11 12 * - Percona Server for MySQL 5.7 13 - Percona Server for MySQL 8.0 14 * - Improved Buffer Pool Scalability 15 - Improved Buffer Pool Scalability 16 * - Improved InnoDB I/O Scalability 17 - Improved InnoDB I/O Scalability 18 * - Multiple Adaptive Hash Search Partitions 19 - Multiple Adaptive Hash Search Partitions 20 * - Atomic write support for Fusion-io devices 21 - Atomic write support for Fusion-io devices 22 * - Query Cache Enhancements 23 - Feature not implemented 24 * - Improved NUMA support 25 - Feature not implemented 26 * - Thread Pool 27 - Thread Pool 28 * - Suppress Warning Messages 29 - Suppress Warning Messages 30 * - Ability to change database for mysqlbinlog 31 - Ability to change database for mysqlbinlog 32 * - Fixed Size for the Read Ahead Area 33 - Fixed Size for the Read Ahead Area 34 * - Improved MEMORY Storage Engine 35 - Improved MEMORY Storage Engine 36 * - Restricting the number of binlog files 37 - Restricting the number of binlog files 38 * - Ignoring missing tables in mysqldump 39 - Ignoring missing tables in mysqldump 40 * - Too Many Connections Warning 41 - Too Many Connections Warning 42 * - Handle Corrupted Tables 43 - Handle Corrupted Tables 44 * - Lock-Free SHOW SLAVE STATUS 45 - Lock-Free SHOW REPLICA STATUS 46 * - Expanded Fast Index Creation 47 - Expanded Fast Index Creation 48 * - Percona Toolkit UDFs 49 - Percona Toolkit UDFs 50 * - Support for Fake Changes 51 - Support for Fake Changes 52 * - Kill Idle Transactions 53 - Kill Idle Transactions 54 * - XtraDB changed page tracking 55 - XtraDB changed page tracking 56 * - Enforcing Storage Engine 57 - Replaced with upstream implementation 58 * - Utility user 59 - Utility user 60 * - Extending the secure-file-priv server option 61 - Extending the secure-file-priv server option 62 * - Expanded Program Option Modifiers 63 - Feature not implemented 64 * - PAM Authentication Plugin 65 - PAM Authentication Plugin 66 * - Log Archiving for XtraDB 67 - Log Archiving for XtraDB 68 * - User Statistics 69 - User Statistics 70 * - Slow Query Log 71 - Slow Query Log 72 * - Count InnoDB Deadlocks 73 - Count InnoDB Deadlocks 74 * - Log All Client Commands (syslog) 75 - Log All Client Commands (syslog) 76 * - Response Time Distribution 77 - Feature not implemented 78 * - Show Storage Engines 79 - Show Storage Engines 80 * - Show Lock Names 81 - Show Lock Names 82 * - Process List 83 - Process List 84 * - Misc. INFORMATION_SCHEMA Tables 85 - Misc. INFORMATION_SCHEMA Tables 86 * - Extended Show Engine InnoDB Status 87 - Extended Show Engine InnoDB Status 88 * - Thread Based Profiling 89 - Thread Based Profiling 90 * - XtraDB Performance Improvements for I/O-Bound Highly-Concurrent Workloads 91 - XtraDB Performance Improvements for I/O-Bound Highly-Concurrent Workloads 92 * - Page cleaner thread tuning 93 - Page cleaner thread tuning 94 * - Statement Timeout 95 - Statement Timeout 96 * - Extended SELECT INTO OUTFILE/DUMPFILE 97 - Extended SELECT INTO OUTFILE/DUMPFILE 98 * - Per-query variable statement 99 - Per-query variable statement 100 * - Extended mysqlbinlog 101 - Extended mysqlbinlog 102 * - Slow Query Log Rotation and Expiration 103 - Slow Query Log Rotation and Expiration 104 * - Metrics for scalability measurement 105 - Feature not implemented 106 * - Audit Log 107 - Audit Log 108 * - Backup Locks 109 - Backup Locks 110 * - CSV engine mode for standard-compliant quote and comma parsing 111 - CSV engine mode for standard-compliant quote and comma parsing 112 * - Super read-only 113 - Super read-only 114 115 116Other Reading 117============= 118 119* `What Is New in MySQL 5.7 <http://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html>`__ 120 121* `What Is New in MySQL 8.0 <http://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html>`__ 122