| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 23,900 | 363.6 | 50.06 |
| set option | 6,182 | 94 | 12.95 |
| show tables | 5,265 | 80.1 | 11.03 |
| show keys | 3,247 | 49.4 | 6.80 |
| show fields | 2,728 | 41.5 | 5.71 |
| change db | 2,534 | 38.5 | 5.31 |
| show variables | 1,488 | 22.6 | 3.12 |
| show create table | 576 | 8.8 | 1.21 |
| show grants | 449 | 6.8 | 0.94 |
| show storage engines | 205 | 3.1 | 0.43 |
| show binlogs | 189 | 2.9 | 0.40 |
| show warnings | 182 | 2.8 | 0.38 |
| stmt prepare | 168 | 2.6 | 0.35 |
| stmt close | 165 | 2.5 | 0.35 |
| stmt execute | 161 | 2.4 | 0.34 |
| show slave status | 64 | 1 | 0.13 |
| show master status | 60 | 0.9 | 0.13 |
| insert | 51 | 0.8 | 0.11 |
| show table status | 30 | 0.5 | 0.06 |
| update | 26 | 0.4 | 0.05 |
| show status | 22 | 0.3 | 0.05 |
| drop db | 13 | 0.2 | 0.03 |
| alter table | 10 | 0.2 | 0.02 |
| create table | 10 | 0.2 | 0.02 |
| 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 |