| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 12,531 | 1,567.7 | 51.40 |
| set option | 3,352 | 419.3 | 13.75 |
| show tables | 2,576 | 322.3 | 10.57 |
| change db | 1,034 | 129.4 | 4.24 |
| show variables | 767 | 96 | 3.15 |
| stmt execute | 765 | 95.7 | 3.14 |
| stmt close | 755 | 94.5 | 3.10 |
| stmt prepare | 755 | 94.5 | 3.10 |
| show fields | 655 | 81.9 | 2.69 |
| show keys | 621 | 77.7 | 2.55 |
| show create table | 195 | 24.4 | 0.80 |
| insert | 81 | 10.1 | 0.33 |
| show slave status | 81 | 10.1 | 0.33 |
| show master status | 78 | 9.8 | 0.32 |
| show table status | 28 | 3.5 | 0.11 |
| update | 27 | 3.4 | 0.11 |
| show storage engines | 21 | 2.6 | 0.09 |
| show binlogs | 14 | 1.8 | 0.06 |
| show grants | 14 | 1.8 | 0.06 |
| show warnings | 10 | 1.3 | 0.04 |
| show status | 8 | 1 | 0.03 |
| begin | 5 | 0.6 | 0.02 |
| commit | 5 | 0.6 | 0.02 |
| alter table | 2 | 0.3 | 0.01 |
| show processlist | 1 | 0.1 | <0.01 |