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.6.13 MySQL 5.6.13
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
Extra Features for Developers Percona Server 5.6.13 MySQL 5.6.13
NoSQL Socket-Level Interface Yes Yes
Extra Hash/Digest Functions Yes  
Extra Diagnostic Features Percona Server 5.6.13 MySQL 5.6.13
INFORMATION_SCHEMA Tables 70 59
Global Performance and Status Counters 398 341
Per-Table Performance Counters Yes  
Per-Index Performance Counters Yes  
Per-User Performance Counters Yes  
Per-Client Performance Counters Yes  
Per-Thread Performance Counters Yes  
Global Query Response Time Statistics Yes  
InnoDB Data Dictionary as I_S Tables Yes  
Access to InnoDB Data Statistics Yes  
Enhanced SHOW ENGINE INNODB STATUS Yes  
Enhanced Mutex Diagnostics Yes  
Undo Segment Information Yes  
Performance & Scalability Enhancements Percona Server 5.6.13 MySQL 5.6.13
Fine-Grained Mutex Locking Yes  
Lock-Free Algorithms Yes  
Improved MEMORY Storage Engine Yes  
Partitioned Adaptive Hash Search Yes  
Support for FlashCache Yes  
Read-Ahead Improvements Yes  
Extra Features for DBA/Operations Staff Percona Server 5.6.13 MySQL 5.6.13
Configurable Page Sizes Yes Yes
Configurable Insert Buffer Size Yes  
Error/Warning Logging Enhancements Yes  
Configurable Fast Index Creation Yes  
Support for Fake Changes Yes  
Changed Page Tracking Yes  
PAM Authentication Yes Yes [1]
Threadpool Yes Yes [1]
Log Archiving Yes  
Running Database as a Service Percona Server 5.6.13 MySQL 5.6.13
Special Utility User Yes  
Expanded Program Option Modifiers Yes  
Extended secure-file-priv option Yes  
Enforcing the Specific Storage Engine Yes  
[1](1, 2) Feature available in Enterprise version only
Percona Server

Previous topic

List of features available in Percona Server releases

Next topic

Changed in Percona Server 5.6

This Page

© Copyright Percona LLC and/or its affiliates 2009-2014.
Except where otherwise noted, this documentation is licensed under the following license:
CC Attribution-ShareAlike 2.0 Generic
Created using Sphinx 1.2.2.
This documentation is developed in Launchpad as part of the Percona Server source code.
If you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.