| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 786 k | 1,163.5 | 49.98 |
| stmt prepare | 153 k | 226.4 | 9.72 |
| stmt execute | 153 k | 226.4 | 9.72 |
| stmt close | 150 k | 222.7 | 9.56 |
| set option | 89,382 | 132.2 | 5.68 |
| show tables | 69,546 | 102.9 | 4.42 |
| show keys | 41,270 | 61.1 | 2.62 |
| show fields | 39,358 | 58.2 | 2.50 |
| change db | 30,285 | 44.8 | 1.92 |
| show variables | 27,003 | 40 | 1.72 |
| show create table | 10,096 | 14.9 | 0.64 |
| show warnings | 6,923 | 10.2 | 0.44 |
| show grants | 5,750 | 8.5 | 0.37 |
| show binlogs | 5,541 | 8.2 | 0.35 |
| show storage engines | 1,853 | 2.7 | 0.12 |
| insert | 1,234 | 1.8 | 0.08 |
| show table status | 1,148 | 1.7 | 0.07 |
| update | 624 | 0.9 | 0.04 |
| show slave status | 165 | 0.2 | 0.01 |
| show master status | 158 | 0.2 | 0.01 |
| delete | 97 | 0.1 | 0.01 |
| begin | 49 | 0.1 | <0.01 |
| commit | 48 | 0.1 | <0.01 |
| show create proc | 34 | 0.1 | <0.01 |
| show status | 28 | <0.1 | <0.01 |
| show create func | 17 | <0.1 | <0.01 |
| update multi | 4 | <0.1 | <0.01 |
| create table | 3 | <0.1 | <0.01 |
| show processlist | 3 | <0.1 | <0.01 |
| create index | 2 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |
| alter table | 1 | <0.1 | <0.01 |
| rollback | 1 | <0.1 | <0.01 |