| Statements | # | ø per hour | % |
|---|---|---|---|
| set option | 83,648 k | 55.2 k | 61.63 |
| select | 29,268 k | 19.3 k | 21.57 |
| commit | 20,716 k | 13.7 k | 15.26 |
| update | 1,103 k | 727.3 | 0.81 |
| show variables | 148 k | 97.5 | 0.11 |
| show tables | 124 k | 82 | 0.09 |
| show collations | 120 k | 79 | 0.09 |
| change db | 112 k | 73.9 | 0.08 |
| show fields | 88,557 | 58.4 | 0.07 |
| show keys | 80,884 | 53.3 | 0.06 |
| insert | 76,114 | 50.2 | 0.06 |
| stmt prepare | 49,249 | 32.5 | 0.04 |
| stmt close | 49,247 | 32.5 | 0.04 |
| stmt execute | 49,247 | 32.5 | 0.04 |
| show grants | 24,512 | 16.2 | 0.02 |
| show create table | 19,693 | 13 | 0.01 |
| delete | 13,035 | 8.6 | 0.01 |
| insert select | 13,019 | 8.6 | 0.01 |
| show warnings | 6,911 | 4.6 | 0.01 |
| show storage engines | 3,478 | 2.3 | <0.01 |
| show binlogs | 3,428 | 2.3 | <0.01 |
| show table status | 967 | 0.6 | <0.01 |
| show slave status | 253 | 0.2 | <0.01 |
| show master status | 236 | 0.2 | <0.01 |
| show status | 144 | 0.1 | <0.01 |
| show charsets | 27 | <0.1 | <0.01 |
| show processlist | 16 | <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 | 7 | <0.1 | <0.01 |
| create table | 2 | <0.1 | <0.01 |
| stmt reset | 2 | <0.1 | <0.01 |
| truncate | 2 | <0.1 | <0.01 |
| rollback | 1 | <0.1 | <0.01 |
| show triggers | 1 | <0.1 | <0.01 |