| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 6,079 k | 3,968.9 | 59.24 |
| set option | 1,147 k | 748.9 | 11.18 |
| show tables | 814 k | 531.2 | 7.93 |
| show fields | 639 k | 417.3 | 6.23 |
| show keys | 376 k | 245.7 | 3.67 |
| update | 319 k | 208.4 | 3.11 |
| change db | 259 k | 169.4 | 2.53 |
| show variables | 212 k | 138.1 | 2.06 |
| show create table | 168 k | 109.4 | 1.63 |
| show warnings | 86,524 | 56.5 | 0.84 |
| show storage engines | 47,207 | 30.8 | 0.46 |
| insert | 39,044 | 25.5 | 0.38 |
| stmt close | 15,660 | 10.2 | 0.15 |
| stmt execute | 15,660 | 10.2 | 0.15 |
| stmt prepare | 15,660 | 10.2 | 0.15 |
| show table status | 6,799 | 4.4 | 0.07 |
| show grants | 5,388 | 3.5 | 0.05 |
| 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,388 | 0.9 | 0.01 |
| show slave status | 1,322 | 0.9 | 0.01 |
| show master status | 1,308 | 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 | 57 | <0.1 | <0.01 |
| truncate | 39 | <0.1 | <0.01 |
| create db | 11 | <0.1 | <0.01 |
| flush | 8 | <0.1 | <0.01 |
| show engine status | 7 | <0.1 | <0.01 |
| show processlist | 6 | <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 |