Percona Server for MySQL Feature Comparison

Percona Server for MySQL is an enhanced drop-in replacement for MySQL. With Percona Server for MySQL,

  • Your queries will run faster and more consistently.
  • You will consolidate servers on powerful hardware.
  • You will delay sharding, or avoid it entirely.
  • You will save money on hosting fees and power.
  • You will spend less time tuning and administering.
  • You will achieve higher uptime.
  • You will troubleshoot without guesswork.

We provide these benefits by significantly enhancing Percona Server for MySQL as compared to the standard MySQL database server:

Features Percona Server 5.6.13 MySQL 5.6.13
Open source Yes Yes
ACID Compliance Yes Yes
Multi-Version Concurrency Control Yes Yes
Row-Level Locking Yes Yes
Automatic Crash Recovery Yes Yes
Table Partitioning Yes Yes
Views Yes Yes
Subqueries Yes Yes
Triggers Yes Yes
Stored Procedures Yes Yes
Foreign Keys Yes Yes
GTID Replication Yes Yes
Extra Features for Developers Percona Server 5.6.13 MySQL 5.6.13
NoSQL Socket-Level Interface Yes Yes
Extra Hash/Digest Functions Yes  
Extra Diagnostic Features Percona Server 5.6.13 MySQL 5.6.13
Global Performance and Status Counters 398 341
Per-Table Performance Counters Yes  
Per-Index Performance Counters Yes  
Per-User Performance Counters Yes  
Per-Client Performance Counters Yes  
Per-Thread Performance Counters Yes  
Global Query Response Time Statistics Yes  
InnoDB Data Dictionary as I_S Tables Yes  
Access to InnoDB Data Statistics Yes  
Enhanced Mutex Diagnostics Yes  
Undo Segment Information Yes  
Performance & Scalability Enhancements Percona Server 5.6.13 MySQL 5.6.13
Fine-Grained Mutex Locking Yes  
Lock-Free Algorithms Yes  
Improved MEMORY Storage Engine Yes  
Partitioned Adaptive Hash Search Yes  
Support for FlashCache Yes  
Read-Ahead Improvements Yes  
Extra Features for DBA/Operations Staff Percona Server 5.6.13 MySQL 5.6.13
Configurable Page Sizes Yes Yes
Configurable Insert Buffer Size Yes  
Error/Warning Logging Enhancements Yes  
Configurable Fast Index Creation Yes  
Support for Fake Changes Yes  
Changed Page Tracking Yes  
PAM Authentication Yes Yes [1]
Threadpool Yes Yes [1]
Log Archiving Yes  
Running Database as a Service Percona Server 5.6.13 MySQL 5.6.13
Special Utility User Yes  
Expanded Program Option Modifiers Yes  
Extended secure-file-priv option Yes  
Enforcing the Specific Storage Engine Yes  
[1](1, 2) Feature available in Enterprise version only

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.