| Statements | # | ø per hour | % |
|---|---|---|---|
| set option | 104 M | 55.2 k | 61.87 |
| select | 35,772 k | 19 k | 21.29 |
| commit | 25,734 k | 13.7 k | 15.32 |
| update | 1,371 k | 728.6 | 0.82 |
| show variables | 184 k | 97.8 | 0.11 |
| show tables | 151 k | 80 | 0.09 |
| show collations | 149 k | 79 | 0.09 |
| change db | 141 k | 74.7 | 0.08 |
| show fields | 114 k | 60.4 | 0.07 |
| show keys | 103 k | 54.9 | 0.06 |
| insert | 85,761 | 45.6 | 0.05 |
| stmt prepare | 49,410 | 26.2 | 0.03 |
| stmt close | 49,408 | 26.2 | 0.03 |
| stmt execute | 49,408 | 26.2 | 0.03 |
| show grants | 26,768 | 14.2 | 0.02 |
| show create table | 24,353 | 12.9 | 0.01 |
| delete | 16,903 | 9 | 0.01 |
| insert select | 16,883 | 9 | 0.01 |
| show warnings | 7,624 | 4.1 | <0.01 |
| show binlogs | 5,319 | 2.8 | <0.01 |
| show storage engines | 4,231 | 2.2 | <0.01 |
| show table status | 1,155 | 0.6 | <0.01 |
| show slave status | 312 | 0.2 | <0.01 |
| show master status | 292 | 0.2 | <0.01 |
| show status | 179 | 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 | 13 | <0.1 | <0.01 |
| flush | 9 | <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 |