| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 6,104 k | 3,981.2 | 59.16 |
| set option | 1,152 k | 751.6 | 11.17 |
| show tables | 820 k | 534.5 | 7.94 |
| show fields | 645 k | 420.9 | 6.25 |
| show keys | 382 k | 248.9 | 3.70 |
| update | 319 k | 208.2 | 3.09 |
| change db | 263 k | 171.3 | 2.55 |
| show variables | 213 k | 138.6 | 2.06 |
| show create table | 170 k | 110.7 | 1.64 |
| show warnings | 86,682 | 56.5 | 0.84 |
| show storage engines | 47,603 | 31 | 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,884 | 4.5 | 0.07 |
| show grants | 6,195 | 4 | 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,422 | 0.9 | 0.01 |
| show slave status | 1,338 | 0.9 | 0.01 |
| show master status | 1,323 | 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 | 65 | <0.1 | <0.01 |
| truncate | 39 | <0.1 | <0.01 |
| create db | 11 | <0.1 | <0.01 |
| flush | 9 | <0.1 | <0.01 |
| show engine status | 7 | <0.1 | <0.01 |
| show processlist | 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 |