=====================================
 |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                  |              |
+---------------------------------------+----------------------+--------------+