| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 210 k | 5,327.4 | 95.02 |
| set option | 3,333 | 84.7 | 1.51 |
| change db | 1,779 | 45.2 | 0.81 |
| show fields | 1,579 | 40.1 | 0.72 |
| show keys | 1,434 | 36.5 | 0.65 |
| show tables | 789 | 20.1 | 0.36 |
| show variables | 755 | 19.2 | 0.34 |
| replace | 262 | 6.7 | 0.12 |
| show create table | 236 | 6 | 0.11 |
| show grants | 220 | 5.6 | 0.10 |
| show storage engines | 157 | 4 | 0.07 |
| show binlogs | 153 | 3.9 | 0.07 |
| show slave status | 68 | 1.7 | 0.03 |
| show master status | 64 | 1.6 | 0.03 |
| update | 37 | 0.9 | 0.02 |
| insert | 35 | 0.9 | 0.02 |
| show table status | 26 | 0.7 | 0.01 |
| show status | 18 | 0.5 | 0.01 |
| show warnings | 11 | 0.3 | <0.01 |
| rollback | 4 | 0.1 | <0.01 |
| insert select | 4 | 0.1 | <0.01 |
| begin | 4 | 0.1 | <0.01 |
| show processlist | 3 | 0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |