1===================================== 2 |Percona Server| Feature Comparison 3===================================== 4 5|Percona Server| is an enhanced drop-in replacement for |MySQL|. With |Percona Server|, 6 7 * Your queries will run faster and more consistently. 8 9 * You will consolidate servers on powerful hardware. 10 11 * You will delay sharding, or avoid it entirely. 12 13 * You will save money on hosting fees and power. 14 15 * You will spend less time tuning and administering. 16 17 * You will achieve higher uptime. 18 19 * You will troubleshoot without guesswork. 20 21We provide these benefits by significantly enhancing |Percona Server| as compared to the standard |MySQL| database server: 22 23+---------------------------------------+----------------------+--------------+ 24|Features |Percona Server 5.6.13 |MySQL 5.6.13 | 25+=======================================+======================+==============+ 26|Open source | Yes | Yes | 27+---------------------------------------+----------------------+--------------+ 28|ACID Compliance | Yes | Yes | 29+---------------------------------------+----------------------+--------------+ 30|Multi-Version Concurrency Control | Yes | Yes | 31+---------------------------------------+----------------------+--------------+ 32|Row-Level Locking | Yes | Yes | 33+---------------------------------------+----------------------+--------------+ 34|Automatic Crash Recovery | Yes | Yes | 35+---------------------------------------+----------------------+--------------+ 36|Table Partitioning | Yes | Yes | 37+---------------------------------------+----------------------+--------------+ 38|Views | Yes | Yes | 39+---------------------------------------+----------------------+--------------+ 40|Subqueries | Yes | Yes | 41+---------------------------------------+----------------------+--------------+ 42|Triggers | Yes | Yes | 43+---------------------------------------+----------------------+--------------+ 44|Stored Procedures | Yes | Yes | 45+---------------------------------------+----------------------+--------------+ 46|Foreign Keys | Yes | Yes | 47+---------------------------------------+----------------------+--------------+ 48|GTID Replication | Yes | Yes | 49+---------------------------------------+----------------------+--------------+ 50 51+---------------------------------------+----------------------+--------------+ 52|Extra Features for Developers |Percona Server 5.6.13 |MySQL 5.6.13 | 53+=======================================+======================+==============+ 54|NoSQL Socket-Level Interface | Yes | Yes | 55+---------------------------------------+----------------------+--------------+ 56|Extra Hash/Digest Functions | Yes | | 57+---------------------------------------+----------------------+--------------+ 58 59+---------------------------------------+----------------------+--------------+ 60|Extra Diagnostic Features |Percona Server 5.6.13 |MySQL 5.6.13 | 61+=======================================+======================+==============+ 62|INFORMATION_SCHEMA Tables | 70 | 59 | 63+---------------------------------------+----------------------+--------------+ 64|Global Performance and Status Counters | 398 | 341 | 65+---------------------------------------+----------------------+--------------+ 66|Per-Table Performance Counters | Yes | | 67+---------------------------------------+----------------------+--------------+ 68|Per-Index Performance Counters | Yes | | 69+---------------------------------------+----------------------+--------------+ 70|Per-User Performance Counters | Yes | | 71+---------------------------------------+----------------------+--------------+ 72|Per-Client Performance Counters | Yes | | 73+---------------------------------------+----------------------+--------------+ 74|Per-Thread Performance Counters | Yes | | 75+---------------------------------------+----------------------+--------------+ 76|Global Query Response Time Statistics | Yes | | 77+---------------------------------------+----------------------+--------------+ 78|InnoDB Data Dictionary as I_S Tables | Yes | | 79+---------------------------------------+----------------------+--------------+ 80|Access to InnoDB Data Statistics | Yes | | 81+---------------------------------------+----------------------+--------------+ 82|Enhanced SHOW ENGINE INNODB STATUS | Yes | | 83+---------------------------------------+----------------------+--------------+ 84|Enhanced Mutex Diagnostics | Yes | | 85+---------------------------------------+----------------------+--------------+ 86|Undo Segment Information | Yes | | 87+---------------------------------------+----------------------+--------------+ 88 89+---------------------------------------+----------------------+--------------+ 90|Performance & Scalability Enhancements |Percona Server 5.6.13 |MySQL 5.6.13 | 91+=======================================+======================+==============+ 92|Fine-Grained Mutex Locking | Yes | | 93+---------------------------------------+----------------------+--------------+ 94|Lock-Free Algorithms | Yes | | 95+---------------------------------------+----------------------+--------------+ 96|Improved MEMORY Storage Engine | Yes | | 97+---------------------------------------+----------------------+--------------+ 98|Partitioned Adaptive Hash Search | Yes | | 99+---------------------------------------+----------------------+--------------+ 100|Support for FlashCache | Yes | | 101+---------------------------------------+----------------------+--------------+ 102|Read-Ahead Improvements | Yes | | 103+---------------------------------------+----------------------+--------------+ 104 105+---------------------------------------+----------------------+--------------+ 106|Extra Features for DBA/Operations Staff|Percona Server 5.6.13 |MySQL 5.6.13 | 107+=======================================+======================+==============+ 108|Configurable Page Sizes | Yes | Yes | 109+---------------------------------------+----------------------+--------------+ 110|Configurable Insert Buffer Size | Yes | | 111+---------------------------------------+----------------------+--------------+ 112|Error/Warning Logging Enhancements | Yes | | 113+---------------------------------------+----------------------+--------------+ 114|Configurable Fast Index Creation | Yes | | 115+---------------------------------------+----------------------+--------------+ 116|Support for Fake Changes | Yes | | 117+---------------------------------------+----------------------+--------------+ 118|Changed Page Tracking | Yes | | 119+---------------------------------------+----------------------+--------------+ 120|PAM Authentication | Yes | Yes [#n-1]_ | 121+---------------------------------------+----------------------+--------------+ 122|Threadpool | Yes | Yes [#n-1]_ | 123+---------------------------------------+----------------------+--------------+ 124|Log Archiving | Yes | | 125+---------------------------------------+----------------------+--------------+ 126 127 128+---------------------------------------+----------------------+--------------+ 129|Running Database as a Service |Percona Server 5.6.13 |MySQL 5.6.13 | 130+=======================================+======================+==============+ 131|Special Utility User | Yes | | 132+---------------------------------------+----------------------+--------------+ 133|Expanded Program Option Modifiers | Yes | | 134+---------------------------------------+----------------------+--------------+ 135|Extended ``secure-file-priv`` option | Yes | | 136+---------------------------------------+----------------------+--------------+ 137|Enforcing the Specific Storage Engine | Yes | | 138+---------------------------------------+----------------------+--------------+ 139 140.. [#n-1] Feature available in Enterprise version only 141