| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 2,227 k | 3,628.8 | 65.99 |
| stmt execute | 373 k | 607.2 | 11.04 |
| insert | 178 k | 289.8 | 5.27 |
| show tables | 157 k | 255.5 | 4.65 |
| show fields | 114 k | 185.7 | 3.38 |
| change db | 93,694 | 152.7 | 2.78 |
| set option | 80,361 | 131 | 2.38 |
| show keys | 37,306 | 60.8 | 1.11 |
| stmt prepare | 32,688 | 53.3 | 0.97 |
| stmt close | 23,361 | 38.1 | 0.69 |
| show variables | 13,515 | 22 | 0.40 |
| replace | 12,670 | 20.6 | 0.38 |
| show create table | 9,038 | 14.7 | 0.27 |
| update | 7,630 | 12.4 | 0.23 |
| delete | 7,455 | 12.1 | 0.22 |
| show warnings | 5,369 | 8.8 | 0.16 |
| show storage engines | 1,811 | 3 | 0.05 |
| show grants | 785 | 1.3 | 0.02 |
| show binlogs | 304 | 0.5 | 0.01 |
| show table status | 211 | 0.3 | 0.01 |
| show master status | 146 | 0.2 | <0.01 |
| show slave status | 146 | 0.2 | <0.01 |
| show status | 32 | 0.1 | <0.01 |
| create table | 10 | <0.1 | <0.01 |
| show engine status | 5 | <0.1 | <0.01 |
| alter table | 4 | <0.1 | <0.01 |
| begin | 3 | <0.1 | <0.01 |
| commit | 3 | <0.1 | <0.01 |
| show processlist | 3 | <0.1 | <0.01 |
| delete multi | 1 | <0.1 | <0.01 |
| show databases | 1 | <0.1 | <0.01 |
| show function status | 1 | <0.1 | <0.01 |
| show procedure status | 1 | <0.1 | <0.01 |