| Statements | # | ø per hour | % |
|---|---|---|---|
| set option | 104 M | 55.2 k | 61.89 |
| select | 35,741 k | 19 k | 21.28 |
| commit | 25,731 k | 13.7 k | 15.32 |
| update | 1,371 k | 728.6 | 0.82 |
| show variables | 183 k | 97.1 | 0.11 |
| show collations | 149 k | 79 | 0.09 |
| show tables | 145 k | 77.1 | 0.09 |
| change db | 138 k | 73.5 | 0.08 |
| show fields | 109 k | 57.9 | 0.06 |
| show keys | 99,403 | 52.8 | 0.06 |
| insert | 85,758 | 45.6 | 0.05 |
| stmt prepare | 49,340 | 26.2 | 0.03 |
| stmt close | 49,338 | 26.2 | 0.03 |
| stmt execute | 49,338 | 26.2 | 0.03 |
| show grants | 26,748 | 14.2 | 0.02 |
| show create table | 23,238 | 12.3 | 0.01 |
| delete | 16,902 | 9 | 0.01 |
| insert select | 16,882 | 9 | 0.01 |
| show warnings | 7,338 | 3.9 | <0.01 |
| show binlogs | 5,316 | 2.8 | <0.01 |
| show storage engines | 3,970 | 2.1 | <0.01 |
| show table status | 1,058 | 0.6 | <0.01 |
| show slave status | 301 | 0.2 | <0.01 |
| show master status | 281 | 0.1 | <0.01 |
| show status | 172 | 0.1 | <0.01 |
| show charsets | 33 | <0.1 | <0.01 |
| show processlist | 19 | <0.1 | <0.01 |
| show databases | 18 | <0.1 | <0.01 |
| show function status | 15 | <0.1 | <0.01 |
| show procedure status | 15 | <0.1 | <0.01 |
| show engine status | 12 | <0.1 | <0.01 |
| flush | 8 | <0.1 | <0.01 |
| create table | 2 | <0.1 | <0.01 |
| rollback | 2 | <0.1 | <0.01 |
| stmt reset | 2 | <0.1 | <0.01 |
| truncate | 2 | <0.1 | <0.01 |
| show triggers | 1 | <0.1 | <0.01 |