| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 842 k | 10.7 k | 70.48 |
| set option | 165 k | 2,094 | 13.85 |
| show tables | 37,577 | 475.7 | 3.15 |
| show fields | 33,809 | 428 | 2.83 |
| change db | 25,499 | 322.8 | 2.14 |
| stmt execute | 19,010 | 240.6 | 1.59 |
| stmt prepare | 19,010 | 240.6 | 1.59 |
| stmt close | 15,874 | 200.9 | 1.33 |
| show keys | 15,364 | 194.5 | 1.29 |
| replace | 5,874 | 74.4 | 0.49 |
| show variables | 5,507 | 69.7 | 0.46 |
| show create table | 3,720 | 47.1 | 0.31 |
| show warnings | 2,244 | 28.4 | 0.19 |
| insert | 2,170 | 27.5 | 0.18 |
| show storage engines | 1,028 | 13 | 0.09 |
| show slave status | 99 | 1.3 | 0.01 |
| show master status | 94 | 1.2 | 0.01 |
| show table status | 94 | 1.2 | 0.01 |
| show grants | 60 | 0.8 | 0.01 |
| show binlogs | 40 | 0.5 | <0.01 |
| show status | 31 | 0.4 | <0.01 |
| show processlist | 4 | 0.1 | <0.01 |
| delete | 3 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
| update | 1 | <0.1 | <0.01 |