| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 6,108 k | 3,983.4 | 59.15 |
| set option | 1,153 k | 752.1 | 11.17 |
| show tables | 820 k | 535 | 7.94 |
| show fields | 646 k | 421.6 | 6.26 |
| show keys | 382 k | 249.4 | 3.70 |
| update | 319 k | 208.2 | 3.09 |
| change db | 263 k | 171.5 | 2.55 |
| show variables | 213 k | 138.7 | 2.06 |
| show create table | 170 k | 110.8 | 1.65 |
| show warnings | 86,693 | 56.5 | 0.84 |
| show storage engines | 47,668 | 31.1 | 0.46 |
| insert | 39,044 | 25.5 | 0.38 |
| stmt close | 15,693 | 10.2 | 0.15 |
| stmt execute | 15,693 | 10.2 | 0.15 |
| stmt prepare | 15,693 | 10.2 | 0.15 |
| show table status | 6,886 | 4.5 | 0.07 |
| show grants | 6,255 | 4.1 | 0.06 |
| delete | 4,743 | 3.1 | 0.05 |
| rollback to savepoint | 4,392 | 2.9 | 0.04 |
| insert select | 1,975 | 1.3 | 0.02 |
| show binlogs | 1,437 | 0.9 | 0.01 |
| show slave status | 1,344 | 0.9 | 0.01 |
| show master status | 1,329 | 0.9 | 0.01 |
| create table | 720 | 0.5 | 0.01 |
| drop table | 581 | 0.4 | 0.01 |
| alter table | 317 | 0.2 | <0.01 |
| begin | 161 | 0.1 | <0.01 |
| commit | 87 | 0.1 | <0.01 |
| release savepoint | 72 | <0.1 | <0.01 |
| savepoint | 72 | <0.1 | <0.01 |
| unlock tables | 72 | <0.1 | <0.01 |
| show status | 71 | <0.1 | <0.01 |
| truncate | 39 | <0.1 | <0.01 |
| create db | 11 | <0.1 | <0.01 |
| flush | 9 | <0.1 | <0.01 |
| show processlist | 8 | <0.1 | <0.01 |
| show engine status | 7 | <0.1 | <0.01 |
| show function status | 5 | <0.1 | <0.01 |
| show procedure status | 5 | <0.1 | <0.01 |
| empty query | 2 | <0.1 | <0.01 |
| drop db | 1 | <0.1 | <0.01 |