| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 185 k | 3,950.7 | 52.15 |
| set option | 37,130 | 792.2 | 10.46 |
| show keys | 34,171 | 729.1 | 9.62 |
| show tables | 29,907 | 638.1 | 8.42 |
| show fields | 28,810 | 614.7 | 8.11 |
| show variables | 12,342 | 263.3 | 3.48 |
| change db | 11,686 | 249.3 | 3.29 |
| show create table | 7,739 | 165.1 | 2.18 |
| show warnings | 4,864 | 103.8 | 1.37 |
| show storage engines | 1,653 | 35.3 | 0.47 |
| show grants | 260 | 5.5 | 0.07 |
| show slave status | 217 | 4.6 | 0.06 |
| show table status | 217 | 4.6 | 0.06 |
| show master status | 211 | 4.5 | 0.06 |
| insert | 119 | 2.5 | 0.03 |
| show binlogs | 113 | 2.4 | 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 | 32 | 0.7 | 0.01 |
| create table | 7 | 0.1 | <0.01 |
| show processlist | 4 | 0.1 | <0.01 |
| show engine status | 3 | 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 |