| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 341 k | 2,307.2 | 44.38 |
| stmt execute | 80,202 | 543.3 | 10.45 |
| set option | 47,608 | 322.5 | 6.20 |
| show keys | 46,855 | 317.4 | 6.11 |
| stmt prepare | 45,553 | 308.6 | 5.94 |
| stmt close | 45,552 | 308.6 | 5.94 |
| show fields | 44,706 | 302.8 | 5.83 |
| show tables | 40,314 | 273.1 | 5.25 |
| show variables | 20,321 | 137.7 | 2.65 |
| change db | 15,265 | 103.4 | 1.99 |
| show create table | 11,583 | 78.5 | 1.51 |
| insert | 9,607 | 65.1 | 1.25 |
| show warnings | 9,018 | 61.1 | 1.18 |
| update | 6,549 | 44.4 | 0.85 |
| show storage engines | 1,376 | 9.3 | 0.18 |
| begin | 437 | 3 | 0.06 |
| commit | 437 | 3 | 0.06 |
| show grants | 391 | 2.6 | 0.05 |
| show binlogs | 199 | 1.3 | 0.03 |
| delete | 174 | 1.2 | 0.02 |
| show table status | 158 | 1.1 | 0.02 |
| show slave status | 140 | 0.9 | 0.02 |
| show master status | 133 | 0.9 | 0.02 |
| update multi | 73 | 0.5 | 0.01 |
| show status | 34 | 0.2 | <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 processlist | 4 | <0.1 | <0.01 |
| show engine status | 3 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| create db | 1 | <0.1 | <0.01 |
| empty query | 1 | <0.1 | <0.01 |