| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 234 k | 16.4 k | 52.69 |
| set option | 44,043 | 3,077.5 | 9.91 |
| show fields | 38,898 | 2,718 | 8.75 |
| show tables | 35,091 | 2,452 | 7.89 |
| show keys | 32,294 | 2,256.6 | 7.27 |
| show variables | 17,849 | 1,247.2 | 4.02 |
| change db | 14,957 | 1,045.1 | 3.37 |
| show create table | 10,976 | 767 | 2.47 |
| show warnings | 7,589 | 530.3 | 1.71 |
| show storage engines | 1,764 | 123.3 | 0.40 |
| stmt close | 1,657 | 115.8 | 0.37 |
| stmt execute | 1,657 | 115.8 | 0.37 |
| stmt prepare | 1,657 | 115.8 | 0.37 |
| show grants | 845 | 59 | 0.19 |
| show table status | 325 | 22.7 | 0.07 |
| show binlogs | 260 | 18.2 | 0.06 |
| create table | 166 | 11.6 | 0.04 |
| show slave status | 107 | 7.5 | 0.02 |
| show master status | 105 | 7.3 | 0.02 |
| show status | 30 | 2.1 | 0.01 |
| update | 9 | 0.6 | <0.01 |
| alter table | 6 | 0.4 | <0.01 |
| show processlist | 5 | 0.3 | <0.01 |
| show engine status | 3 | 0.2 | <0.01 |
| flush | 2 | 0.1 | <0.01 |
| insert | 2 | 0.1 | <0.01 |
| delete | 1 | 0.1 | <0.01 |