| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 103 k | 42.6 k | 79.62 |
| show tables | 7,291 | 3,013.2 | 5.63 |
| show fields | 5,527 | 2,284.1 | 4.27 |
| change db | 5,401 | 2,232.1 | 4.17 |
| set option | 3,876 | 1,601.8 | 2.99 |
| show keys | 1,535 | 634.4 | 1.18 |
| show variables | 952 | 393.4 | 0.73 |
| replace | 400 | 165.3 | 0.31 |
| show create table | 293 | 121.1 | 0.23 |
| show grants | 187 | 77.3 | 0.14 |
| stmt execute | 129 | 53.3 | 0.10 |
| stmt prepare | 129 | 53.3 | 0.10 |
| show storage engines | 110 | 45.5 | 0.08 |
| show warnings | 104 | 43 | 0.08 |
| show binlogs | 101 | 41.7 | 0.08 |
| show slave status | 84 | 34.7 | 0.06 |
| show master status | 80 | 33.1 | 0.06 |
| stmt close | 75 | 31 | 0.06 |
| show table status | 54 | 22.3 | 0.04 |
| update | 34 | 14.1 | 0.03 |
| show status | 22 | 9.1 | 0.02 |
| insert | 9 | 3.7 | 0.01 |
| create table | 6 | 2.5 | <0.01 |
| show processlist | 4 | 1.7 | <0.01 |
| alter table | 1 | 0.4 | <0.01 |
| create db | 1 | 0.4 | <0.01 |
| show engine status | 1 | 0.4 | <0.01 |