| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 90,145 k | 39.5 k | 40.31 |
| rollback | 88,894 k | 39 k | 39.76 |
| update | 39,804 k | 17.4 k | 17.80 |
| commit | 3,389 k | 1,485.3 | 1.52 |
| show tables | 270 k | 118.5 | 0.12 |
| show fields | 261 k | 114.4 | 0.12 |
| set option | 236 k | 103.3 | 0.11 |
| change db | 192 k | 84.2 | 0.09 |
| show keys | 125 k | 54.9 | 0.06 |
| delete | 125 k | 54.9 | 0.06 |
| show variables | 47,169 | 20.7 | 0.02 |
| replace | 42,126 | 18.5 | 0.02 |
| show create table | 31,762 | 13.9 | 0.01 |
| show warnings | 19,661 | 8.6 | 0.01 |
| insert | 7,059 | 3.1 | <0.01 |
| show storage engines | 6,063 | 2.7 | <0.01 |
| show grants | 3,783 | 1.7 | <0.01 |
| show table status | 906 | 0.4 | <0.01 |
| show slave status | 643 | 0.3 | <0.01 |
| show master status | 624 | 0.3 | <0.01 |
| stmt close | 610 | 0.3 | <0.01 |
| stmt execute | 610 | 0.3 | <0.01 |
| stmt prepare | 610 | 0.3 | <0.01 |
| show binlogs | 532 | 0.2 | <0.01 |
| show status | 84 | <0.1 | <0.01 |
| show processlist | 11 | <0.1 | <0.01 |
| show engine status | 8 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
| grant | 1 | <0.1 | <0.01 |