| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 1,894 k | 1,226.9 | 77.10 |
| show tables | 132 k | 85.5 | 5.37 |
| show fields | 125 k | 81.2 | 5.10 |
| change db | 93,207 | 60.4 | 3.80 |
| set option | 69,519 | 45 | 2.83 |
| show keys | 66,985 | 43.4 | 2.73 |
| show variables | 23,768 | 15.4 | 0.97 |
| replace | 20,205 | 13.1 | 0.82 |
| show create table | 14,881 | 9.6 | 0.61 |
| show warnings | 9,571 | 6.2 | 0.39 |
| show storage engines | 2,594 | 1.7 | 0.11 |
| show grants | 1,320 | 0.9 | 0.05 |
| stmt prepare | 739 | 0.5 | 0.03 |
| stmt close | 494 | 0.3 | 0.02 |
| stmt execute | 494 | 0.3 | 0.02 |
| show binlogs | 493 | 0.3 | 0.02 |
| show slave status | 246 | 0.2 | 0.01 |
| show table status | 241 | 0.2 | 0.01 |
| show master status | 233 | 0.2 | 0.01 |
| show status | 83 | 0.1 | <0.01 |
| show processlist | 11 | <0.1 | <0.01 |
| show engine status | 7 | <0.1 | <0.01 |
| flush | 5 | <0.1 | <0.01 |