| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 18,490 | 346.6 | 66.44 |
| set option | 3,270 | 61.3 | 11.75 |
| show tables | 2,582 | 48.4 | 9.28 |
| change db | 784 | 14.7 | 2.82 |
| show keys | 587 | 11 | 2.11 |
| show fields | 529 | 9.9 | 1.90 |
| show variables | 514 | 9.6 | 1.85 |
| alter table | 264 | 4.9 | 0.95 |
| create table | 136 | 2.5 | 0.49 |
| show create table | 114 | 2.1 | 0.41 |
| update | 80 | 1.5 | 0.29 |
| show storage engines | 71 | 1.3 | 0.26 |
| show grants | 63 | 1.2 | 0.23 |
| insert | 59 | 1.1 | 0.21 |
| rollback to savepoint | 48 | 0.9 | 0.17 |
| show binlogs | 47 | 0.9 | 0.17 |
| show slave status | 33 | 0.6 | 0.12 |
| show master status | 31 | 0.6 | 0.11 |
| insert select | 21 | 0.4 | 0.08 |
| update multi | 21 | 0.4 | 0.08 |
| show warnings | 16 | 0.3 | 0.06 |
| show table status | 15 | 0.3 | 0.05 |
| begin | 9 | 0.2 | 0.03 |
| create db | 8 | 0.1 | 0.03 |
| commit | 7 | 0.1 | 0.03 |
| delete | 7 | 0.1 | 0.03 |
| show status | 4 | 0.1 | 0.01 |
| release savepoint | 2 | <0.1 | 0.01 |
| savepoint | 2 | <0.1 | 0.01 |
| show create db | 2 | <0.1 | 0.01 |
| show events | 2 | <0.1 | 0.01 |
| show function status | 2 | <0.1 | 0.01 |
| show package status | 2 | <0.1 | 0.01 |
| show package body status | 2 | <0.1 | 0.01 |
| show procedure status | 2 | <0.1 | 0.01 |
| unlock tables | 2 | <0.1 | 0.01 |
| show processlist | 1 | <0.1 | <0.01 |