List of features available in Percona Server releases

List of features available in Percona Server releases

Percona Server 5.1 Percona Server 5.5 Percona Server 5.6
Improved Buffer Pool Scalability Improved Buffer Pool Scalability Improved Buffer Pool Scalability
Configurable Insert Buffer Configurable Insert Buffer Feature not implemented
Improved InnoDB I/O Scalability Improved InnoDB I/O Scalability Improved InnoDB I/O Scalability
More Concurrent Transactions Available More Concurrent Transactions Available Replaced by the upstream implementation [1]
Feature not implemented Multiple Adaptive Hash Search Partitions Multiple Adaptive Hash Search Partitions
Dedicated Purge Thread Replaced by the upstream implementation [2] Replaced by the upstream implementation [2]
Drop table performance Drop table performance Replaced by the upstream fix [3]
Feature not implemented Atomic write support for Fusion-io devices Atomic write support for Fusion-io devices
Configuration of the Doublewrite Buffer Configuration of the Doublewrite Buffer Feature not implemented
Query Cache Enhancements Query Cache Enhancements Query Cache Enhancements
Fast InnoDB Checksum [4] Fast InnoDB Checksum [4] Replaced by the upstream implementation [4]
Reduced Buffer Pool Mutex Contention Reduced Buffer Pool Mutex Contention Feature not implemented
InnoDB timer-based Concurrency Throttling InnoDB timer-based Concurrency Throttling Replaced by the upstream implementation [5]
HandlerSocket HandlerSocket Feature not implemented [6]
Feature not implemented Improved NUMA support Improved NUMA support
Feature not implemented Thread Pool Thread Pool
Feature not implemented Binary Log Group Commit Replaced by the upstream implementation [7]
Support of Multiple Page Sizes [8] Support of Multiple Page Sizes [8] Replaced by the upstream implementation [8]
Suppress Warning Messages Suppress Warning Messages Suppress Warning Messages
Handle BLOB End of Line Handle BLOB End of Line Replaced by the upstream implementation [9]
Ability to change database for mysqlbinlog Ability to change database for mysqlbinlog Ability to change database for mysqlbinlog
Replication Stop Recovery Feature not implemented Feature not implemented
Fixed Size for the Read Ahead Area Fixed Size for the Read Ahead Area Fixed Size for the Read Ahead Area
Fast Shutdown Feature not implemented Feature not implemented
Feature not implemented Improved MEMORY Storage Engine Improved MEMORY Storage Engine
Feature not implemented Restricting the number of binlog files Restricting the number of binlog files
Ignoring missing tables in mysqldump Ignoring missing tables in mysqldump Ignoring missing tables in mysqldump
Too Many Connections Warning Too Many Connections Warning Too Many Connections Warning
Handle Corrupted Tables Handle Corrupted Tables Handle Corrupted Tables
Crash-Resistant Replication Crash-Resistant Replication Replaced by the upstream implementation [10]
Lock-Free SHOW SLAVE STATUS Lock-Free SHOW SLAVE STATUS Lock-Free SHOW SLAVE STATUS
Fast InnoDB Recovery Process Fast InnoDB Recovery Stats Feature not implemented
InnoDB Data Dictionary Size Limit InnoDB Data Dictionary Size Limit Replaced by the upstream implementation [11]
Expand Table Import Expand Table Import Replaced by the upstream implementation [12]
Dump/Restore of the Buffer Pool Dump/Restore of the Buffer Pool Replaced by the upstream implementation [13]
Fast Index Creation Fast Index Creation Replaced by the upstream implementation [14]
Expanded Fast Index Creation Expanded Fast Index Creation Expanded Fast Index Creation
Prevent Caching to FlashCache Prevent Caching to FlashCache Feature not implemented
Percona Toolkit UDFs Percona Toolkit UDFs Percona Toolkit UDFs
Support for Fake Changes Support for Fake Changes Support for Fake Changes
Kill Idle Transactions Kill Idle Transactions Kill Idle Transactions
XtraDB changed page tracking XtraDB changed page tracking XtraDB changed page tracking
Feature not implemented Enforcing Storage Engine Enforcing Storage Engine
Feature not implemented Utility user Utility user
Feature not implemented Extending the secure-file-priv server option Extending the secure-file-priv server option
Feature not implemented Expanded Program Option Modifiers Expanded Program Option Modifiers
Feature not implemented PAM Authentication Plugin PAM Authentication Plugin
Feature not implemented Feature not implemented Log Archiving for XtraDB
InnoDB Statistics InnoDB Statistics Replaced by the upstream implementation [15]
User Statistics User Statistics User Statistics
Slow Query Log Slow Query Log Slow Query Log
Count InnoDB Deadlocks Count InnoDB Deadlocks Count InnoDB Deadlocks
Log All Client Commands (syslog) Log All Client Commands (syslog) Log All Client Commands (syslog)
Response Time Distribution Response Time Distribution Feature not implemented
Show Storage Engines Show Storage Engines Show Storage Engines
Show Lock Names Show Lock Names Show Lock Names
Process List Process List Process List
Misc. INFORMATION_SCHEMA Tables Misc. INFORMATION_SCHEMA Tables Misc. INFORMATION_SCHEMA Tables
Feature not implemented Extended Show Engine InnoDB Status Extended Show Engine InnoDB Status
Feature not implemented Thread Based Profiling Thread Based Profiling
Feature not implemented Feature not implemented XtraDB Performance Improvements for I/O-Bound Highly-Concurrent Workloads
Feature not implemented Feature not implemented Page cleaner thread tuning
Feature not implemented Feature not implemented Statement Timeout
Feature not implemented Extended SELECT INTO OUTFILE/DUMPFILE Extended SELECT INTO OUTFILE/DUMPFILE
Feature not implemented Feature not implemented Per-query variable statement
Feature not implemented Extended mysqlbinlog Extended mysqlbinlog
Feature not implemented Slow Query Log Rotation and Expiration Slow Query Log Rotation and Expiration
Feature not implemented Metrics for scalability measurement Metrics for scalability measurement
Feature not implemented Audit Log Audit Log
Feature not implemented Feature not implemented Backup Locks

