| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 492 k | 1,126.5 | 81.06 |
| show tables | 38,125 | 87.3 | 6.28 |
| show fields | 23,199 | 53.1 | 3.82 |
| change db | 21,429 | 49.1 | 3.53 |
| set option | 19,527 | 44.7 | 3.22 |
| show keys | 4,013 | 9.2 | 0.66 |
| update | 2,488 | 5.7 | 0.41 |
| replace | 1,124 | 2.6 | 0.19 |
| show variables | 950 | 2.2 | 0.16 |
| show create table | 906 | 2.1 | 0.15 |
| show grants | 561 | 1.3 | 0.09 |
| insert | 531 | 1.2 | 0.09 |
| stmt execute | 421 | 1 | 0.07 |
| create table | 312 | 0.7 | 0.05 |
| show storage engines | 295 | 0.7 | 0.05 |
| stmt prepare | 245 | 0.6 | 0.04 |
| show warnings | 204 | 0.5 | 0.03 |
| alter table | 117 | 0.3 | 0.02 |
| show binlogs | 107 | 0.2 | 0.02 |
| delete | 96 | 0.2 | 0.02 |
| stmt close | 72 | 0.2 | 0.01 |
| begin | 42 | 0.1 | 0.01 |
| commit | 42 | 0.1 | 0.01 |
| show slave status | 37 | 0.1 | 0.01 |
| show table status | 37 | 0.1 | 0.01 |
| show master status | 34 | 0.1 | 0.01 |
| show status | 13 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |
| show processlist | 1 | <0.1 | <0.01 |