| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 1,548 k | 2,414 | 77.05 |
| show tables | 111 k | 173.6 | 5.54 |
| show fields | 101 k | 158.2 | 5.05 |
| change db | 76,953 | 120 | 3.83 |
| set option | 56,535 | 88.1 | 2.81 |
| show keys | 51,629 | 80.5 | 2.57 |
| show variables | 16,808 | 26.2 | 0.84 |
| replace | 16,333 | 25.5 | 0.81 |
| show create table | 11,286 | 17.6 | 0.56 |
| show warnings | 6,426 | 10 | 0.32 |
| show grants | 6,262 | 9.8 | 0.31 |
| show storage engines | 2,020 | 3.1 | 0.10 |
| create table | 1,525 | 2.4 | 0.08 |
| stmt execute | 416 | 0.6 | 0.02 |
| stmt prepare | 416 | 0.6 | 0.02 |
| stmt close | 408 | 0.6 | 0.02 |
| create db | 363 | 0.6 | 0.02 |
| show binlogs | 332 | 0.5 | 0.02 |
| show table status | 264 | 0.4 | 0.01 |
| show slave status | 193 | 0.3 | 0.01 |
| show master status | 184 | 0.3 | 0.01 |
| show status | 62 | 0.1 | <0.01 |
| insert | 15 | <0.1 | <0.01 |
| alter table | 11 | <0.1 | <0.01 |
| update | 9 | <0.1 | <0.01 |
| show engine status | 8 | <0.1 | <0.01 |
| show processlist | 8 | <0.1 | <0.01 |
| flush | 4 | <0.1 | <0.01 |