| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 425 k | 369.6 k | 77.05 |
| show tables | 29,814 | 25.9 k | 5.40 |
| show fields | 27,841 | 24.2 k | 5.04 |
| change db | 20,834 | 18.1 k | 3.77 |
| set option | 16,143 | 14 k | 2.92 |
| show keys | 13,764 | 12 k | 2.49 |
| show variables | 4,955 | 4,305.6 | 0.90 |
| replace | 4,213 | 3,660.8 | 0.76 |
| show create table | 3,122 | 2,712.8 | 0.57 |
| show warnings | 1,882 | 1,635.3 | 0.34 |
| alter table | 1,848 | 1,605.8 | 0.33 |
| update | 654 | 568.3 | 0.12 |
| show storage engines | 568 | 493.6 | 0.10 |
| delete | 133 | 115.6 | 0.02 |
| insert | 133 | 115.6 | 0.02 |
| show grants | 123 | 106.9 | 0.02 |
| show binlogs | 110 | 95.6 | 0.02 |
| stmt close | 95 | 82.5 | 0.02 |
| stmt execute | 95 | 82.5 | 0.02 |
| stmt prepare | 95 | 82.5 | 0.02 |
| show table status | 82 | 71.3 | 0.01 |
| show slave status | 56 | 48.7 | 0.01 |
| show master status | 53 | 46.1 | 0.01 |
| update multi | 49 | 42.6 | 0.01 |
| show status | 13 | 11.3 | <0.01 |
| show processlist | 3 | 2.6 | <0.01 |