| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 20,140 k | 32.1 k | 79.81 |
| change db | 1,135 k | 1,810.6 | 4.50 |
| show fields | 1,032 k | 1,646.6 | 4.09 |
| show tables | 826 k | 1,317.8 | 3.27 |
| set option | 791 k | 1,261.2 | 3.13 |
| insert | 269 k | 429.2 | 1.07 |
| show keys | 258 k | 411.6 | 1.02 |
| show create table | 182 k | 290.2 | 0.72 |
| show variables | 180 k | 287.5 | 0.71 |
| replace | 117 k | 186.6 | 0.46 |
| show warnings | 81,985 | 130.8 | 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,902 | 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,423 | 2.3 | 0.01 |
| show binlogs | 963 | 1.5 | <0.01 |
| show slave status | 178 | 0.3 | <0.01 |
| rollback | 168 | 0.3 | <0.01 |
| show master status | 167 | 0.3 | <0.01 |
| show status | 46 | 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 |