| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 2,554 k | 11.3 k | 72.51 |
| stmt close | 165 k | 729.8 | 4.69 |
| stmt prepare | 165 k | 729.8 | 4.69 |
| stmt execute | 165 k | 729.2 | 4.69 |
| show tables | 113 k | 499.7 | 3.21 |
| show fields | 107 k | 470.6 | 3.03 |
| set option | 90,274 | 398.6 | 2.56 |
| change db | 83,103 | 366.9 | 2.36 |
| show keys | 31,688 | 139.9 | 0.90 |
| show create table | 19,128 | 84.5 | 0.54 |
| replace | 10,011 | 44.2 | 0.28 |
| show variables | 8,258 | 36.5 | 0.23 |
| show grants | 2,989 | 13.2 | 0.08 |
| show storage engines | 1,994 | 8.8 | 0.06 |
| show warnings | 1,738 | 7.7 | 0.05 |
| show table status | 1,495 | 6.6 | 0.04 |
| update | 473 | 2.1 | 0.01 |
| insert | 314 | 1.4 | 0.01 |
| show binlogs | 303 | 1.3 | 0.01 |
| show slave status | 199 | 0.9 | 0.01 |
| show master status | 196 | 0.9 | 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 |
| show status | 25 | 0.1 | <0.01 |
| begin | 20 | 0.1 | <0.01 |
| commit | 20 | 0.1 | <0.01 |
| show processlist | 4 | <0.1 | <0.01 |
| flush | 3 | <0.1 | <0.01 |
| create db | 2 | <0.1 | <0.01 |
| delete multi | 2 | <0.1 | <0.01 |
| show engine status | 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 |