| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 773 k | 1,146.9 | 49.97 |
| stmt prepare | 153 k | 226.4 | 9.87 |
| stmt execute | 153 k | 226.4 | 9.87 |
| stmt close | 150 k | 222.8 | 9.71 |
| set option | 86,155 | 127.8 | 5.57 |
| show tables | 66,772 | 99 | 4.31 |
| show keys | 39,859 | 59.1 | 2.58 |
| show fields | 37,903 | 56.2 | 2.45 |
| change db | 28,958 | 42.9 | 1.87 |
| show variables | 26,161 | 38.8 | 1.69 |
| show create table | 9,775 | 14.5 | 0.63 |
| show warnings | 6,860 | 10.2 | 0.44 |
| show grants | 5,536 | 8.2 | 0.36 |
| show binlogs | 5,430 | 8.1 | 0.35 |
| show storage engines | 1,760 | 2.6 | 0.11 |
| insert | 1,148 | 1.7 | 0.07 |
| show table status | 1,107 | 1.6 | 0.07 |
| update | 621 | 0.9 | 0.04 |
| show slave status | 147 | 0.2 | 0.01 |
| show master status | 142 | 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 | 30 | <0.1 | <0.01 |
| show status | 24 | <0.1 | <0.01 |
| show create func | 15 | <0.1 | <0.01 |
| update multi | 4 | <0.1 | <0.01 |
| create table | 3 | <0.1 | <0.01 |
| create index | 2 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |
| show processlist | 2 | <0.1 | <0.01 |
| alter table | 1 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
| rollback | 1 | <0.1 | <0.01 |