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:

Feature	Percona Server 5.5.8	MySQL 5.5.8
Open source
ACID Compliance
Multi-Version Concurrency Control
Row-Level Locking
Automatic Crash Recovery
Table Partitioning
Views
Subqueries
Triggers
Stored Procedures
Foreign Keys
Extra Features for Developers	Percona Server 5.5.8	MySQL 5.5.8
NoSQL Socket-Level Interface
Extra Hash/Digest Functions
Extra Diagnostic Features	Percona Server 5.5.8	MySQL 5.5.8
PERFORMANCE_SCHEMA Diagnostics Tables
INFORMATION_SCHEMA Tables	60	37
Global Performance and Status Counters	366	308
Per-Table Performance Counters
Per-Index Performance Counters
Per-User Performance Counters
Per-Client Performance Counters
High-Resolution Process List Timing
Detailed Query Execution and Plan Log
Global Query Response Time Statistics
InnoDB Data Dictionary as I_S Tables
Access to InnoDB Data Statistics
Enhanced SHOW INNODB STATUS
Enhanced Mutex Diagnostics
Durability and Reliability Enhancements	Percona Server 5.5.8	MySQL 5.5.8
Transactional Replication State
Handles Corrupted Tables Gracefully
Performance & Scalability Enhancements	Percona Server 5.5.8	MySQL 5.5.8
Support for > 1024 Concurrent Transactions
Support for Multiple I/O Threads
Dedicated Purge Threads
Self-Tuning Checkpoint Algorithm
Fine-Grained Mutex Locking
Lock-Free Algorithms
Partitioned Adaptive Hash Search
Separate Doublewrite File
Fast Checksum Algorithm
Buffer Pool Pre-Load
Fast Shut-Down
Support for FlashCache
Read-Ahead Improvements
Extra Features for DBA/Operations Staff	Percona Server 5.5.8	MySQL 5.5.8
Configurable Page Sizes
Shared-Memory Buffer Pool
Import Tables From Different Servers
Configurable Data Dictionary Size
Configurable Insert Buffer Size
Active Change Buffer Purging
Error/Warning Logging Enhancements
Configurable Fast Index Creation
Fast Index Renaming