Other Reading

[1]Feature has been deprecated after Percona Server 5.5.11-20.2. It has replaced by the upstream implementation of innodb_undo_logs in MySQL 5.6.3.
[2](1, 2) Feature has not been ported from Percona Server 5.1 version. It has been replaced by the upstream Improved Purge Scheduling implementation.
[3]Feature has been has been removed and its controlling variable innodb_lazy_drop_table has been deprecated from Percona Server 5.5.30-30.2. Feature has been removed because the upstream DROP TABLE implementation has been improved when bugs #56332 and #51325 were fixed.
[4](1, 2, 3) Feature has been deprecated after Percona Server 5.1.66-14.2 and Percona Server 5.5.28-29.2. It has been replaced by the upstream innodb_checksum_algorithm implementation released in MySQL 5.6.3.
[5]Feature has been replaced by the upstream implementation innodb-performance-thread_concurrency in MySQL 5.6
[6]Feature will be implemented in one of the future Percona Server 5.6 releases.
[7]Binary Log Group Commit feature has been replaced with the MySQL 5.6 implementation.
[8](1, 2, 3) Feature has been deprecated in the Percona Server 5.1.68-14.6 and Percona Server 5.5.30-30.2. It has been replaced by the upstream innodb_page_size version released in MySQL 5.6.4.
[9]Feature has been replaced by the MySQL 5.6 binary-mode configuration option.
[10]Feature has been replaced by the MySQL 5.6 relay-log-recovery implementation.
[11]Feature has been replaced by the MySQL 5.6 table_definition_cache implementation.
[12]Feature has been replaced by the MySQL 5.6 Improved Tablespace Management implementation.
[13]Feature has been replaced by the MySQL 5.6 preloading the InnoDB buffer pool at startup implementation.
[14]Feature has been replaced by the 5.6’ ALGORITHM= option implementation.
[15]Feature has been replaced by the MySQL 5.6 Persistent Optimizer Statistics for InnoDB Tables implementation.
Download PDF Manual

Table Of Contents

This Page

Percona Server Series

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 professional services, contact Percona Sales.