| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 940 k | 1,452.8 | 77.32 |
| show tables | 65,272 | 100.9 | 5.37 |
| show fields | 61,560 | 95.2 | 5.06 |
| change db | 46,117 | 71.3 | 3.79 |
| set option | 34,449 | 53.3 | 2.83 |
| show keys | 31,779 | 49.1 | 2.61 |
| show variables | 11,336 | 17.5 | 0.93 |
| replace | 10,179 | 15.7 | 0.84 |
| show create table | 7,378 | 11.4 | 0.61 |
| show warnings | 4,612 | 7.1 | 0.38 |
| show storage engines | 1,362 | 2.1 | 0.11 |
| stmt close | 306 | 0.5 | 0.03 |
| stmt execute | 306 | 0.5 | 0.03 |
| stmt prepare | 306 | 0.5 | 0.03 |
| show grants | 174 | 0.3 | 0.01 |
| show table status | 132 | 0.2 | 0.01 |
| show slave status | 124 | 0.2 | 0.01 |
| show master status | 117 | 0.2 | 0.01 |
| show binlogs | 98 | 0.2 | 0.01 |
| update | 40 | 0.1 | <0.01 |
| show status | 21 | <0.1 | <0.01 |
| insert | 17 | <0.1 | <0.01 |
| delete | 10 | <0.1 | <0.01 |
| delete multi | 2 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |
| show processlist | 2 | <0.1 | <0.01 |