| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 266 k | 935.9 | 79.17 |
| insert | 23,255 | 81.9 | 6.93 |
| update | 16,138 | 56.8 | 4.81 |
| set option | 7,620 | 26.8 | 2.27 |
| delete | 5,431 | 19.1 | 1.62 |
| show tables | 4,177 | 14.7 | 1.24 |
| show fields | 4,070 | 14.3 | 1.21 |
| change db | 3,838 | 13.5 | 1.14 |
| replace | 2,716 | 9.6 | 0.81 |
| insert select | 1,069 | 3.8 | 0.32 |
| update multi | 535 | 1.9 | 0.16 |
| show keys | 479 | 1.7 | 0.14 |
| show variables | 309 | 1.1 | 0.09 |
| show create table | 72 | 0.3 | 0.02 |
| show slave status | 45 | 0.2 | 0.01 |
| show binlog status | 41 | 0.1 | 0.01 |
| stmt close | 22 | 0.1 | 0.01 |
| stmt execute | 22 | 0.1 | 0.01 |
| stmt prepare | 22 | 0.1 | 0.01 |
| show table status | 16 | 0.1 | <0.01 |
| delete multi | 12 | <0.1 | <0.01 |
| show storage engines | 12 | <0.1 | <0.01 |
| show status | 9 | <0.1 | <0.01 |
| show binlogs | 6 | <0.1 | <0.01 |
| show grants | 6 | <0.1 | <0.01 |
| truncate | 4 | <0.1 | <0.01 |
| begin | 3 | <0.1 | <0.01 |
| commit | 3 | <0.1 | <0.01 |
| show processlist | 1 | <0.1 | <0.01 |