| Statements | # | ø per hour | % |
|---|---|---|---|
| insert | 31,680 | 7,200.5 | 38.62 |
| select | 23,656 | 5,376.7 | 28.84 |
| update | 8,964 | 2,037.4 | 10.93 |
| set option | 4,506 | 1,024.2 | 5.49 |
| show tables | 4,224 | 960.1 | 5.15 |
| change db | 2,046 | 465 | 2.49 |
| show keys | 1,966 | 446.8 | 2.40 |
| show fields | 1,754 | 398.7 | 2.14 |
| show variables | 1,036 | 235.5 | 1.26 |
| show create table | 637 | 144.8 | 0.78 |
| show grants | 525 | 119.3 | 0.64 |
| delete | 230 | 52.3 | 0.28 |
| show slave status | 94 | 21.4 | 0.11 |
| begin | 92 | 20.9 | 0.11 |
| commit | 92 | 20.9 | 0.11 |
| show storage engines | 91 | 20.7 | 0.11 |
| show master status | 90 | 20.5 | 0.11 |
| show binlogs | 78 | 17.7 | 0.10 |
| create table | 59 | 13.4 | 0.07 |
| show warnings | 52 | 11.8 | 0.06 |
| show table status | 34 | 7.7 | 0.04 |
| stmt close | 22 | 5 | 0.03 |
| stmt execute | 22 | 5 | 0.03 |
| stmt prepare | 22 | 5 | 0.03 |
| show create proc | 20 | 4.5 | 0.02 |
| show status | 17 | 3.9 | 0.02 |
| alter table | 13 | 3 | 0.02 |
| show processlist | 2 | 0.5 | <0.01 |
| create db | 1 | 0.2 | <0.01 |