| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 93,136 | 1,207.1 | 53.87 |
| set option | 21,127 | 273.8 | 12.22 |
| show tables | 18,439 | 239 | 10.66 |
| show fields | 12,086 | 156.6 | 6.99 |
| show keys | 9,195 | 119.2 | 5.32 |
| change db | 6,194 | 80.3 | 3.58 |
| show variables | 3,661 | 47.4 | 2.12 |
| show create table | 2,995 | 38.8 | 1.73 |
| show warnings | 1,045 | 13.5 | 0.60 |
| show storage engines | 1,007 | 13.1 | 0.58 |
| show grants | 755 | 9.8 | 0.44 |
| stmt execute | 693 | 9 | 0.40 |
| stmt close | 638 | 8.3 | 0.37 |
| stmt prepare | 638 | 8.3 | 0.37 |
| show table status | 434 | 5.6 | 0.25 |
| show binlogs | 369 | 4.8 | 0.21 |
| show slave status | 140 | 1.8 | 0.08 |
| show master status | 135 | 1.7 | 0.08 |
| insert | 83 | 1.1 | 0.05 |
| update | 46 | 0.6 | 0.03 |
| show status | 27 | 0.3 | 0.02 |
| 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 |
| show engine status | 3 | <0.1 | <0.01 |
| show processlist | 3 | <0.1 | <0.01 |
| call procedure | 2 | <0.1 | <0.01 |
| create procedure | 2 | <0.1 | <0.01 |