| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 20,147 k | 32.1 k | 79.81 |
| change db | 1,135 k | 1,811 | 4.50 |
| show fields | 1,033 k | 1,647.1 | 4.09 |
| show tables | 826 k | 1,318.4 | 3.27 |
| set option | 791 k | 1,261.4 | 3.13 |
| insert | 269 k | 429.2 | 1.07 |
| show keys | 258 k | 411.8 | 1.02 |
| show create table | 182 k | 290.3 | 0.72 |
| show variables | 180 k | 287.7 | 0.71 |
| replace | 117 k | 186.7 | 0.46 |
| show warnings | 82,036 | 130.9 | 0.32 |
| show table status | 68,459 | 109.2 | 0.27 |
| show triggers | 61,990 | 98.9 | 0.25 |
| update | 26,337 | 42 | 0.10 |
| delete | 22,660 | 36.1 | 0.09 |
| show storage engines | 21,905 | 34.9 | 0.09 |
| commit | 9,649 | 15.4 | 0.04 |
| stmt close | 2,712 | 4.3 | 0.01 |
| stmt execute | 2,712 | 4.3 | 0.01 |
| stmt prepare | 2,712 | 4.3 | 0.01 |
| show grants | 1,469 | 2.3 | 0.01 |
| show binlogs | 972 | 1.6 | <0.01 |
| show slave status | 182 | 0.3 | <0.01 |
| show master status | 171 | 0.3 | <0.01 |
| rollback | 168 | 0.3 | <0.01 |
| show status | 52 | 0.1 | <0.01 |
| show databases | 28 | <0.1 | <0.01 |
| empty query | 26 | <0.1 | <0.01 |
| show collations | 26 | <0.1 | <0.01 |
| show create db | 26 | <0.1 | <0.01 |
| show function status | 26 | <0.1 | <0.01 |
| show procedure status | 26 | <0.1 | <0.01 |
| show engine status | 5 | <0.1 | <0.01 |
| show processlist | 5 | <0.1 | <0.01 |