| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 660 k | 80.5 k | 78.34 |
| show tables | 46,687 | 5,696.6 | 5.54 |
| show fields | 41,431 | 5,055.3 | 4.92 |
| change db | 32,500 | 3,965.6 | 3.86 |
| set option | 24,189 | 2,951.5 | 2.87 |
| show keys | 15,655 | 1,910.2 | 1.86 |
| replace | 6,410 | 782.1 | 0.76 |
| show variables | 5,736 | 699.9 | 0.68 |
| show create table | 4,467 | 545.1 | 0.53 |
| show warnings | 1,910 | 233.1 | 0.23 |
| show storage engines | 1,623 | 198 | 0.19 |
| stmt prepare | 349 | 42.6 | 0.04 |
| show grants | 305 | 37.2 | 0.04 |
| stmt close | 253 | 30.9 | 0.03 |
| stmt execute | 253 | 30.9 | 0.03 |
| show table status | 193 | 23.5 | 0.02 |
| show binlogs | 140 | 17.1 | 0.02 |
| show slave status | 119 | 14.5 | 0.01 |
| show master status | 112 | 13.7 | 0.01 |
| show status | 36 | 4.4 | <0.01 |
| insert | 29 | 3.5 | <0.01 |
| delete | 28 | 3.4 | <0.01 |
| update | 16 | 2 | <0.01 |
| show processlist | 4 | 0.5 | <0.01 |
| show engine status | 3 | 0.4 | <0.01 |
| flush | 2 | 0.2 | <0.01 |