| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 5,428 k | 1,433.2 | 79.05 |
| show tables | 305 k | 80.6 | 4.45 |
| show fields | 291 k | 76.9 | 4.24 |
| set option | 227 k | 59.8 | 3.30 |
| change db | 215 k | 56.9 | 3.14 |
| show keys | 123 k | 32.4 | 1.79 |
| replace | 51,271 | 13.5 | 0.75 |
| show variables | 49,810 | 13.2 | 0.73 |
| show create table | 34,981 | 9.2 | 0.51 |
| stmt execute | 31,233 | 8.2 | 0.45 |
| show warnings | 19,855 | 5.2 | 0.29 |
| stmt prepare | 19,644 | 5.2 | 0.29 |
| stmt close | 19,357 | 5.1 | 0.28 |
| insert | 19,178 | 5.1 | 0.28 |
| update | 9,935 | 2.6 | 0.14 |
| show storage engines | 7,726 | 2 | 0.11 |
| show status | 5,613 | 1.5 | 0.08 |
| delete | 3,137 | 0.8 | 0.05 |
| show grants | 1,419 | 0.4 | 0.02 |
| show table status | 844 | 0.2 | 0.01 |
| show binlogs | 538 | 0.1 | 0.01 |
| empty query | 534 | 0.1 | 0.01 |
| show slave status | 507 | 0.1 | 0.01 |
| show master status | 492 | 0.1 | 0.01 |
| create table | 312 | 0.1 | <0.01 |
| commit | 227 | 0.1 | <0.01 |
| begin | 225 | 0.1 | <0.01 |
| show charsets | 130 | <0.1 | <0.01 |
| lock tables | 94 | <0.1 | <0.01 |
| unlock tables | 94 | <0.1 | <0.01 |
| alter table | 80 | <0.1 | <0.01 |
| show databases | 49 | <0.1 | <0.01 |
| drop table | 40 | <0.1 | <0.01 |
| show procedure status | 38 | <0.1 | <0.01 |
| show collations | 36 | <0.1 | <0.01 |
| drop db | 15 | <0.1 | <0.01 |
| create db | 13 | <0.1 | <0.01 |
| show processlist | 12 | <0.1 | <0.01 |
| show create db | 10 | <0.1 | <0.01 |
| show engine status | 10 | <0.1 | <0.01 |
| show plugins | 6 | <0.1 | <0.01 |
| flush | 5 | <0.1 | <0.01 |