| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 18,214 | 277.9 | 50.65 |
| set option | 4,961 | 75.7 | 13.80 |
| show tables | 3,983 | 60.8 | 11.08 |
| show keys | 2,147 | 32.8 | 5.97 |
| change db | 1,925 | 29.4 | 5.35 |
| show fields | 1,672 | 25.5 | 4.65 |
| show variables | 1,171 | 17.9 | 3.26 |
| show create table | 391 | 6 | 1.09 |
| show grants | 292 | 4.5 | 0.81 |
| show binlogs | 174 | 2.7 | 0.48 |
| show storage engines | 170 | 2.6 | 0.47 |
| stmt prepare | 168 | 2.6 | 0.47 |
| stmt close | 165 | 2.5 | 0.46 |
| stmt execute | 161 | 2.5 | 0.45 |
| show warnings | 86 | 1.3 | 0.24 |
| show slave status | 57 | 0.9 | 0.16 |
| show master status | 54 | 0.8 | 0.15 |
| insert | 51 | 0.8 | 0.14 |
| update | 26 | 0.4 | 0.07 |
| show table status | 20 | 0.3 | 0.06 |
| show status | 18 | 0.3 | 0.05 |
| drop db | 13 | 0.2 | 0.04 |
| alter table | 10 | 0.2 | 0.03 |
| create table | 10 | 0.2 | 0.03 |
| create db | 3 | <0.1 | 0.01 |
| drop procedure | 2 | <0.1 | 0.01 |
| flush | 2 | <0.1 | 0.01 |
| lock tables | 2 | <0.1 | 0.01 |
| show engine status | 2 | <0.1 | 0.01 |
| show processlist | 2 | <0.1 | 0.01 |
| unlock tables | 2 | <0.1 | 0.01 |
| call procedure | 1 | <0.1 | <0.01 |
| create procedure | 1 | <0.1 | <0.01 |
| drop table | 1 | <0.1 | <0.01 |
| truncate | 1 | <0.1 | <0.01 |