| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 3,634 k | 606.9 k | 84.87 |
| show fields | 154 k | 25.7 k | 3.59 |
| show tables | 120 k | 20 k | 2.79 |
| show keys | 103 k | 17.2 k | 2.41 |
| change db | 92,595 | 15.5 k | 2.16 |
| set option | 69,224 | 11.6 k | 1.62 |
| show variables | 40,964 | 6,842.2 | 0.96 |
| show grants | 22,196 | 3,707.4 | 0.52 |
| show create table | 20,621 | 3,444.3 | 0.48 |
| show warnings | 19,912 | 3,325.9 | 0.47 |
| replace | 3,825 | 638.9 | 0.09 |
| show binlogs | 608 | 101.6 | 0.01 |
| show storage engines | 459 | 76.7 | 0.01 |
| stmt close | 174 | 29.1 | <0.01 |
| stmt execute | 174 | 29.1 | <0.01 |
| stmt prepare | 174 | 29.1 | <0.01 |
| show slave status | 89 | 14.9 | <0.01 |
| show master status | 80 | 13.4 | <0.01 |
| show table status | 78 | 13 | <0.01 |
| show status | 44 | 7.3 | <0.01 |
| show processlist | 5 | 0.8 | <0.01 |
| flush | 2 | 0.3 | <0.01 |
| show engine status | 2 | 0.3 | <0.01 |