| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 1,350 k | 12.3 k | 70.18 |
| show tables | 86,654 | 792.1 | 4.50 |
| show fields | 83,297 | 761.4 | 4.33 |
| stmt prepare | 68,376 | 625 | 3.55 |
| stmt close | 68,375 | 625 | 3.55 |
| stmt execute | 68,375 | 625 | 3.55 |
| change db | 62,488 | 571.2 | 3.25 |
| set option | 47,009 | 429.7 | 2.44 |
| show keys | 40,108 | 366.6 | 2.08 |
| replace | 13,877 | 126.8 | 0.72 |
| show variables | 13,720 | 125.4 | 0.71 |
| show create table | 10,286 | 94 | 0.53 |
| show warnings | 5,733 | 52.4 | 0.30 |
| show storage engines | 2,392 | 21.9 | 0.12 |
| update | 1,704 | 15.6 | 0.09 |
| show table status | 484 | 4.4 | 0.03 |
| insert | 391 | 3.6 | 0.02 |
| show grants | 152 | 1.4 | 0.01 |
| show slave status | 127 | 1.2 | 0.01 |
| show master status | 122 | 1.1 | 0.01 |
| delete | 72 | 0.7 | <0.01 |
| show binlogs | 30 | 0.3 | <0.01 |
| alter table | 24 | 0.2 | <0.01 |
| begin | 24 | 0.2 | <0.01 |
| commit | 24 | 0.2 | <0.01 |
| show status | 24 | 0.2 | <0.01 |
| show processlist | 3 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |