| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 314 k | 42.2 k | 78.10 |
| show tables | 23,053 | 3,094.2 | 5.73 |
| show fields | 20,077 | 2,694.8 | 4.99 |
| change db | 15,636 | 2,098.7 | 3.89 |
| set option | 11,676 | 1,567.2 | 2.90 |
| show keys | 7,307 | 980.8 | 1.82 |
| replace | 3,040 | 408 | 0.76 |
| show variables | 2,634 | 353.5 | 0.65 |
| show create table | 2,033 | 272.9 | 0.51 |
| show storage engines | 873 | 117.2 | 0.22 |
| show warnings | 843 | 113.2 | 0.21 |
| stmt prepare | 204 | 27.4 | 0.05 |
| stmt close | 156 | 20.9 | 0.04 |
| stmt execute | 156 | 20.9 | 0.04 |
| show table status | 147 | 19.7 | 0.04 |
| show slave status | 71 | 9.5 | 0.02 |
| show master status | 66 | 8.9 | 0.02 |
| show grants | 46 | 6.2 | 0.01 |
| show binlogs | 30 | 4 | 0.01 |
| insert | 27 | 3.6 | 0.01 |
| delete | 26 | 3.5 | 0.01 |
| show status | 23 | 3.1 | 0.01 |
| update | 15 | 2 | <0.01 |
| show processlist | 3 | 0.4 | <0.01 |
| show engine status | 1 | 0.1 | <0.01 |