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.5.27 |
MySQL 5.5.27 |
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.5.27 |
MySQL 5.5.27 |
NoSQL Socket-Level Interface |
Yes |
|
Extra Hash/Digest Functions |
Yes |
|
Extra Diagnostic Features |
Percona Server 5.5.27 |
MySQL 5.5.27 |
INFORMATION_SCHEMA Tables |
60 |
37 |
Global Performance and Status Counters |
370 |
310 |
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 SHOW ENGINE INNODB STATUS |
Yes |
|
Enhanced Mutex Diagnostics |
Yes |
|
Undo Segment Information |
Yes |
|
Durability and Reliability Enhancements |
Percona Server 5.5.27 |
MySQL 5.5.27 |
Transactional Replication State |
Yes |
|
Handles Corrupted Tables Gracefully |
Yes |
|
Performance & Scalability Enhancements |
Percona Server 5.5.27 |
MySQL 5.5.27 |
Support for Multiple I/O Threads |
Yes |
Yes |
Dedicated Purge Thread |
Yes |
Yes |
Self-Tuning Checkpoint Algorithm |
Yes |
|
Fine-Grained Mutex Locking |
Yes |
|
Lock-Free Algorithms |
Yes |
|
Improved MEMORY Storage Engine |
Yes |
|
Partitioned Adaptive Hash Search |
Yes |
|
Separate Doublewrite File |
Yes |
|
Fast Checksum Algorithm |
Yes |
|
Buffer Pool Pre-Load |
Yes |
|
Fast Shut-Down |
Yes |
|
Background Table Drop |
Yes |
|
Support for FlashCache |
Yes |
|
Read-Ahead Improvements |
Yes |
|
Extra Features for DBA/Operations Staff |
Percona Server 5.5.27 |
MySQL 5.5.27 |
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 |
|
Support for Fake Changes |
Yes |
|
Changed Page Tracking |
Yes |
|
Running Database as a Service |
Percona Server 5.5.27 |
MySQL 5.5.27 |
Special Utility User |
Yes |
|
Expanded Program Option Modifiers |
Yes |
|
Extended secure-file-priv option |
Yes |
|
Enforcing the Specific Storage Engine |
Yes |
|