| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 858 k | 2,407.2 | 78.05 |
| show tables | 61,988 | 174 | 5.64 |
| show fields | 53,583 | 150.4 | 4.88 |
| change db | 41,755 | 117.2 | 3.80 |
| set option | 31,901 | 89.5 | 2.90 |
| show keys | 22,686 | 63.7 | 2.06 |
| replace | 9,067 | 25.4 | 0.82 |
| show variables | 8,450 | 23.7 | 0.77 |
| show create table | 5,493 | 15.4 | 0.50 |
| show warnings | 3,381 | 9.5 | 0.31 |
| show storage engines | 1,406 | 3.9 | 0.13 |
| stmt execute | 293 | 0.8 | 0.03 |
| stmt prepare | 293 | 0.8 | 0.03 |
| stmt close | 292 | 0.8 | 0.03 |
| show table status | 190 | 0.5 | 0.02 |
| show slave status | 168 | 0.5 | 0.02 |
| show master status | 163 | 0.5 | 0.01 |
| show grants | 58 | 0.2 | 0.01 |
| show binlogs | 35 | 0.1 | <0.01 |
| show status | 25 | 0.1 | <0.01 |
| insert | 10 | <0.1 | <0.01 |
| alter table | 8 | <0.1 | <0.01 |
| update | 8 | <0.1 | <0.01 |
| begin | 4 | <0.1 | <0.01 |
| create table | 4 | <0.1 | <0.01 |
| commit | 3 | <0.1 | <0.01 |
| show processlist | 3 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |
| create db | 1 | <0.1 | <0.01 |