| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 666 k | 1,337.5 | 80.69 |
| show tables | 52,393 | 105.2 | 6.34 |
| show fields | 32,565 | 65.4 | 3.94 |
| change db | 29,537 | 59.3 | 3.58 |
| set option | 26,487 | 53.2 | 3.21 |
| show keys | 6,179 | 12.4 | 0.75 |
| update | 2,623 | 5.3 | 0.32 |
| replace | 2,104 | 4.2 | 0.25 |
| show variables | 1,831 | 3.7 | 0.22 |
| show create table | 1,390 | 2.8 | 0.17 |
| show grants | 1,078 | 2.2 | 0.13 |
| insert | 571 | 1.1 | 0.07 |
| stmt execute | 474 | 1 | 0.06 |
| show warnings | 471 | 0.9 | 0.06 |
| show storage engines | 375 | 0.8 | 0.05 |
| create table | 336 | 0.7 | 0.04 |
| stmt prepare | 281 | 0.6 | 0.03 |
| show binlogs | 177 | 0.4 | 0.02 |
| alter table | 126 | 0.3 | 0.02 |
| delete | 106 | 0.2 | 0.01 |
| show table status | 90 | 0.2 | 0.01 |
| stmt close | 90 | 0.2 | 0.01 |
| show slave status | 50 | 0.1 | 0.01 |
| show master status | 46 | 0.1 | 0.01 |
| begin | 45 | 0.1 | 0.01 |
| commit | 45 | 0.1 | 0.01 |
| show status | 27 | 0.1 | <0.01 |
| show processlist | 4 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |