| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 505 k | 5,125.6 | 81.10 |
| show tables | 25,741 | 261.2 | 4.13 |
| show fields | 21,337 | 216.5 | 3.43 |
| change db | 17,762 | 180.2 | 2.85 |
| set option | 12,558 | 127.4 | 2.02 |
| show keys | 9,084 | 92.2 | 1.46 |
| stmt execute | 6,607 | 67 | 1.06 |
| stmt prepare | 6,426 | 65.2 | 1.03 |
| stmt close | 6,388 | 64.8 | 1.03 |
| show variables | 2,930 | 29.7 | 0.47 |
| replace | 2,744 | 27.8 | 0.44 |
| show grants | 1,682 | 17.1 | 0.27 |
| show create table | 1,388 | 14.1 | 0.22 |
| show warnings | 707 | 7.2 | 0.11 |
| show storage engines | 556 | 5.6 | 0.09 |
| insert | 479 | 4.9 | 0.08 |
| show binlogs | 243 | 2.5 | 0.04 |
| alter table | 190 | 1.9 | 0.03 |
| begin | 144 | 1.5 | 0.02 |
| commit | 142 | 1.4 | 0.02 |
| update | 127 | 1.3 | 0.02 |
| show table status | 117 | 1.2 | 0.02 |
| create table | 93 | 0.9 | 0.01 |
| show slave status | 86 | 0.9 | 0.01 |
| show binlog status | 81 | 0.8 | 0.01 |
| show status | 26 | 0.3 | <0.01 |
| update multi | 16 | 0.2 | <0.01 |
| delete | 15 | 0.2 | <0.01 |
| create db | 7 | 0.1 | <0.01 |
| truncate | 5 | 0.1 | <0.01 |
| drop table | 4 | <0.1 | <0.01 |
| drop db | 3 | <0.1 | <0.01 |
| show engine status | 3 | <0.1 | <0.01 |
| show processlist | 3 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
| rollback | 1 | <0.1 | <0.01 |
| show create func | 1 | <0.1 | <0.01 |
| show function status | 1 | <0.1 | <0.01 |
| show procedure status | 1 | <0.1 | <0.01 |