| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 903 k | 20.8 k | 71.92 |
| insert | 85,947 | 1,974.8 | 6.84 |
| show tables | 62,277 | 1,431 | 4.96 |
| show fields | 53,561 | 1,230.7 | 4.26 |
| change db | 45,499 | 1,045.4 | 3.62 |
| set option | 31,617 | 726.5 | 2.52 |
| show keys | 19,873 | 456.6 | 1.58 |
| stmt execute | 10,476 | 240.7 | 0.83 |
| stmt prepare | 10,476 | 240.7 | 0.83 |
| stmt close | 10,474 | 240.7 | 0.83 |
| show variables | 6,581 | 151.2 | 0.52 |
| show create table | 5,921 | 136 | 0.47 |
| replace | 4,538 | 104.3 | 0.36 |
| show warnings | 1,624 | 37.3 | 0.13 |
| show storage engines | 1,444 | 33.2 | 0.11 |
| show grants | 634 | 14.6 | 0.05 |
| show table status | 529 | 12.2 | 0.04 |
| show slave status | 372 | 8.5 | 0.03 |
| show master status | 363 | 8.3 | 0.03 |
| show binlogs | 158 | 3.6 | 0.01 |
| delete | 48 | 1.1 | <0.01 |
| update | 43 | 1 | <0.01 |
| show status | 42 | 1 | <0.01 |
| show profile | 35 | 0.8 | <0.01 |
| insert select | 22 | 0.5 | <0.01 |
| show create proc | 20 | 0.5 | <0.01 |
| create table | 10 | 0.2 | <0.01 |
| alter table | 8 | 0.2 | <0.01 |
| begin | 6 | 0.1 | <0.01 |
| commit | 6 | 0.1 | <0.01 |
| show create func | 5 | 0.1 | <0.01 |
| show processlist | 5 | 0.1 | <0.01 |
| drop table | 4 | 0.1 | <0.01 |
| flush | 4 | 0.1 | <0.01 |
| delete multi | 2 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |
| create db | 1 | <0.1 | <0.01 |
| drop db | 1 | <0.1 | <0.01 |