| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 72,522 | 949.4 | 54.21 |
| set option | 16,837 | 220.4 | 12.59 |
| show tables | 14,193 | 185.8 | 10.61 |
| show fields | 9,111 | 119.3 | 6.81 |
| show keys | 6,719 | 88 | 5.02 |
| change db | 4,419 | 57.9 | 3.30 |
| show variables | 2,616 | 34.2 | 1.96 |
| show create table | 2,231 | 29.2 | 1.67 |
| show storage engines | 859 | 11.2 | 0.64 |
| show warnings | 771 | 10.1 | 0.58 |
| stmt execute | 693 | 9.1 | 0.52 |
| stmt close | 638 | 8.4 | 0.48 |
| stmt prepare | 638 | 8.4 | 0.48 |
| show grants | 460 | 6 | 0.34 |
| show binlogs | 325 | 4.3 | 0.24 |
| show table status | 283 | 3.7 | 0.21 |
| show slave status | 132 | 1.7 | 0.10 |
| show master status | 128 | 1.7 | 0.10 |
| insert | 83 | 1.1 | 0.06 |
| update | 46 | 0.6 | 0.03 |
| show status | 20 | 0.3 | 0.01 |
| alter table | 16 | 0.2 | 0.01 |
| insert select | 15 | 0.2 | 0.01 |
| create table | 6 | 0.1 | <0.01 |
| drop procedure | 4 | 0.1 | <0.01 |
| call procedure | 2 | <0.1 | <0.01 |
| create procedure | 2 | <0.1 | <0.01 |
| show processlist | 2 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |