| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 1,537 k | 2,402.9 | 77.04 |
| show tables | 111 k | 172.8 | 5.54 |
| show fields | 101 k | 157.6 | 5.05 |
| change db | 76,344 | 119.4 | 3.83 |
| set option | 56,109 | 87.7 | 2.81 |
| show keys | 51,457 | 80.4 | 2.58 |
| show variables | 16,708 | 26.1 | 0.84 |
| replace | 16,237 | 25.4 | 0.81 |
| show create table | 11,232 | 17.6 | 0.56 |
| show warnings | 6,408 | 10 | 0.32 |
| show grants | 6,197 | 9.7 | 0.31 |
| show storage engines | 1,997 | 3.1 | 0.10 |
| create table | 1,525 | 2.4 | 0.08 |
| stmt execute | 389 | 0.6 | 0.02 |
| stmt prepare | 389 | 0.6 | 0.02 |
| stmt close | 381 | 0.6 | 0.02 |
| create db | 363 | 0.6 | 0.02 |
| show binlogs | 308 | 0.5 | 0.02 |
| show table status | 263 | 0.4 | 0.01 |
| show slave status | 189 | 0.3 | 0.01 |
| show master status | 180 | 0.3 | 0.01 |
| show status | 57 | 0.1 | <0.01 |
| insert | 15 | <0.1 | <0.01 |
| alter table | 11 | <0.1 | <0.01 |
| update | 9 | <0.1 | <0.01 |
| show processlist | 7 | <0.1 | <0.01 |
| show engine status | 6 | <0.1 | <0.01 |
| flush | 3 | <0.1 | <0.01 |