| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 186 k | 3,973 | 52.10 |
| set option | 37,394 | 797.7 | 10.46 |
| show keys | 34,481 | 735.5 | 9.65 |
| show tables | 30,158 | 643.3 | 8.44 |
| show fields | 29,074 | 620.2 | 8.13 |
| show variables | 12,414 | 264.8 | 3.47 |
| change db | 11,790 | 251.5 | 3.30 |
| show create table | 7,769 | 165.7 | 2.17 |
| show warnings | 4,883 | 104.2 | 1.37 |
| show storage engines | 1,664 | 35.5 | 0.47 |
| show grants | 278 | 5.9 | 0.08 |
| show slave status | 222 | 4.7 | 0.06 |
| show table status | 219 | 4.7 | 0.06 |
| show master status | 216 | 4.6 | 0.06 |
| insert | 119 | 2.5 | 0.03 |
| show binlogs | 118 | 2.5 | 0.03 |
| update | 81 | 1.7 | 0.02 |
| stmt close | 71 | 1.5 | 0.02 |
| stmt execute | 71 | 1.5 | 0.02 |
| stmt prepare | 71 | 1.5 | 0.02 |
| begin | 43 | 0.9 | 0.01 |
| commit | 43 | 0.9 | 0.01 |
| show status | 38 | 0.8 | 0.01 |
| create table | 7 | 0.1 | <0.01 |
| show processlist | 5 | 0.1 | <0.01 |
| show engine status | 4 | 0.1 | <0.01 |
| create db | 1 | <0.1 | <0.01 |
| show function status | 1 | <0.1 | <0.01 |
| show procedure status | 1 | <0.1 | <0.01 |