| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 1,322 k | 2,245.5 | 59.94 |
| stmt execute | 372 k | 631.6 | 16.86 |
| insert | 177 k | 301.5 | 8.05 |
| show tables | 93,415 | 158.7 | 4.24 |
| show fields | 55,317 | 94 | 2.51 |
| change db | 50,349 | 85.5 | 2.28 |
| set option | 46,743 | 79.4 | 2.12 |
| stmt prepare | 32,536 | 55.3 | 1.48 |
| stmt close | 23,276 | 39.5 | 1.06 |
| show keys | 7,666 | 13 | 0.35 |
| update | 7,603 | 12.9 | 0.34 |
| delete | 7,438 | 12.6 | 0.34 |
| replace | 3,032 | 5.2 | 0.14 |
| show variables | 2,652 | 4.5 | 0.12 |
| show create table | 2,092 | 3.6 | 0.09 |
| show warnings | 902 | 1.5 | 0.04 |
| show storage engines | 869 | 1.5 | 0.04 |
| show table status | 123 | 0.2 | 0.01 |
| show master status | 74 | 0.1 | <0.01 |
| show slave status | 74 | 0.1 | <0.01 |
| show grants | 27 | <0.1 | <0.01 |
| show binlogs | 23 | <0.1 | <0.01 |
| show status | 23 | <0.1 | <0.01 |
| create table | 10 | <0.1 | <0.01 |
| alter table | 4 | <0.1 | <0.01 |
| begin | 3 | <0.1 | <0.01 |
| commit | 3 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |
| show processlist | 2 | <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 |