| Statements | # | ø per hour | % |
|---|---|---|---|
| set option | 83,724 k | 55.2 k | 61.62 |
| select | 29,314 k | 19.3 k | 21.57 |
| commit | 20,734 k | 13.7 k | 15.26 |
| update | 1,104 k | 727.4 | 0.81 |
| show variables | 149 k | 98.2 | 0.11 |
| show tables | 129 k | 85.1 | 0.09 |
| show collations | 120 k | 79 | 0.09 |
| change db | 114 k | 75.3 | 0.08 |
| show fields | 92,776 | 61.1 | 0.07 |
| show keys | 83,731 | 55.2 | 0.06 |
| insert | 76,269 | 50.3 | 0.06 |
| stmt prepare | 49,263 | 32.5 | 0.04 |
| stmt close | 49,261 | 32.5 | 0.04 |
| stmt execute | 49,261 | 32.5 | 0.04 |
| show grants | 24,753 | 16.3 | 0.02 |
| show create table | 20,435 | 13.5 | 0.02 |
| delete | 13,099 | 8.6 | 0.01 |
| insert select | 13,083 | 8.6 | 0.01 |
| show warnings | 7,099 | 4.7 | 0.01 |
| show storage engines | 3,746 | 2.5 | <0.01 |
| show binlogs | 3,495 | 2.3 | <0.01 |
| show table status | 1,047 | 0.7 | <0.01 |
| show slave status | 268 | 0.2 | <0.01 |
| show master status | 251 | 0.2 | <0.01 |
| show status | 160 | 0.1 | <0.01 |
| show charsets | 27 | <0.1 | <0.01 |
| show processlist | 18 | <0.1 | <0.01 |
| show databases | 12 | <0.1 | <0.01 |
| show engine status | 12 | <0.1 | <0.01 |
| show function status | 12 | <0.1 | <0.01 |
| show procedure status | 12 | <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 |