| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 261 k | 1,230.7 | 78.31 |
| show tables | 19,314 | 91 | 5.79 |
| show fields | 15,822 | 74.5 | 4.74 |
| change db | 13,673 | 64.4 | 4.10 |
| set option | 9,681 | 45.6 | 2.90 |
| show keys | 5,971 | 28.1 | 1.79 |
| show variables | 2,369 | 11.2 | 0.71 |
| replace | 1,925 | 9.1 | 0.58 |
| show create table | 1,287 | 6.1 | 0.39 |
| show grants | 861 | 4.1 | 0.26 |
| show warnings | 423 | 2 | 0.13 |
| show storage engines | 356 | 1.7 | 0.11 |
| show binlogs | 204 | 1 | 0.06 |
| insert | 94 | 0.4 | 0.03 |
| show slave status | 61 | 0.3 | 0.02 |
| show table status | 60 | 0.3 | 0.02 |
| show master status | 58 | 0.3 | 0.02 |
| stmt prepare | 40 | 0.2 | 0.01 |
| stmt close | 39 | 0.2 | 0.01 |
| stmt execute | 39 | 0.2 | 0.01 |
| update | 28 | 0.1 | 0.01 |
| show status | 27 | 0.1 | 0.01 |
| create table | 14 | 0.1 | <0.01 |
| show databases | 13 | 0.1 | <0.01 |
| create db | 12 | 0.1 | <0.01 |
| show processlist | 3 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |