| Statements | # | ø per hour | % |
|---|---|---|---|
| set option | 83,588 k | 55.2 k | 61.73 |
| select | 29,241 k | 19.3 k | 21.59 |
| commit | 20,702 k | 13.7 k | 15.29 |
| update | 1,102 k | 727.3 | 0.81 |
| show variables | 147 k | 97.1 | 0.11 |
| show tables | 123 k | 81 | 0.09 |
| show collations | 120 k | 79 | 0.09 |
| change db | 111 k | 73.3 | 0.08 |
| show fields | 88,301 | 58.3 | 0.07 |
| show keys | 80,621 | 53.2 | 0.06 |
| insert | 27,286 | 18 | 0.02 |
| show grants | 24,382 | 16.1 | 0.02 |
| show create table | 19,673 | 13 | 0.01 |
| delete | 12,986 | 8.6 | 0.01 |
| insert select | 12,970 | 8.6 | 0.01 |
| show warnings | 6,911 | 4.6 | 0.01 |
| show storage engines | 3,476 | 2.3 | <0.01 |
| show binlogs | 3,306 | 2.2 | <0.01 |
| show table status | 967 | 0.6 | <0.01 |
| stmt prepare | 491 | 0.3 | <0.01 |
| stmt close | 489 | 0.3 | <0.01 |
| stmt execute | 489 | 0.3 | <0.01 |
| show slave status | 247 | 0.2 | <0.01 |
| show master status | 230 | 0.2 | <0.01 |
| show status | 137 | 0.1 | <0.01 |
| show charsets | 27 | <0.1 | <0.01 |
| show processlist | 15 | <0.1 | <0.01 |
| show databases | 12 | <0.1 | <0.01 |
| show function status | 12 | <0.1 | <0.01 |
| show procedure status | 12 | <0.1 | <0.01 |
| show engine status | 9 | <0.1 | <0.01 |
| flush | 6 | <0.1 | <0.01 |
| create table | 2 | <0.1 | <0.01 |
| stmt reset | 2 | <0.1 | <0.01 |
| truncate | 1 | <0.1 | <0.01 |