| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 395 k | 1,082.3 | 28.65 |
| stmt execute | 209 k | 573.4 | 15.18 |
| show fields | 137 k | 376.5 | 9.96 |
| stmt prepare | 137 k | 375.5 | 9.94 |
| stmt close | 137 k | 374.8 | 9.92 |
| insert | 84,134 | 230.6 | 6.10 |
| set option | 66,658 | 182.7 | 4.84 |
| show keys | 61,987 | 169.9 | 4.50 |
| show tables | 54,001 | 148 | 3.92 |
| create table | 25,149 | 68.9 | 1.82 |
| show variables | 21,247 | 58.2 | 1.54 |
| change db | 19,361 | 53.1 | 1.40 |
| show create table | 13,516 | 37 | 0.98 |
| show warnings | 8,132 | 22.3 | 0.59 |
| show storage engines | 3,277 | 9 | 0.24 |
| update | 2,737 | 7.5 | 0.20 |
| show grants | 716 | 2 | 0.05 |
| alter table | 604 | 1.7 | 0.04 |
| show table status | 411 | 1.1 | 0.03 |
| show binlogs | 298 | 0.8 | 0.02 |
| show slave status | 208 | 0.6 | 0.02 |
| show master status | 202 | 0.6 | 0.01 |
| insert select | 199 | 0.5 | 0.01 |
| begin | 86 | 0.2 | 0.01 |
| create db | 70 | 0.2 | 0.01 |
| commit | 65 | 0.2 | <0.01 |
| delete | 60 | 0.2 | <0.01 |
| show create func | 42 | 0.1 | <0.01 |
| show status | 41 | 0.1 | <0.01 |
| update multi | 23 | 0.1 | <0.01 |
| rollback | 19 | 0.1 | <0.01 |
| delete multi | 6 | <0.1 | <0.01 |
| show processlist | 5 | <0.1 | <0.01 |
| empty query | 4 | <0.1 | <0.01 |
| show engine status | 4 | <0.1 | <0.01 |
| flush | 3 | <0.1 | <0.01 |
| drop trigger | 2 | <0.1 | <0.01 |
| call procedure | 1 | <0.1 | <0.01 |
| show create trigger | 1 | <0.1 | <0.01 |
| signal | 1 | <0.1 | <0.01 |