| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 19,965 k | 32 k | 79.83 |
| change db | 1,128 k | 1,806.6 | 4.51 |
| show fields | 1,019 k | 1,631.6 | 4.07 |
| show tables | 816 k | 1,306.5 | 3.26 |
| set option | 785 k | 1,258.1 | 3.14 |
| insert | 268 k | 430 | 1.07 |
| show keys | 249 k | 399.6 | 1.00 |
| show create table | 181 k | 290.3 | 0.72 |
| show variables | 179 k | 286.8 | 0.72 |
| replace | 116 k | 185.4 | 0.46 |
| show warnings | 81,696 | 130.9 | 0.33 |
| show table status | 68,413 | 109.6 | 0.27 |
| show triggers | 61,990 | 99.3 | 0.25 |
| update | 26,238 | 42 | 0.10 |
| delete | 22,642 | 36.3 | 0.09 |
| show storage engines | 21,702 | 34.8 | 0.09 |
| commit | 9,642 | 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 | 846 | 1.4 | <0.01 |
| show binlogs | 766 | 1.2 | <0.01 |
| rollback | 158 | 0.3 | <0.01 |
| show slave status | 154 | 0.2 | <0.01 |
| show master status | 145 | 0.2 | <0.01 |
| show databases | 28 | <0.1 | <0.01 |
| show status | 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 processlist | 3 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |