
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 3,566 k | 21.3 k | 94.61 |
| set option | 165 k | 983.7 | 4.37 |
| change db | 7,981 | 47.7 | 0.21 |
| show fields | 6,792 | 40.6 | 0.18 |
| show create table | 5,304 | 31.7 | 0.14 |
| show keys | 3,387 | 20.2 | 0.09 |
| 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,565 | 9.4 | 0.04 |
| replace | 840 | 5 | 0.02 |
| show variables | 771 | 4.6 | 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 | 243 | 1.5 | 0.01 |
| show grants | 183 | 1.1 | <0.01 |
| delete | 162 | 1 | <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 slave status | 90 | 0.5 | <0.01 |
| show table status | 88 | 0.5 | <0.01 |
| show master status | 87 | 0.5 | <0.01 |
| show binlogs | 73 | 0.4 | <0.01 |
| begin | 28 | 0.2 | <0.01 |
| unlock tables | 28 | 0.2 | <0.01 |
| show storage engines | 17 | 0.1 | <0.01 |
| show status | 15 | 0.1 | <0.01 |
| show databases | 14 | 0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| show processlist | 2 | <0.1 | <0.01 |
| alter table | 2 | <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 |