| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 130 k | 52.1 k | 78.44 |
| show tables | 9,424 | 3,765.8 | 5.67 |
| show fields | 7,677 | 3,067.7 | 4.62 |
| change db | 7,181 | 2,869.5 | 4.32 |
| set option | 4,950 | 1,978 | 2.98 |
| show keys | 2,976 | 1,189.2 | 1.79 |
| show variables | 1,179 | 471.1 | 0.71 |
| replace | 617 | 246.6 | 0.37 |
| show create table | 568 | 227 | 0.34 |
| show grants | 402 | 160.6 | 0.24 |
| show storage engines | 185 | 73.9 | 0.11 |
| show binlogs | 156 | 62.3 | 0.09 |
| stmt execute | 106 | 42.4 | 0.06 |
| stmt prepare | 100 | 40 | 0.06 |
| stmt close | 99 | 39.6 | 0.06 |
| show warnings | 90 | 36 | 0.05 |
| show slave status | 38 | 15.2 | 0.02 |
| show master status | 35 | 14 | 0.02 |
| show table status | 31 | 12.4 | 0.02 |
| show status | 14 | 5.6 | 0.01 |
| insert | 8 | 3.2 | <0.01 |
| flush | 2 | 0.8 | <0.01 |
| show processlist | 2 | 0.8 | <0.01 |
| begin | 1 | 0.4 | <0.01 |
| commit | 1 | 0.4 | <0.01 |
| show engine status | 1 | 0.4 | <0.01 |
| update | 1 | 0.4 | <0.01 |