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 | PS 8.0.13 | MySQL 8.0.13 |
|---|---|---|
| Open Source | ||
| ACID Compliance | ||
| Multi-Version Concurrency Control | ||
| Row-Level Locking | ||
| Automatic Crash Recovery | ||
| Table Partitioning | ||
| Views | ||
| Subqueries | ||
| Triggers | ||
| Stored Procedures | ||
| Foreign Keys | ||
| Window Functions | ||
| Common Table Expressions | ||
| Geospatial Features (GIS, SRS) | ||
| GTID Replication | ||
| Group Replication | ||
| MyRocks Storage Engine | ||
| TokuDB Storage Engine | ||
| Improvements for Developers | PS 8.0.13 | MySQL 8.0.13 |
| NoSQL Socket-Level Interface | ||
| X API Support | ||
| JSON Functions | ||
| InnoDB Full-Text Search Improvements | ||
| Extra Hash/Digest Functions | ||
| Instrumentation and Troubleshooting Features | PS 8.0.13 | MySQL 8.0.13 |
| INFORMATION_SCHEMA Tables | 95 | 65 |
| Global Performance and Status Counters | 853 | 434 |
| Optimizer Histograms | ||
| 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 INNODB ENGINE STATUS | ||
| Undo Segment Information | ||
| Temporary Tables Information | ||
| Extended Slow Query Logging | ||
| User Statistics | ||
| Performance and Scalability Features | PS 8.0.13 | MySQL 8.0.13 |
| InnoDB Resource Groups | ||
| Configurable Page Sizes | ||
| Contention-Aware Transaction Scheduling | ||
| Improved Scalability By Splitting Mutexes | ||
| Improved MEMORY Storage Engine | ||
| Improved Flushing | ||
| Parallel Doublewrite Buffer | ||
| Configurable Fast Index Creation | ||
| Per-Column Compression for VARCHAR/BLOB and JSON | ||
| Compressed Columns with Dictionaries | ||
| Security Features | PS 8.0.13 | MySQL 8.0.13 |
| SQL Roles | ||
| SHA-2 Based Password Hashing | ||
| Password Rotation Policy | ||
| PAM Authentication Plugin | (Enterprise-Only) | |
| Audit Logging Plugin | (Enterprise-Only) | |
| Encryption Features | PS 8.0.13 | MySQL 8.0.13 |
| Storing Keyring in a File | ||
| Storing Keyring in Hashicorp Vault | (Enterprise Only) | |
| Encrypt InnoDB Data | ||
| Encrypt InnoDB Logs | ||
| Encrypt Built-In InnoDB Tablespaces (General, System, Undo, Temp) | ||
| Encrypt Binary Logs | ||
| Encrypt Temporary Files | ||
| Key Rotation with Scrubbing | ||
| Enforce Encryption | ||
| Operational Improvements | PS 8.0.13 | MySQL 8.0.13 |
| Atomic DDL | ||
| Transactional Data Dictionary | ||
| Instant DDL | ||
| SET PERSIST | ||
| Invisible Indexes | ||
| Changed Page Tracking | ||
| Threadpool | (Enterprise-Only) | |
| Backup Locks | ||
| Extended SHOW GRANTS | ||
| Improved Handling of Corrupted Tables | ||
| Ability to Kill Idle Transactions | ||
| Improvements to START TRANSACTION WITH CONSISTENT SNAPSHOT | ||
| Features for Running Database as a Service (DBaaS) | PS 8.0.13 | MySQL 8.0.13 |
| Enforce a Specific Storage Engine |