| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 77,400 | 791.5 | 69.35 |
| stmt execute | 5,928 | 60.6 | 5.31 |
| stmt prepare | 5,753 | 58.8 | 5.16 |
| stmt close | 5,715 | 58.4 | 5.12 |
| show tables | 4,390 | 44.9 | 3.93 |
| show fields | 3,468 | 35.5 | 3.11 |
| change db | 3,167 | 32.4 | 2.84 |
| set option | 2,514 | 25.7 | 2.25 |
| show keys | 945 | 9.7 | 0.85 |
| show variables | 648 | 6.6 | 0.58 |
| insert | 435 | 4.4 | 0.39 |
| alter table | 190 | 1.9 | 0.17 |
| begin | 133 | 1.4 | 0.12 |
| commit | 132 | 1.3 | 0.12 |
| update | 115 | 1.2 | 0.10 |
| show create table | 105 | 1.1 | 0.09 |
| create table | 93 | 1 | 0.08 |
| replace | 87 | 0.9 | 0.08 |
| show warnings | 87 | 0.9 | 0.08 |
| show slave status | 51 | 0.5 | 0.05 |
| show binlog status | 48 | 0.5 | 0.04 |
| show table status | 44 | 0.4 | 0.04 |
| show grants | 35 | 0.4 | 0.03 |
| show storage engines | 35 | 0.4 | 0.03 |
| show binlogs | 21 | 0.2 | 0.02 |
| update multi | 16 | 0.2 | 0.01 |
| delete | 15 | 0.2 | 0.01 |
| show status | 8 | 0.1 | 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 function status | 1 | <0.1 | <0.01 |
| show procedure status | 1 | <0.1 | <0.01 |
| show processlist | 1 | <0.1 | <0.01 |