| Statements | # | ø per hour | % |
|---|---|---|---|
| set option | 18,868 k | 55.1 k | 61.78 |
| select | 6,588 k | 19.2 k | 21.57 |
| commit | 4,677 k | 13.7 k | 15.31 |
| update | 249 k | 728 | 0.82 |
| show variables | 33,534 | 98 | 0.11 |
| show collations | 27,046 | 79 | 0.09 |
| show tables | 24,246 | 70.8 | 0.08 |
| change db | 20,569 | 60.1 | 0.07 |
| show fields | 14,971 | 43.7 | 0.05 |
| show keys | 12,453 | 36.4 | 0.04 |
| insert | 6,870 | 20.1 | 0.02 |
| show create table | 3,873 | 11.3 | 0.01 |
| delete | 3,327 | 9.7 | 0.01 |
| insert select | 3,321 | 9.7 | 0.01 |
| show grants | 1,864 | 5.4 | 0.01 |
| show warnings | 1,707 | 5 | 0.01 |
| show storage engines | 757 | 2.2 | <0.01 |
| show binlogs | 527 | 1.5 | <0.01 |
| show table status | 288 | 0.8 | <0.01 |
| stmt prepare | 241 | 0.7 | <0.01 |
| stmt close | 239 | 0.7 | <0.01 |
| stmt execute | 239 | 0.7 | <0.01 |
| show slave status | 119 | 0.3 | <0.01 |
| show master status | 111 | 0.3 | <0.01 |
| show status | 60 | 0.2 | <0.01 |
| show processlist | 8 | <0.1 | <0.01 |
| show charsets | 6 | <0.1 | <0.01 |
| flush | 4 | <0.1 | <0.01 |
| show engine status | 4 | <0.1 | <0.01 |
| show function status | 4 | <0.1 | <0.01 |
| show procedure status | 4 | <0.1 | <0.01 |
| show databases | 2 | <0.1 | <0.01 |