| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 2,089 k | 2,654 | 61.43 |
| stmt execute | 204 k | 259.7 | 6.01 |
| stmt prepare | 203 k | 257.7 | 5.97 |
| stmt close | 178 k | 225.8 | 5.23 |
| set option | 172 k | 218.3 | 5.05 |
| show fields | 163 k | 207.1 | 4.79 |
| show tables | 142 k | 180 | 4.17 |
| change db | 92,190 | 117.1 | 2.71 |
| show keys | 42,164 | 53.6 | 1.24 |
| insert | 23,466 | 29.8 | 0.69 |
| show variables | 18,757 | 23.8 | 0.55 |
| replace | 16,793 | 21.3 | 0.49 |
| show create table | 15,903 | 20.2 | 0.47 |
| update | 10,154 | 12.9 | 0.30 |
| show warnings | 7,818 | 9.9 | 0.23 |
| begin | 5,006 | 6.4 | 0.15 |
| commit | 4,948 | 6.3 | 0.15 |
| create table | 4,332 | 5.5 | 0.13 |
| show storage engines | 2,623 | 3.3 | 0.08 |
| rollback to savepoint | 1,981 | 2.5 | 0.06 |
| delete | 1,582 | 2 | 0.05 |
| alter table | 856 | 1.1 | 0.03 |
| show grants | 448 | 0.6 | 0.01 |
| show table status | 280 | 0.4 | 0.01 |
| show slave status | 155 | 0.2 | <0.01 |
| show master status | 150 | 0.2 | <0.01 |
| show binlogs | 129 | 0.2 | <0.01 |
| show create proc | 37 | <0.1 | <0.01 |
| rollback | 31 | <0.1 | <0.01 |
| show status | 28 | <0.1 | <0.01 |
| release savepoint | 27 | <0.1 | <0.01 |
| savepoint | 27 | <0.1 | <0.01 |
| show function status | 27 | <0.1 | <0.01 |
| show package status | 27 | <0.1 | <0.01 |
| show package body status | 27 | <0.1 | <0.01 |
| show procedure status | 27 | <0.1 | <0.01 |
| unlock tables | 27 | <0.1 | <0.01 |
| update multi | 8 | <0.1 | <0.01 |
| show engine status | 3 | <0.1 | <0.01 |
| show processlist | 3 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| delete multi | 1 | <0.1 | <0.01 |
| drop table | 1 | <0.1 | <0.01 |
| insert select | 1 | <0.1 | <0.01 |
| truncate | 1 | <0.1 | <0.01 |