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 | ||
| 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 |
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!