| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 72,420 | 14.5 k | 79.17 |
| show tables | 4,926 | 989.5 | 5.39 |
| change db | 3,914 | 786.2 | 4.28 |
| show fields | 3,410 | 685 | 3.73 |
| set option | 2,793 | 561 | 3.05 |
| insert | 1,490 | 299.3 | 1.63 |
| show variables | 763 | 153.3 | 0.83 |
| show keys | 590 | 118.5 | 0.64 |
| show grants | 195 | 39.2 | 0.21 |
| stmt execute | 152 | 30.5 | 0.17 |
| stmt prepare | 152 | 30.5 | 0.17 |
| show binlogs | 149 | 29.9 | 0.16 |
| stmt close | 148 | 29.7 | 0.16 |
| replace | 102 | 20.5 | 0.11 |
| show create table | 100 | 20.1 | 0.11 |
| show storage engines | 58 | 11.7 | 0.06 |
| show slave status | 34 | 6.8 | 0.04 |
| show master status | 31 | 6.2 | 0.03 |
| show table status | 15 | 3 | 0.02 |
| show status | 8 | 1.6 | 0.01 |
| truncate | 8 | 1.6 | 0.01 |
| create table | 5 | 1 | 0.01 |
| create db | 4 | 0.8 | <0.01 |
| delete | 3 | 0.6 | <0.01 |
| alter table | 1 | 0.2 | <0.01 |
| show databases | 1 | 0.2 | <0.01 |
| show processlist | 1 | 0.2 | <0.01 |
| update | 1 | 0.2 | <0.01 |