| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 333 k | 2,276.2 | 44.27 |
| stmt execute | 80,193 | 548.8 | 10.67 |
| show keys | 45,704 | 312.8 | 6.08 |
| set option | 45,700 | 312.7 | 6.08 |
| stmt prepare | 45,544 | 311.7 | 6.06 |
| stmt close | 45,543 | 311.7 | 6.06 |
| show fields | 43,623 | 298.5 | 5.81 |
| show tables | 38,590 | 264.1 | 5.14 |
| show variables | 19,815 | 135.6 | 2.64 |
| change db | 14,357 | 98.3 | 1.91 |
| show create table | 11,365 | 77.8 | 1.51 |
| insert | 9,607 | 65.7 | 1.28 |
| show warnings | 8,950 | 61.2 | 1.19 |
| update | 6,549 | 44.8 | 0.87 |
| show storage engines | 1,293 | 8.8 | 0.17 |
| begin | 437 | 3 | 0.06 |
| commit | 437 | 3 | 0.06 |
| show grants | 182 | 1.2 | 0.02 |
| delete | 174 | 1.2 | 0.02 |
| show table status | 152 | 1 | 0.02 |
| show slave status | 124 | 0.8 | 0.02 |
| show master status | 118 | 0.8 | 0.02 |
| show binlogs | 112 | 0.8 | 0.01 |
| update multi | 73 | 0.5 | 0.01 |
| alter table | 24 | 0.2 | <0.01 |
| show status | 21 | 0.1 | <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 | 3 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |
| create db | 1 | <0.1 | <0.01 |
| empty query | 1 | <0.1 | <0.01 |