| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 49,563 | 65 | 55.94 |
| set option | 10,584 | 13.9 | 11.95 |
| show tables | 6,156 | 8.1 | 6.95 |
| show keys | 5,036 | 6.6 | 5.68 |
| show fields | 4,545 | 6 | 5.13 |
| change db | 2,962 | 3.9 | 3.34 |
| show variables | 1,871 | 2.5 | 2.11 |
| insert | 1,846 | 2.4 | 2.08 |
| show create table | 1,193 | 1.6 | 1.35 |
| begin | 1,090 | 1.4 | 1.23 |
| commit | 1,090 | 1.4 | 1.23 |
| update | 1,006 | 1.3 | 1.14 |
| show grants | 542 | 0.7 | 0.61 |
| show warnings | 319 | 0.4 | 0.36 |
| show storage engines | 233 | 0.3 | 0.26 |
| show binlogs | 172 | 0.2 | 0.19 |
| stmt close | 72 | 0.1 | 0.08 |
| stmt execute | 72 | 0.1 | 0.08 |
| stmt prepare | 72 | 0.1 | 0.08 |
| show slave status | 48 | 0.1 | 0.05 |
| show master status | 45 | 0.1 | 0.05 |
| show table status | 44 | 0.1 | 0.05 |
| show status | 28 | <0.1 | 0.03 |
| show processlist | 4 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |