| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 179 k | 27.7 k | 78.62 |
| show tables | 13,213 | 2,047 | 5.81 |
| show fields | 10,331 | 1,600.5 | 4.54 |
| change db | 9,518 | 1,474.6 | 4.19 |
| set option | 6,828 | 1,057.8 | 3.00 |
| show keys | 3,755 | 581.7 | 1.65 |
| show variables | 1,677 | 259.8 | 0.74 |
| replace | 1,086 | 168.2 | 0.48 |
| show create table | 673 | 104.3 | 0.30 |
| show grants | 446 | 69.1 | 0.20 |
| show warnings | 256 | 39.7 | 0.11 |
| show storage engines | 216 | 33.5 | 0.09 |
| show binlogs | 214 | 33.2 | 0.09 |
| stmt close | 72 | 11.2 | 0.03 |
| stmt execute | 72 | 11.2 | 0.03 |
| stmt prepare | 72 | 11.2 | 0.03 |
| show slave status | 54 | 8.4 | 0.02 |
| show table status | 52 | 8.1 | 0.02 |
| show master status | 50 | 7.7 | 0.02 |
| show status | 26 | 4 | 0.01 |
| show processlist | 3 | 0.5 | <0.01 |
| create index | 2 | 0.3 | <0.01 |
| update | 2 | 0.3 | <0.01 |
| create db | 1 | 0.2 | <0.01 |
| create table | 1 | 0.2 | <0.01 |
| flush | 1 | 0.2 | <0.01 |
| insert | 1 | 0.2 | <0.01 |
| show engine status | 1 | 0.2 | <0.01 |