| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 1,635 k | 306 k | 78.17 |
| show tables | 109 k | 20.3 k | 5.19 |
| show fields | 102 k | 19 k | 4.86 |
| change db | 75,463 | 14.1 k | 3.61 |
| set option | 56,037 | 10.5 k | 2.68 |
| show keys | 51,302 | 9,601.1 | 2.45 |
| replace | 17,658 | 3,304.7 | 0.84 |
| show variables | 16,733 | 3,131.6 | 0.80 |
| show create table | 12,432 | 2,326.6 | 0.59 |
| show warnings | 7,125 | 1,333.4 | 0.34 |
| show create proc | 2,666 | 498.9 | 0.13 |
| show storage engines | 2,387 | 446.7 | 0.11 |
| show create func | 2,241 | 419.4 | 0.11 |
| stmt close | 343 | 64.2 | 0.02 |
| stmt execute | 343 | 64.2 | 0.02 |
| stmt prepare | 343 | 64.2 | 0.02 |
| show slave status | 210 | 39.3 | 0.01 |
| show grants | 209 | 39.1 | 0.01 |
| show binlog status | 204 | 38.2 | 0.01 |
| show table status | 186 | 34.8 | 0.01 |
| insert | 128 | 24 | 0.01 |
| update | 62 | 11.6 | <0.01 |
| show binlogs | 55 | 10.3 | <0.01 |
| create table | 52 | 9.7 | <0.01 |
| show status | 26 | 4.9 | <0.01 |
| alter table | 14 | 2.6 | <0.01 |
| delete | 7 | 1.3 | <0.01 |
| commit | 3 | 0.6 | <0.01 |
| show processlist | 3 | 0.6 | <0.01 |
| create db | 2 | 0.4 | <0.01 |
| show engine status | 2 | 0.4 | <0.01 |
| begin | 1 | 0.2 | <0.01 |
| flush | 1 | 0.2 | <0.01 |
| show databases | 1 | 0.2 | <0.01 |