| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 2,109 k | 9,359.2 | 71.79 |
| stmt close | 165 k | 733.4 | 5.63 |
| stmt prepare | 165 k | 733.4 | 5.63 |
| stmt execute | 165 k | 732.8 | 5.62 |
| show tables | 80,290 | 356.3 | 2.73 |
| set option | 74,444 | 330.4 | 2.53 |
| show fields | 71,152 | 315.7 | 2.42 |
| change db | 59,895 | 265.8 | 2.04 |
| show keys | 15,802 | 70.1 | 0.54 |
| show create table | 13,857 | 61.5 | 0.47 |
| replace | 5,753 | 25.5 | 0.20 |
| show variables | 4,902 | 21.8 | 0.17 |
| show grants | 1,624 | 7.2 | 0.06 |
| show storage engines | 1,279 | 5.7 | 0.04 |
| show table status | 1,237 | 5.5 | 0.04 |
| show warnings | 1,004 | 4.5 | 0.03 |
| update | 473 | 2.1 | 0.02 |
| insert | 314 | 1.4 | 0.01 |
| show binlogs | 218 | 1 | 0.01 |
| show slave status | 171 | 0.8 | 0.01 |
| show master status | 168 | 0.7 | 0.01 |
| delete | 160 | 0.7 | 0.01 |
| create table | 91 | 0.4 | <0.01 |
| lock tables | 60 | 0.3 | <0.01 |
| unlock tables | 60 | 0.3 | <0.01 |
| insert select | 51 | 0.2 | <0.01 |
| alter table | 39 | 0.2 | <0.01 |
| begin | 20 | 0.1 | <0.01 |
| commit | 20 | 0.1 | <0.01 |
| show status | 15 | 0.1 | <0.01 |
| show processlist | 3 | <0.1 | <0.01 |
| create db | 2 | <0.1 | <0.01 |
| delete multi | 2 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| show function status | 2 | <0.1 | <0.01 |
| show procedure status | 2 | <0.1 | <0.01 |
| empty query | 1 | <0.1 | <0.01 |
| truncate | 1 | <0.1 | <0.01 |