
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 3,557 k | 21.3 k | 94.68 |
| set option | 164 k | 979.5 | 4.36 |
| change db | 7,559 | 45.2 | 0.20 |
| show fields | 6,203 | 37.1 | 0.17 |
| show create table | 5,097 | 30.5 | 0.14 |
| show keys | 2,978 | 17.8 | 0.08 |
| update | 2,949 | 17.6 | 0.08 |
| insert | 2,868 | 17.1 | 0.08 |
| rollback to savepoint | 2,289 | 13.7 | 0.06 |
| show tables | 1,306 | 7.8 | 0.03 |
| replace | 720 | 4.3 | 0.02 |
| show variables | 660 | 3.9 | 0.02 |
| stmt prepare | 513 | 3.1 | 0.01 |
| stmt execute | 512 | 3.1 | 0.01 |
| stmt close | 443 | 2.6 | 0.01 |
| commit | 381 | 2.3 | 0.01 |
| show warnings | 214 | 1.3 | 0.01 |
| delete | 162 | 1 | <0.01 |
| show grants | 140 | 0.8 | <0.01 |
| show procedure status | 112 | 0.7 | <0.01 |
| show package body status | 112 | 0.7 | <0.01 |
| show package status | 112 | 0.7 | <0.01 |
| show function status | 112 | 0.7 | <0.01 |
| savepoint | 112 | 0.7 | <0.01 |
| release savepoint | 112 | 0.7 | <0.01 |
| show create db | 91 | 0.5 | <0.01 |
| show table status | 80 | 0.5 | <0.01 |
| show slave status | 74 | 0.4 | <0.01 |
| show master status | 71 | 0.4 | <0.01 |
| show binlogs | 57 | 0.3 | <0.01 |
| begin | 28 | 0.2 | <0.01 |
| unlock tables | 28 | 0.2 | <0.01 |
| show databases | 14 | 0.1 | <0.01 |
| show storage engines | 11 | 0.1 | <0.01 |
| show status | 8 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| alter table | 2 | <0.1 | <0.01 |
| show processlist | 1 | <0.1 | <0.01 |
| create table | 1 | <0.1 | <0.01 |
| drop table | 1 | <0.1 | <0.01 |
| insert select | 1 | <0.1 | <0.01 |