| Statements | # | ø per hour | % |
|---|---|---|---|
| insert | 729 k | 4,916.9 | 61.10 |
| select | 235 k | 1,587.3 | 19.73 |
| set option | 44,207 | 298 | 3.70 |
| show keys | 36,394 | 245.3 | 3.05 |
| show tables | 35,985 | 242.6 | 3.01 |
| show fields | 31,727 | 213.9 | 2.66 |
| show variables | 13,744 | 92.6 | 1.15 |
| change db | 13,298 | 89.6 | 1.11 |
| delete | 11,785 | 79.4 | 0.99 |
| begin | 10,652 | 71.8 | 0.89 |
| commit | 10,643 | 71.7 | 0.89 |
| show create table | 8,484 | 57.2 | 0.71 |
| show warnings | 5,542 | 37.4 | 0.46 |
| update | 2,819 | 19 | 0.24 |
| show storage engines | 1,716 | 11.6 | 0.14 |
| show grants | 414 | 2.8 | 0.03 |
| show binlogs | 276 | 1.9 | 0.02 |
| show slave status | 246 | 1.7 | 0.02 |
| show master status | 237 | 1.6 | 0.02 |
| show table status | 228 | 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 | 40 | 0.3 | <0.01 |
| alter table | 13 | 0.1 | <0.01 |
| rollback | 9 | 0.1 | <0.01 |
| show processlist | 5 | <0.1 | <0.01 |
| show engine status | 3 | <0.1 | <0.01 |
| create table | 2 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |