| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 247 k | 34.7 k | 52.80 |
| set option | 59,925 | 8,405.3 | 12.80 |
| show keys | 34,919 | 4,897.9 | 7.46 |
| change db | 32,950 | 4,621.7 | 7.04 |
| show fields | 31,260 | 4,384.6 | 6.67 |
| show tables | 31,076 | 4,358.8 | 6.64 |
| show variables | 13,358 | 1,873.6 | 2.85 |
| show create table | 8,604 | 1,206.8 | 1.84 |
| show warnings | 5,442 | 763.3 | 1.16 |
| show storage engines | 1,796 | 251.9 | 0.38 |
| show grants | 437 | 61.3 | 0.09 |
| show binlogs | 289 | 40.5 | 0.06 |
| show table status | 212 | 29.7 | 0.05 |
| show slave status | 155 | 21.7 | 0.03 |
| show master status | 148 | 20.8 | 0.03 |
| stmt close | 108 | 15.1 | 0.02 |
| stmt execute | 108 | 15.1 | 0.02 |
| stmt prepare | 108 | 15.1 | 0.02 |
| update | 68 | 9.5 | 0.01 |
| show create proc | 39 | 5.5 | 0.01 |
| show status | 34 | 4.8 | 0.01 |
| show processlist | 5 | 0.7 | <0.01 |
| flush | 2 | 0.3 | <0.01 |
| insert | 2 | 0.3 | <0.01 |
| show engine status | 2 | 0.3 | <0.01 |