| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 222 k | 18.5 k | 52.72 |
| set option | 41,439 | 3,437.3 | 9.82 |
| show fields | 37,254 | 3,090.1 | 8.83 |
| show tables | 32,527 | 2,698 | 7.71 |
| show keys | 31,070 | 2,577.2 | 7.36 |
| show variables | 17,304 | 1,435.3 | 4.10 |
| change db | 13,804 | 1,145 | 3.27 |
| show create table | 10,527 | 873.2 | 2.49 |
| show warnings | 7,496 | 621.8 | 1.78 |
| stmt close | 1,657 | 137.4 | 0.39 |
| stmt execute | 1,657 | 137.4 | 0.39 |
| stmt prepare | 1,657 | 137.4 | 0.39 |
| show storage engines | 1,644 | 136.4 | 0.39 |
| show grants | 631 | 52.3 | 0.15 |
| show table status | 249 | 20.7 | 0.06 |
| show binlogs | 214 | 17.8 | 0.05 |
| create table | 166 | 13.8 | 0.04 |
| show slave status | 95 | 7.9 | 0.02 |
| show master status | 93 | 7.7 | 0.02 |
| show status | 22 | 1.8 | 0.01 |
| update | 9 | 0.7 | <0.01 |
| alter table | 6 | 0.5 | <0.01 |
| show processlist | 4 | 0.3 | <0.01 |
| show engine status | 3 | 0.2 | <0.01 |
| flush | 2 | 0.2 | <0.01 |
| insert | 2 | 0.2 | <0.01 |
| delete | 1 | 0.1 | <0.01 |