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.7.27 |
MySQL 5.7.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 |
GTID Replication |
Yes |
Yes |
Group Replication |
Yes |
Yes |
MyRocks Storage Engine |
Yes |
No |
TokuDB Storage Engine |
Yes |
No |
Extra Features for Developers |
Percona Server 5.7.27 |
MySQL 5.7.27 |
NoSQL Socket-Level Interface |
Yes |
Yes |
X API Support |
Yes |
Yes |
InnoDB Full-Text Search Improvements |
Yes |
No |
Extra Hash/Digest Functions |
Yes |
No |
Instrumentation and Troubleshooting Features |
Percona Server 5.7.27 |
MySQL 5.7.27 |
INFORMATION_SCHEMA Tables |
71 |
61 |
Global Performance and Status Counters |
432 |
357 |
Per-Table Performance Counters |
Yes |
No |
Per-Index Performance Counters |
Yes |
No |
Per-User Performance Counters |
Yes |
No |
Per-Client Performance Counters |
Yes |
No |
Per-Thread Performance Counters |
Yes |
No |
Global Query Reponse Time Statistics |
Yes |
No |
Enhanced SHOW ENGINE INNODB STATUS |
Yes |
No |
Undo Segment Information |
Yes |
No |
Temporary Tables Information |
Yes |
No |
Extended Slow Query Logging |
Yes |
No |
User Statistics |
Yes |
No |
Performance and Scalability Features |
Percona Server 5.7.27 |
MySQL 5.7.27 |
Improved scalability by splitting mutexes |
Yes |
No |
Improved MEMORY Storage Engine |
Yes |
No |
Improved Flushing |
Yes |
No |
Parallel Doublewrite Buffer |
Yes |
No |
Configurable Page Sizes |
Yes |
Yes |
Configurable Fast Index Creation |
Yes |
No |
Per-column Compression for VARCHAR/BLOB and JSON |
Yes |
No |
Compressed columns with Dictionaries |
Yes |
No |
Security Features |
Percona Server 5.7.27 |
MySQL 5.7.27 |
PAM Authentication Plugin |
Yes |
Enterprise-Only |
Audit Logging Plugin |
Yes |
Enterprise-only |
Encryption Features |
Percona Server 5.7.27 |
MySQL 5.7.27 |
Encrypt InnodDB data |
Yes |
Yes |
Encrypt InnoDB tablespaces |
Experimental |
No |
Encrypt InnoDB logs |
Experimental |
No |
Encrypt Binary logs |
Experimental |
No |
Encrypt temporary files |
Experimental |
No |
Key Rotation |
Experimental |
No |
Scrubbing |
Experimental |
No |
Enforce Encryption |
Experimental |
No |
Storing Keyring in a file |
Yes |
Yes |
Storing Keyring in a Hashicorp Vault |
Yes |
No |
Operational Improvements |
Percona Server 5.7.27 |
MySQL 5.7.27 |
Changed Page Tracking |
Yes |
Yes |
Threadpool |
Yes |
Enterprise-only |
Backup Locks |
Yes |
No |
Extended SHOW GRANTS |
Yes |
No |
Improved Handling of Corrupted Tables |
Yes |
No |
Ability to kill Idle Transactions |
Yes |
No |
Improvements to START TRANSACTION WITH CONSISTENT SNAPSHOT |
Yes |
No |
Features for Running Database as a Service (DBaaS) |
Percona Server 5.7.27 |
MySQL 5.7.27 |
Special Utility User |
Yes |
No |
Enforce a Specific Storage Engine |
Yes |
No |
Expanded Program Option Modifiers |
Yes |
No |