Percona Server Feature Comparison

Percona Server is an enhanced drop-in replacement for MySQL. With Percona Server,

  • 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 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
[1]Feature available in Enterprise version only