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.1.65 MySQL 5.1.65
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
Extra Features for Developers Percona Server 5.1.65 MySQL 5.1.65
NoSQL Socket-Level Interface Yes  
Extra Hash/Digest Functions Yes  
Extra Diagnostic Features Percona Server 5.1.65 MySQL 5.1.65
INFORMATION_SCHEMA Tables 54 28
Global Performance and Status Counters 304 291
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  
High-Resolution Process List Timing Yes  
Detailed Query Execution and Plan Log Yes  
Global Query Response Time Statistics Yes  
InnoDB Data Dictionary as I_S Tables Yes  
Access to InnoDB Data Statistics Yes  
Enhanced SHOW INNODB STATUS Yes  
Enhanced Mutex Diagnostics Yes  
Durability and Reliability Enhancements Percona Server 5.1.65 MySQL 5.1.65
Transactional Replication State Yes  
Handles Corrupted Tables Gracefully Yes  
Performance & Scalability Enhancements Percona Server 5.1.65 MySQL 5.1.65
Support for Multiple I/O Threads Yes  
Dedicated Purge Threads Yes  
Self-Tuning Checkpoint Algorithm Yes  
Fine-Grained Mutex Locking Yes  
Lock-Free Algorithms Yes  
Partitioned Adaptive Hash Search Yes  
Separate Doublewrite File Yes  
Fast Checksum Algorithm Yes  
Buffer Pool Pre-Load Yes  
Fast Shut-Down Yes  
Support for FlashCache Yes  
Read-Ahead Improvements Yes  
Extra Features for DBA/Operations Staff Percona Server 5.1.65 MySQL 5.1.65
Configurable Page Sizes Yes  
Import Tables From Different Servers Yes  
Configurable Data Dictionary Size Yes  
Configurable Insert Buffer Size Yes  
Active Change Buffer Purging Yes  
Error/Warning Logging Enhancements Yes  
Configurable Fast Index Creation Yes  
Extended mysqlbinlog Utility Yes  
Changed Page Tracking Yes  
Percona Server
Call Us
+1-888-316-9775 (USA - Sales)
+1-208-473-2904 (USA - Sales)
+44-208-133-0309 (UK - Sales)
0-800-051-8984 (UK - Sales)
0-800-181-0665 (GER - Sales)
+1-877-862-4316 (Emergency)
+1-855-55TRAIN (Training)
+1-925-271-5054 (Training)

Previous topic

Percona Server - Documentation

Next topic

The Percona XtraDB Storage Engine

This Page



© Copyright Percona LLC and/or its affiliates 2009-2013.
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.
]]>