| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 38,890 | 19.5 k | 81.30 |
| show tables | 2,367 | 1,187.8 | 4.95 |
| show fields | 2,125 | 1,066.4 | 4.44 |
| change db | 1,749 | 877.7 | 3.66 |
| set option | 1,299 | 651.9 | 2.72 |
| show keys | 869 | 436.1 | 1.82 |
| show variables | 329 | 165.1 | 0.69 |
| show table status | 33 | 16.6 | 0.07 |
| show create table | 29 | 14.6 | 0.06 |
| replace | 24 | 12 | 0.05 |
| show slave status | 24 | 12 | 0.05 |
| show binlog status | 22 | 11 | 0.05 |
| show storage engines | 18 | 9 | 0.04 |
| show grants | 14 | 7 | 0.03 |
| show binlogs | 13 | 6.5 | 0.03 |
| show status | 7 | 3.5 | 0.01 |
| show warnings | 7 | 3.5 | 0.01 |
| stmt close | 6 | 3 | 0.01 |
| stmt execute | 6 | 3 | 0.01 |
| stmt prepare | 6 | 3 | 0.01 |
| show processlist | 1 | 0.5 | <0.01 |