| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 142 k | 29.8 k | 82.76 |
| show tables | 7,480 | 1,574.6 | 4.37 |
| show fields | 6,460 | 1,359.8 | 3.77 |
| change db | 5,441 | 1,145.3 | 3.18 |
| set option | 3,778 | 795.3 | 2.21 |
| show keys | 2,924 | 615.5 | 1.71 |
| show variables | 809 | 170.3 | 0.47 |
| replace | 579 | 121.9 | 0.34 |
| show create table | 478 | 100.6 | 0.28 |
| show grants | 404 | 85 | 0.24 |
| stmt execute | 267 | 56.2 | 0.16 |
| show binlogs | 168 | 35.4 | 0.10 |
| show storage engines | 160 | 33.7 | 0.09 |
| stmt prepare | 132 | 27.8 | 0.08 |
| show warnings | 110 | 23.2 | 0.06 |
| stmt close | 99 | 20.8 | 0.06 |
| show slave status | 52 | 10.9 | 0.03 |
| show master status | 48 | 10.1 | 0.03 |
| show table status | 45 | 9.5 | 0.03 |
| update | 31 | 6.5 | 0.02 |
| show status | 23 | 4.8 | 0.01 |
| insert | 9 | 1.9 | 0.01 |
| show processlist | 3 | 0.6 | <0.01 |
| flush | 1 | 0.2 | <0.01 |
| show engine status | 1 | 0.2 | <0.01 |