| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 3,122 k | 936.4 k | 88.39 |
| show fields | 86,649 | 26 k | 2.45 |
| show tables | 81,113 | 24.3 k | 2.30 |
| show keys | 62,112 | 18.6 k | 1.76 |
| change db | 61,509 | 18.4 k | 1.74 |
| set option | 45,400 | 13.6 k | 1.29 |
| show variables | 23,839 | 7,148.7 | 0.67 |
| show grants | 14,494 | 4,346.4 | 0.41 |
| show create table | 12,242 | 3,671.1 | 0.35 |
| show warnings | 11,308 | 3,391 | 0.32 |
| replace | 5,378 | 1,612.7 | 0.15 |
| show create proc | 1,970 | 590.8 | 0.06 |
| show create func | 1,671 | 501.1 | 0.05 |
| show storage engines | 665 | 199.4 | 0.02 |
| create table | 549 | 164.6 | 0.02 |
| show binlogs | 526 | 157.7 | 0.01 |
| stmt close | 171 | 51.3 | <0.01 |
| stmt execute | 171 | 51.3 | <0.01 |
| stmt prepare | 171 | 51.3 | <0.01 |
| show slave status | 68 | 20.4 | <0.01 |
| show binlog status | 62 | 18.6 | <0.01 |
| show table status | 61 | 18.3 | <0.01 |
| insert | 52 | 15.6 | <0.01 |
| delete | 47 | 14.1 | <0.01 |
| show status | 20 | 6 | <0.01 |
| update | 4 | 1.2 | <0.01 |
| flush | 1 | 0.3 | <0.01 |
| show engine status | 1 | 0.3 | <0.01 |
| show processlist | 1 | 0.3 | <0.01 |