Skip to content

Percona Server for MySQL feature comparison

Percona Server for MySQL is a free, fully compatible, enhanced, and open source drop-in replacement for any MySQL database. It provides superior performance, scalability, and instrumentation.

Percona Server for MySQL is trusted by thousands of enterprises to provide better performance and concurrency for their most demanding workloads. It delivers higher value to MySQL server users with optimized performance, greater performance scalability and availability, enhanced backups, and increased visibility.

We provide these benefits by significantly enhancing Percona Server for MySQL as compared to the standard MySQL database server:

Features Percona Server for MySQL 8.0.30 MySQL 8.0.30
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
Window Functions Yes Yes
Common Table Expressions Yes Yes
Geospatial Features (GIS, SRS) Yes Yes
GTID Replication Yes Yes
Group Replication Yes Yes
MyRocks Storage Engine Yes No
Improvements for Developers Percona Server for MySQL 8.0.30 MySQL 8.0.30
NoSQL Socket-Level Interface Yes Yes
X API Support Yes Yes
JSON Functions Yes Yes
InnoDB Full-Text Search Improvements Yes No
Extra Hash/Digest Functions Yes No
Instrumentation and Troubleshooting Features Percona Server for MySQL 8.0.30 MySQL 8.0.30
INFORMATION_SCHEMA Tables 95 65
Global Performance and Status Counters 853 434
Optimizer Histograms Yes Yes
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 INNODB ENGINE 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 for MySQL 8.0.30 MySQL 8.0.30
InnoDB Resource Groups Yes Yes
Configurable Page Sizes Yes Yes
Contention-Aware Transaction Scheduling Yes Yes
Improved Scalability By Splitting Mutexes Yes No
Improved MEMORY Storage Engine Yes No
Improved Flushing Yes No
Parallel Doublewrite Buffer 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 for MySQL 8.0.30 MySQL 8.0.30
SQL Roles Yes Yes
SHA-2 Based Password Hashing Yes Yes
Password Rotation Policy Yes Yes
PAM Authentication Plugin Yes Enterprise-Only
Audit Logging Plugin Yes Enterprise-Only
Encryption Features Percona Server for MySQL 8.0.30 MySQL 8.0.30
Storing Keyring in a File Yes Yes
Storing Keyring in Hashicorp Vault Yes Enterprise Only
Encrypt InnoDB Data Yes Yes
Encrypt InnoDB Logs Yes Yes
Encrypt Built-In InnoDB Tablespaces (General, System, Undo, Temp) Yes Yes
Encrypt Binary Logs Yes No
Encrypt Temporary Files Yes No
Enforce Encryption Yes No
Operational Improvements Percona Server for MySQL 8.0.30 MySQL 8.0.30
Atomic DDL Yes Yes
Transactional Data Dictionary Yes Yes
Instant DDL Yes Yes
SET PERSIST Yes Yes
Invisible Indexes 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 for MySQL 8.0.30 MySQL 8.0.30
Enforce a Specific Storage Engine Yes Yes

Get expert help

If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.


Last update: 2024-05-28