| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 355 k | 41.5 k | 55.36 |
| set option | 72,581 | 8,487.6 | 11.32 |
| show fields | 58,358 | 6,824.4 | 9.10 |
| show tables | 57,463 | 6,719.7 | 8.96 |
| show keys | 32,813 | 3,837.2 | 5.12 |
| change db | 18,961 | 2,217.3 | 2.96 |
| show create table | 16,469 | 1,925.9 | 2.57 |
| show variables | 12,171 | 1,423.3 | 1.90 |
| show storage engines | 8,623 | 1,008.4 | 1.34 |
| show warnings | 3,671 | 429.3 | 0.57 |
| show table status | 725 | 84.8 | 0.11 |
| stmt prepare | 675 | 78.9 | 0.11 |
| stmt execute | 675 | 78.9 | 0.11 |
| stmt close | 675 | 78.9 | 0.11 |
| show grants | 440 | 51.5 | 0.07 |
| alter table | 360 | 42.1 | 0.06 |
| update | 210 | 24.6 | 0.03 |
| create table | 181 | 21.2 | 0.03 |
| unlock tables | 181 | 21.2 | 0.03 |
| rollback to savepoint | 181 | 21.2 | 0.03 |
| drop table | 181 | 21.2 | 0.03 |
| lock tables | 180 | 21 | 0.03 |
| insert | 136 | 15.9 | 0.02 |
| show slave status | 129 | 15.1 | 0.02 |
| show master status | 122 | 14.3 | 0.02 |
| show binlogs | 59 | 6.9 | 0.01 |
| show status | 27 | 3.2 | <0.01 |
| show processlist | 3 | 0.4 | <0.01 |
| show engine status | 2 | 0.2 | <0.01 |
| create db | 1 | 0.1 | <0.01 |
| begin | 1 | 0.1 | <0.01 |
| drop db | 1 | 0.1 | <0.01 |
| show databases | 1 | 0.1 | <0.01 |
| savepoint | 1 | 0.1 | <0.01 |
| release savepoint | 1 | 0.1 | <0.01 |