Percona Server Feature Comparison

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

  • 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 as compared to the standard MySQL database server:

Features Percona Server 5.1.65 MySQL 5.1.65
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
Extra Features for Developers Percona Server 5.1.65 MySQL 5.1.65
NoSQL Socket-Level Interface Yes  
Extra Hash/Digest Functions Yes  
Extra Diagnostic Features Percona Server 5.1.65 MySQL 5.1.65
Global Performance and Status Counters 304 291
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  
High-Resolution Process List Timing Yes  
Detailed Query Execution and Plan Log 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  
Durability and Reliability Enhancements Percona Server 5.1.65 MySQL 5.1.65
Transactional Replication State Yes  
Handles Corrupted Tables Gracefully Yes  
Performance & Scalability Enhancements Percona Server 5.1.65 MySQL 5.1.65
Support for Multiple I/O Threads Yes  
Dedicated Purge Threads Yes  
Self-Tuning Checkpoint Algorithm Yes  
Fine-Grained Mutex Locking Yes  
Lock-Free Algorithms Yes  
Partitioned Adaptive Hash Search Yes  
Separate Doublewrite File Yes  
Fast Checksum Algorithm Yes  
Buffer Pool Pre-Load Yes  
Fast Shut-Down Yes  
Support for FlashCache Yes  
Read-Ahead Improvements Yes  
Extra Features for DBA/Operations Staff Percona Server 5.1.65 MySQL 5.1.65
Configurable Page Sizes Yes  
Import Tables From Different Servers Yes  
Configurable Data Dictionary Size Yes  
Configurable Insert Buffer Size Yes  
Active Change Buffer Purging Yes  
Error/Warning Logging Enhancements Yes  
Configurable Fast Index Creation Yes  
Extended mysqlbinlog Utility Yes  
Changed Page Tracking Yes  

Previous topic

Percona Server - Documentation

Next topic

The Percona XtraDB Storage Engine

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.