| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 259 k | 299.3 | 29.66 |
| stmt execute | 194 k | 224.2 | 22.22 |
| stmt prepare | 194 k | 224 | 22.19 |
| stmt close | 189 k | 218.5 | 21.65 |
| set option | 19,111 | 22.1 | 2.19 |
| show tables | 7,426 | 8.6 | 0.85 |
| insert | 3,048 | 3.5 | 0.35 |
| change db | 1,808 | 2.1 | 0.21 |
| show fields | 1,365 | 1.6 | 0.16 |
| show keys | 1,261 | 1.5 | 0.14 |
| show variables | 775 | 0.9 | 0.09 |
| show grants | 652 | 0.8 | 0.07 |
| show binlogs | 402 | 0.5 | 0.05 |
| update | 399 | 0.5 | 0.05 |
| show create table | 317 | 0.4 | 0.04 |
| delete | 301 | 0.3 | 0.03 |
| show slave status | 141 | 0.2 | 0.02 |
| show master status | 132 | 0.2 | 0.02 |
| show table status | 67 | 0.1 | 0.01 |
| begin | 46 | 0.1 | 0.01 |
| show warnings | 45 | 0.1 | 0.01 |
| commit | 35 | <0.1 | <0.01 |
| show storage engines | 34 | <0.1 | <0.01 |
| rollback | 11 | <0.1 | <0.01 |
| show status | 11 | <0.1 | <0.01 |
| alter table | 9 | <0.1 | <0.01 |
| show create proc | 6 | <0.1 | <0.01 |
| update multi | 5 | <0.1 | <0.01 |
| show create func | 3 | <0.1 | <0.01 |
| create table | 2 | <0.1 | <0.01 |
| show databases | 1 | <0.1 | <0.01 |