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