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 |