| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 344 k | 2,306.5 | 44.43 |
| stmt execute | 80,202 | 538.2 | 10.37 |
| set option | 48,295 | 324.1 | 6.24 |
| show keys | 47,244 | 317 | 6.11 |
| stmt prepare | 45,553 | 305.7 | 5.89 |
| stmt close | 45,552 | 305.7 | 5.89 |
| show fields | 45,200 | 303.3 | 5.84 |
| show tables | 41,004 | 275.2 | 5.30 |
| show variables | 20,530 | 137.8 | 2.65 |
| change db | 15,596 | 104.7 | 2.02 |
| show create table | 11,698 | 78.5 | 1.51 |
| insert | 9,607 | 64.5 | 1.24 |
| show warnings | 9,088 | 61 | 1.17 |
| update | 6,549 | 43.9 | 0.85 |
| show storage engines | 1,399 | 9.4 | 0.18 |
| show grants | 510 | 3.4 | 0.07 |
| begin | 437 | 2.9 | 0.06 |
| commit | 437 | 2.9 | 0.06 |
| show binlogs | 238 | 1.6 | 0.03 |
| delete | 174 | 1.2 | 0.02 |
| show table status | 160 | 1.1 | 0.02 |
| show slave status | 147 | 1 | 0.02 |
| show master status | 140 | 0.9 | 0.02 |
| update multi | 73 | 0.5 | 0.01 |
| show status | 44 | 0.3 | 0.01 |
| alter table | 24 | 0.2 | <0.01 |
| lock tables | 16 | 0.1 | <0.01 |
| unlock tables | 16 | 0.1 | <0.01 |
| create table | 11 | 0.1 | <0.01 |
| drop table | 9 | 0.1 | <0.01 |
| show engine status | 5 | <0.1 | <0.01 |
| show processlist | 5 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| create db | 1 | <0.1 | <0.01 |
| empty query | 1 | <0.1 | <0.01 |