| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 1,157 k | 27.2 k | 27.98 |
| stmt execute | 970 k | 22.8 k | 23.47 |
| stmt close | 970 k | 22.8 k | 23.47 |
| stmt prepare | 970 k | 22.8 k | 23.47 |
| set option | 29,279 | 687.7 | 0.71 |
| show fields | 7,226 | 169.7 | 0.17 |
| insert | 6,436 | 151.2 | 0.16 |
| show tables | 5,740 | 134.8 | 0.14 |
| change db | 4,795 | 112.6 | 0.12 |
| update | 3,573 | 83.9 | 0.09 |
| show keys | 3,384 | 79.5 | 0.08 |
| show create table | 1,417 | 33.3 | 0.03 |
| begin | 1,178 | 27.7 | 0.03 |
| commit | 1,173 | 27.6 | 0.03 |
| show variables | 687 | 16.1 | 0.02 |
| show table status | 265 | 6.2 | 0.01 |
| replace | 233 | 5.5 | 0.01 |
| delete | 179 | 4.2 | <0.01 |
| show grants | 174 | 4.1 | <0.01 |
| show storage engines | 147 | 3.5 | <0.01 |
| show binlogs | 70 | 1.6 | <0.01 |
| show slave status | 46 | 1.1 | <0.01 |
| show master status | 43 | 1 | <0.01 |
| show status | 37 | 0.9 | <0.01 |
| show function status | 19 | 0.4 | <0.01 |
| show procedure status | 19 | 0.4 | <0.01 |
| show triggers | 18 | 0.4 | <0.01 |
| show warnings | 12 | 0.3 | <0.01 |
| show databases | 11 | 0.3 | <0.01 |
| alter table | 9 | 0.2 | <0.01 |
| show open tables | 9 | 0.2 | <0.01 |
| rollback | 6 | 0.1 | <0.01 |
| show collations | 5 | 0.1 | <0.01 |
| truncate | 2 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
| show processlist | 1 | <0.1 | <0.01 |