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

---

Last update: 2022-09-27