1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
|
=====================================
|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.5.20 |MySQL 5.5.20 |
+=======================================+======================+==============+
|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.5.20 |MySQL 5.5.20 |
+=======================================+======================+==============+
|NoSQL Socket-Level Interface | Yes | |
+---------------------------------------+----------------------+--------------+
|Extra Hash/Digest Functions | Yes | |
+---------------------------------------+----------------------+--------------+
+---------------------------------------+----------------------+--------------+
|Extra Diagnostic Features |Percona Server 5.5.20 |MySQL 5.5.20 |
+=======================================+======================+==============+
|INFORMATION_SCHEMA Tables | 60 | 37 |
+---------------------------------------+----------------------+--------------+
|Global Performance and Status Counters | 370 | 310 |
+---------------------------------------+----------------------+--------------+
|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.5.20 |MySQL 5.5.20 |
+=======================================+======================+==============+
|Transactional Replication State | Yes | |
+---------------------------------------+----------------------+--------------+
|Handles Corrupted Tables Gracefully | Yes | |
+---------------------------------------+----------------------+--------------+
+---------------------------------------+----------------------+--------------+
|Performance & Scalability Enhancements |Percona Server 5.5.20 |MySQL 5.5.20 |
+=======================================+======================+==============+
|Support for Multiple I/O Threads | Yes | Yes |
+---------------------------------------+----------------------+--------------+
|Dedicated Purge Thread | Yes | Yes |
+---------------------------------------+----------------------+--------------+
|Self-Tuning Checkpoint Algorithm | Yes | |
+---------------------------------------+----------------------+--------------+
|Fine-Grained Mutex Locking | Yes | |
+---------------------------------------+----------------------+--------------+
|Lock-Free Algorithms | Yes | |
+---------------------------------------+----------------------+--------------+
|Improved MEMORY Storage Engine | Yes | |
+---------------------------------------+----------------------+--------------+
|Partitioned Adaptive Hash Search | Yes | |
+---------------------------------------+----------------------+--------------+
|Separate Doublewrite File | Yes | |
+---------------------------------------+----------------------+--------------+
|Fast Checksum Algorithm | Yes | |
+---------------------------------------+----------------------+--------------+
|Buffer Pool Pre-Load | Yes | |
+---------------------------------------+----------------------+--------------+
|Fast Shut-Down | Yes | |
+---------------------------------------+----------------------+--------------+
|Background Table Drop | Yes | |
+---------------------------------------+----------------------+--------------+
|Support for FlashCache | Yes | |
+---------------------------------------+----------------------+--------------+
|Read-Ahead Improvements | Yes | |
+---------------------------------------+----------------------+--------------+
+---------------------------------------+----------------------+--------------+
|Extra Features for DBA/Operations Staff|Percona Server 5.5.20 |MySQL 5.5.20 |
+=======================================+======================+==============+
|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 | |
+---------------------------------------+----------------------+--------------+
|Fast Index Renaming | Yes | |
+---------------------------------------+----------------------+--------------+
|Support for Fake Changes | Yes | |
+---------------------------------------+----------------------+--------------+
|