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.. tabularcolumns:: |p{5cm}|p{5cm}|p{5cm}|
24
25.. list-table::
26    :header-rows: 1
27
28    * - Features
29      - Percona Server 5.7.27
30      - MySQL 5.7.27
31    * - Open source
32      - Yes
33      - Yes
34    * - ACID Compliance
35      - Yes
36      - Yes
37    * - Multi-Version Concurrency Control
38      - Yes
39      - Yes
40    * - Row-Level Locking
41      - Yes
42      - Yes
43    * - Automatic Crash Recovery
44      - Yes
45      - Yes
46    * - Table Partitioning
47      - Yes
48      - Yes
49    * - Views
50      - Yes
51      - Yes
52    * - Subqueries
53      - Yes
54      - Yes
55    * - Triggers
56      - Yes
57      - Yes
58    * - Stored Procedures
59      - Yes
60      - Yes
61    * - Foreign Keys
62      - Yes
63      - Yes
64    * - GTID Replication
65      - Yes
66      - Yes
67    * - Group Replication
68      - Yes
69      - Yes
70    * - MyRocks Storage Engine
71      - Yes
72      - No
73    * - TokuDB Storage Engine
74      - Yes
75      - No
76
77.. tabularcolumns:: |p{5cm}|p{5cm}|p{5cm}|
78
79.. list-table::
80   :header-rows: 1
81
82   * - Extra Features for Developers
83     - Percona Server 5.7.27
84     - MySQL 5.7.27
85   * - NoSQL Socket-Level Interface
86     - Yes
87     - Yes
88   * - X API Support
89     - Yes
90     - Yes
91   * - InnoDB Full-Text Search Improvements
92     - Yes
93     - No
94   * - Extra Hash/Digest Functions
95     - Yes
96     - No
97
98.. tabularcolumns:: |p{5cm}|p{5cm}|p{5cm}|
99
100.. list-table::
101   :header-rows: 1
102
103   * - Instrumentation and Troubleshooting Features
104     - Percona Server 5.7.27
105     - MySQL 5.7.27
106   * - INFORMATION_SCHEMA Tables
107     - 71
108     - 61
109   * - Global Performance and Status Counters
110     - 432
111     - 357
112   * - Per-Table Performance Counters
113     - Yes
114     - No
115   * - Per-Index Performance Counters
116     - Yes
117     - No
118   * - Per-User Performance Counters
119     - Yes
120     - No
121   * - Per-Client Performance Counters
122     - Yes
123     - No
124   * - Per-Thread Performance Counters
125     - Yes
126     - No
127   * - Global Query Reponse Time Statistics
128     - Yes
129     - No
130   * - Enhanced SHOW ENGINE INNODB STATUS
131     - Yes
132     - No
133   * - Undo Segment Information
134     - Yes
135     - No
136   * - Temporary Tables Information
137     - Yes
138     - No
139   * - Extended Slow Query Logging
140     - Yes
141     - No
142   * - User Statistics
143     - Yes
144     - No
145
146.. tabularcolumns:: |p{5cm}|p{5cm}|p{5cm}|
147
148.. list-table::
149   :header-rows: 1
150
151   * - Performance and Scalability Features
152     - Percona Server 5.7.27
153     - MySQL 5.7.27
154   * - Improved scalability by splitting mutexes
155     - Yes
156     - No
157   * - Improved MEMORY Storage Engine
158     - Yes
159     - No
160   * - Improved Flushing
161     - Yes
162     - No
163   * - Parallel Doublewrite Buffer
164     - Yes
165     - No
166   * - Configurable Page Sizes
167     - Yes
168     - Yes
169   * - Configurable Fast Index Creation
170     - Yes
171     - No
172   * - Per-column Compression for VARCHAR/BLOB and JSON
173     - Yes
174     - No
175   * - Compressed columns with Dictionaries
176     - Yes
177     - No
178
179.. tabularcolumns:: |p{5cm}|p{5cm}|p{5cm}|
180
181.. list-table::
182   :header-rows: 1
183
184   * - Security Features
185     - Percona Server 5.7.27
186     - MySQL 5.7.27
187   * - PAM Authentication Plugin
188     - Yes
189     - Enterprise-Only
190   * - Audit Logging Plugin
191     - Yes
192     - Enterprise-only
193
194.. tabularcolumns:: |p{5cm}|p{5cm}|p{5cm}|
195
196.. list-table::
197   :header-rows: 1
198
199   * - Encryption Features
200     - Percona Server 5.7.27
201     - MySQL 5.7.27
202   * - Encrypt InnodDB data
203     - Yes
204     - Yes
205   * - Encrypt InnoDB tablespaces
206     - Experimental
207     - No
208   * - Encrypt InnoDB logs
209     - Experimental
210     - No
211   * - Encrypt Binary logs
212     - Experimental
213     - No
214   * - Encrypt temporary files
215     - Experimental
216     - No
217   * - Key Rotation
218     - Experimental
219     - No
220   * - Scrubbing
221     - Experimental
222     - No
223   * - Enforce Encryption
224     - Experimental
225     - No
226   * - Storing Keyring in a file
227     - Yes
228     - Yes
229   * - Storing Keyring in a Hashicorp Vault
230     - Yes
231     - No
232
233.. tabularcolumns:: |p{5cm}|p{5cm}|p{5cm}|
234
235.. list-table::
236   :header-rows: 1
237
238   * - Operational Improvements
239     - Percona Server 5.7.27
240     - MySQL 5.7.27
241   * - Changed Page Tracking
242     - Yes
243     - Yes
244   * - Threadpool
245     - Yes
246     - Enterprise-only
247   * - Backup Locks
248     - Yes
249     - No
250   * - Extended SHOW GRANTS
251     - Yes
252     - No
253   * - Improved Handling of Corrupted Tables
254     - Yes
255     - No
256   * - Ability to kill Idle Transactions
257     - Yes
258     - No
259   * - Improvements to START TRANSACTION WITH CONSISTENT SNAPSHOT
260     - Yes
261     - No
262
263.. tabularcolumns:: |p{5cm}|p{5cm}|p{5cm}|
264
265.. list-table::
266   :header-rows: 1
267
268   * - Features for Running Database as a Service (DBaaS)
269     - Percona Server 5.7.27
270     - MySQL 5.7.27
271   * - Special Utility User
272     - Yes
273     - No
274   * - Enforce a Specific Storage Engine
275     - Yes
276     - No
277   * - Expanded Program Option Modifiers
278     - Yes
279     - No
280
281