| Statements | # | ø per hour | % |
|---|---|---|---|
| insert | 729 k | 4,918.1 | 61.22 |
| select | 234 k | 1,580.7 | 19.68 |
| set option | 43,953 | 296.3 | 3.69 |
| show keys | 36,198 | 244 | 3.04 |
| show tables | 35,688 | 240.6 | 3.00 |
| show fields | 31,522 | 212.5 | 2.65 |
| show variables | 13,701 | 92.4 | 1.15 |
| change db | 13,164 | 88.8 | 1.10 |
| delete | 11,785 | 79.5 | 0.99 |
| begin | 10,652 | 71.8 | 0.89 |
| commit | 10,643 | 71.8 | 0.89 |
| show create table | 8,445 | 56.9 | 0.71 |
| show warnings | 5,539 | 37.3 | 0.46 |
| update | 2,819 | 19 | 0.24 |
| show storage engines | 1,697 | 11.4 | 0.14 |
| show grants | 370 | 2.5 | 0.03 |
| show binlogs | 260 | 1.8 | 0.02 |
| show slave status | 237 | 1.6 | 0.02 |
| show master status | 228 | 1.5 | 0.02 |
| show table status | 220 | 1.5 | 0.02 |
| stmt close | 126 | 0.8 | 0.01 |
| stmt execute | 126 | 0.8 | 0.01 |
| stmt prepare | 126 | 0.8 | 0.01 |
| insert select | 45 | 0.3 | <0.01 |
| show status | 34 | 0.2 | <0.01 |
| alter table | 13 | 0.1 | <0.01 |
| rollback | 9 | 0.1 | <0.01 |
| show processlist | 4 | <0.1 | <0.01 |
| create table | 2 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |