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