| Statements | # | ø per hour | % |
|---|---|---|---|
| insert | 729 k | 4,950.2 | 61.60 |
| select | 231 k | 1,568 | 19.51 |
| set option | 43,122 | 292.6 | 3.64 |
| show keys | 35,491 | 240.8 | 3.00 |
| show tables | 34,797 | 236.1 | 2.94 |
| show fields | 30,857 | 209.4 | 2.61 |
| show variables | 13,594 | 92.3 | 1.15 |
| change db | 12,728 | 86.4 | 1.07 |
| delete | 11,785 | 80 | 1.00 |
| begin | 10,652 | 72.3 | 0.90 |
| commit | 10,643 | 72.2 | 0.90 |
| show create table | 8,291 | 56.3 | 0.70 |
| show warnings | 5,537 | 37.6 | 0.47 |
| update | 2,819 | 19.1 | 0.24 |
| show storage engines | 1,633 | 11.1 | 0.14 |
| show grants | 276 | 1.9 | 0.02 |
| show binlogs | 234 | 1.6 | 0.02 |
| show slave status | 228 | 1.5 | 0.02 |
| show master status | 220 | 1.5 | 0.02 |
| show table status | 216 | 1.5 | 0.02 |
| stmt close | 117 | 0.8 | 0.01 |
| stmt execute | 117 | 0.8 | 0.01 |
| stmt prepare | 117 | 0.8 | 0.01 |
| insert select | 45 | 0.3 | <0.01 |
| show status | 28 | 0.2 | <0.01 |
| alter table | 13 | 0.1 | <0.01 |
| rollback | 9 | 0.1 | <0.01 |
| show processlist | 3 | <0.1 | <0.01 |
| create table | 2 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |