| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 77,755 | 146.1 | 74.22 |
| show tables | 4,798 | 9 | 4.58 |
| change db | 3,598 | 6.8 | 3.43 |
| insert | 3,255 | 6.1 | 3.11 |
| show fields | 3,099 | 5.8 | 2.96 |
| stmt execute | 3,013 | 5.7 | 2.88 |
| update | 2,923 | 5.5 | 2.79 |
| set option | 2,796 | 5.3 | 2.67 |
| delete | 1,014 | 1.9 | 0.97 |
| replace | 828 | 1.6 | 0.79 |
| show variables | 721 | 1.4 | 0.69 |
| show keys | 292 | 0.5 | 0.28 |
| show grants | 262 | 0.5 | 0.25 |
| show binlogs | 226 | 0.4 | 0.22 |
| show create table | 42 | 0.1 | 0.04 |
| show slave status | 35 | 0.1 | 0.03 |
| show master status | 33 | 0.1 | 0.03 |
| show table status | 16 | <0.1 | 0.02 |
| show status | 9 | <0.1 | 0.01 |
| show storage engines | 9 | <0.1 | 0.01 |
| create table | 8 | <0.1 | 0.01 |
| show warnings | 7 | <0.1 | 0.01 |
| stmt prepare | 6 | <0.1 | 0.01 |
| alter table | 2 | <0.1 | <0.01 |
| show collations | 2 | <0.1 | <0.01 |
| show databases | 2 | <0.1 | <0.01 |
| show function status | 2 | <0.1 | <0.01 |
| show open tables | 2 | <0.1 | <0.01 |
| show procedure status | 2 | <0.1 | <0.01 |
| show triggers | 2 | <0.1 | <0.01 |
| show processlist | 1 | <0.1 | <0.01 |