Percona Server Feature Comparison ® Percona Server is a free, fully compatible, enhanced, open source drop-in replacement for MySQL® that provides superior performance, scalability and instrumentation.
With Percona Server, you will:
- Run faster and more consistent queries
- Consolidate servers on powerful hardware
- Delay sharding, or avoid it entirely
- Save money on hosting fees and power
- Spend less time tuning and administering
- Achieve higher uptime
“Percona Server is fantastic. Queries run faster and more consistently, tuning and administration is easier, and we are experiencing extremely high uptimes.”
| Feature | Percona Server 5.7.10 | MySQL 5.7.10 |
|---|---|---|
| Open source | ||
| ACID Compliance | ||
| Multi-Version Concurrency Control | ||
| Row-Level Locking | ||
| Automatic Crash Recovery | ||
| Table Partitioning | ||
| Views | ||
| Subqueries | ||
| Triggers | ||
| Stored Procedures | ||
| Foreign Keys | ||
| GTID Replication | ||
| TokuDB | ||
| Extra Features for Developers | Percona Server 5.7.10 | MySQL 5.7.10 |
| NoSQL Socket-Level Interface | ||
| Extra Hash/Digest Functions | ||
| Extra Diagnostic Features | Percona Server 5.7.10 | MySQL 5.7.10 |
| INFORMATION_SCHEMA Tables | 75 | 61 |
| Global Performance and Status Counters | 385 | 355 |
| Per-Table Performance Counters | ||
| Per-Index Performance Counters | ||
| Per-User Performance Counters | ||
| Per-Client Performance Counters | ||
| Per-Thread Performance Counters | ||
| Global Query Response Time Statistics | ||
| Enhanced SHOW ENGINE INNODB STATUS | ||
| Undo Segment Information | ||
| Temporary tables Information | ||
| Performance & Scalability Enhancements | Percona Server 5.7.10 | MySQL 5.7.10 |
| Improved scalability by splitting mutexes | ||
| Improved MEMORY Storage Engine | ||
| Improved Flushing | ||
| Extra Features for DBA/Operations Staff | Percona Server 5.7.10 | MySQL 5.7.10 |
| Configurable Page Sizes | ||
| Configurable Fast Index Creation | ||
| Changed Page Tracking | ||
| PAM Authentication | (Enterprise Only) | |
| Threadpool | (Enterprise Only) | |
| Backup Locks | ||
| Extended SHOW GRANTS | ||
| Improved Handling of Corrupted Tables | ||
| Ability to Kill Idle Transactions | ||
| START TRANSACTION WITH CONSISTENT SNAPSHOT improvements | ||
| Running Database as a Service | Percona Server 5.7.10 | MySQL 5.7.10 |
| Special Utility User | ||
| Expanded Program Option Modifiers | ||
| Enforcing the Specific Storage Engine |
How Percona Can Help
Percona Consulting can help you determine if Percona Server is the right solution for your company and if it is, help deploy Percona Server, while ensuring optimal performance. Percona Support can ensure your deployment runs as expected and help you in a crisis. If you lack the resources to manage your deployment, our Managed Services team can take over the full operation of your database.
To discuss how Percona Managed Services can help you make your deployment a success, please call us at +1-888-316-9775 (USA), +44-208-133-0309 (Europe), or have us reach out to you:
Contact me!