Skip to content
logo
Percona Server for MySQL
Percona Server for MySQL feature comparison
Initializing search
    percona/psmysql-docs
    percona/psmysql-docs
    • Home
      • The Percona XtraDB storage engine
      • List of features available in Percona Server for MySQL releases
      • Percona Server for MySQL feature comparison
      • Changed in Percona Server 8.0
      • Understand version numbers
      • Install Percona Server for MySQL
        • Install using APT repository
        • Files in DEB package
        • Build APT packages
        • Install from downloaded DEB packages
        • Apt pinning
        • Run Percona Server for MySQL
        • Uninstall
        • Install using a RPM repository
        • Files in RPM package
        • Install from downloaded RPM packages
        • Run Percona Server for MySQL
        • Uninstall
        • Install with binary tarballs
        • Binary tarballs available
        • Install Percona Server for MySQL from a source tarball
        • Compile Percona Server for MySQL 8.0 from source
      • Post-installation
      • Percona Server for MySQL in-place upgrading guide: from 5.7 to 8.0
      • Upgrade using the Percona repositories
      • Upgrade from systems that use the MyRocks or TokuDB storage engine and partitioned tables
      • Upgrade using Standalone Packages
      • Downgrade Percona Server for MySQL
      • Running Percona Server for MySQL in a Docker Container
      • Docker environment variables
      • Improved InnoDB I/O scalability
      • Adaptive network buffers
      • Multiple page asynchronous I/O requests
      • Thread pool
      • XtraDB performance improvements for I/O-bound highly-concurrent workloads
      • Prefix index queries optimization
      • Limit the estimation of records in a Query
      • Jemalloc memory allocation profiling
      • The ProcFS plugin
      • Binary logs and replication improvements
      • Compressed columns with dictionaries
      • Extended SELECT INTO OUTFILE/DUMPFILE
      • Extended SET VAR optimizer hint
      • Improved MEMORY storage engine
      • Suppress warning messages
      • Limiting the disk space used by binary log files
      • Support for PROXY protocol
      • SEQUENCE_TABLE(n) function
      • Slow query log rotation and expiration
      • Trigger updates
      • Extended mysqlbinlog
      • Extended mysqldump
      • InnoDB full-text search improvements
      • Too many connections warning
      • Handle corrupted tables
      • Percona Toolkit UDFs
      • Kill idle transactions
      • XtraDB changed page tracking
      • Enforcing storage engine
      • Expanded fast index creation
      • Backup locks
      • Audit log plugin
      • Start transaction with consistent snapshot
      • Extended SHOW GRANTS
      • Utility user
      • Working with SELinux
      • Working with AppArmor
      • PAM authentication plugin
      • Server variables
      • SSL improvements
      • Data masking
        • Using LDAP authentication plugins
        • LDAP authentication plugin system variables
        • Data at Rest Encryption
        • Use the keyring component or keyring plugin
          • Using the Key Management Interoperability Protocol (KMIP)
          • Use the Amazon Key Management Service (AWS KMS)
          • FIDO authentication plugin
        • Encryption functions
        • Encrypt File-Per-Table Tablespace
        • Encrypt schema or general tablespace
        • Encrypt system tablespace
        • Encrypt temporary files
        • Encrypt Binary Log Files and Relay Log Files
        • Encrypting the Redo Log data
        • Encrypt the undo tablespace
        • Rotate the master key
        • Advanced encryption key rotation
        • Encrypt doublewrite buffers
        • Verify the encryption for tables, tablespaces, and schemas
      • User statistics
      • Slow query log
      • Extended show engine InnoDB status
      • Show storage engines
      • Process list
      • Misc. INFORMATION_SCHEMA tables
      • Thread based profiling
      • InnoDB page fragmentation counters
      • Stacktrace
      • Libcoredumper
      • Manage group replication flow control
      • Group replication system variables
      • Percona MyRocks introduction
      • Percona MyRocks installation guide
      • Updated supported features
      • MyRocks limitations
      • Differences between Percona MyRocks and Facebook MyRocks
      • MyRocks Information Schema tables
      • MyRocks server variables
      • MyRocks status variables
      • Gap locks detection
      • Data loading
      • Installing and configuring Percona Server for MySQL with ZenFS support
      • TokuDB introduction
      • TokuDB installation
      • Use TokuDB
      • Fast updates with TokuDB
      • TokuDB files and file types
      • TokuDB file management
      • TokuDB background ANALYZE TABLE
      • TokuDB variables
      • TokuDB status variables
      • TokuDB fractal tree indexing
      • TokuDB troubleshooting
      • TokuDB Performance Schema integration
      • Frequently asked questions
      • Migrate and removing the TokuDB storage engine
      • Percona TokuBackup
      • Release notes index
      • Percona Server for MySQL 8.0.32-24 (2023-03-20)
      • Percona Server for MySQL 8.0.31-23 (2023-02-09)
      • Percona Server for MySQL 8.0.30-22 Update (2022-11-21)
      • Percona Server for MySQL 8.0.30-22 (2022-11-21)
      • Percona Server for MySQL 8.0.29-21 (2022-08-08)
      • Percona Server for MySQL 8.0.28-20 (2022-06-20)
      • Percona Server for MySQL 8.0.28-19 (2022-05-12)
      • Percona Server for MySQL 8.0.27-18 (2022-03-02)
      • Percona Server for MySQL 8.0.26-17 (2022-01-26)
      • Percona Server for MySQL 8.0.26-16 (2021-10-20)
      • Percona Server for MySQL 8.0.25-15 (2021-07-13)
      • Percona Server for MySQL 8.0.23-14 (2021-05-12)
      • Percona Server for MySQL 8.0.22-13 (2020-12-14)
      • Percona Server for MySQL 8.0.21-12 (2020-10-13)
      • Percona Server for MySQL 8.0.20-11 (2020-07-21)
      • Percona Server for MySQL 8.0.19-10 (2020-03-23)
      • Percona Server for MySQL 8.0.18-9
      • Percona Server for MySQL 8.0.17-8
      • Percona Server for MySQL 8.0.16-7
      • Percona Server for MySQL 8.0.15-6
      • Percona Server for MySQL 8.0.15-5
      • Percona Server for MySQL 8.0.14
      • Percona Server for MySQL 8.0.13-4
      • Percona Server for MySQL 8.0.13-3
      • Percona Server for MySQL 8.0.12-2rc1
      • List of variables introduced in Percona Server for MySQL 8.0
      • Development of Percona Server for MySQL
      • Trademark policy
      • Index of INFORMATION_SCHEMA tables
      • Frequently asked questions
      • Copyright and licensing information
      • Glossary

    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

    Contact us

    For free technical help, visit the Percona Community Forum.

    To report bugs or submit feature requests, open a JIRA ticket.

    For paid support and managed or consulting services , contact Percona Sales.


    Last update: 2023-02-09
    Percona LLC and/or its affiliates, © 2023
    Made with Material for MkDocs

    Cookie consent

    We use cookies to recognize your repeated visits and preferences, as well as to measure the effectiveness of our documentation and whether users find what they're searching for. With your consent, you're helping us to make our documentation better.