Console
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 29,040 k | 26 k | 34.17 |
| stmt execute | 27,872 k | 24.9 k | 32.79 |
| update | 5,668 k | 5,065.8 | 6.67 |
| begin | 5,663 k | 5,062 | 6.66 |
| commit | 5,662 k | 5,060.5 | 6.66 |
| stmt prepare | 5,321 k | 4,755.8 | 6.26 |
| stmt close | 5,321 k | 4,755.7 | 6.26 |
| show fields | 98,923 | 88.4 | 0.12 |
| show tables | 97,028 | 86.7 | 0.11 |
| change db | 68,722 | 61.4 | 0.08 |
| set option | 54,563 | 48.8 | 0.06 |
| show keys | 52,687 | 47.1 | 0.06 |
| show variables | 20,895 | 18.7 | 0.02 |
| show grants | 13,090 | 11.7 | 0.02 |
| show create table | 10,984 | 9.8 | 0.01 |
| show warnings | 9,519 | 8.5 | 0.01 |
| insert | 7,783 | 7 | 0.01 |
| replace | 4,489 | 4 | 0.01 |
| rollback | 1,543 | 1.4 | <0.01 |
| show storage engines | 979 | 0.9 | <0.01 |
| show binlogs | 594 | 0.5 | <0.01 |
| show table status | 196 | 0.2 | <0.01 |
| show slave status | 147 | 0.1 | <0.01 |
| show master status | 139 | 0.1 | <0.01 |
| insert select | 137 | 0.1 | <0.01 |
| unlock tables | 94 | 0.1 | <0.01 |
| show status | 33 | <0.1 | <0.01 |
| delete | 16 | <0.1 | <0.01 |
| create table | 13 | <0.1 | <0.01 |
| show processlist | 4 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
| update multi | 1 | <0.1 | <0.01 |