| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 13,147 k | 389.2 k | 63.22 |
| set option | 1,696 k | 50.2 k | 8.16 |
| show tables | 1,480 k | 43.8 k | 7.12 |
| show fields | 1,059 k | 31.4 k | 5.09 |
| show keys | 908 k | 26.9 k | 4.37 |
| change db | 702 k | 20.8 k | 3.38 |
| show variables | 700 k | 20.7 k | 3.37 |
| show create table | 351 k | 10.4 k | 1.69 |
| show grants | 350 k | 10.4 k | 1.68 |
| show warnings | 349 k | 10.3 k | 1.68 |
| show binlogs | 32,128 | 951.1 | 0.15 |
| create table | 10,871 | 321.8 | 0.05 |
| update | 6,313 | 186.9 | 0.03 |
| insert | 1,362 | 40.3 | 0.01 |
| update multi | 465 | 13.8 | <0.01 |
| show storage engines | 411 | 12.2 | <0.01 |
| rollback to savepoint | 175 | 5.2 | <0.01 |
| show slave status | 70 | 2.1 | <0.01 |
| begin | 68 | 2 | <0.01 |
| commit | 67 | 2 | <0.01 |
| show master status | 65 | 1.9 | <0.01 |
| stmt prepare | 57 | 1.7 | <0.01 |
| stmt execute | 56 | 1.7 | <0.01 |
| stmt close | 55 | 1.6 | <0.01 |
| show table status | 37 | 1.1 | <0.01 |
| show status | 30 | 0.9 | <0.01 |
| show processlist | 4 | 0.1 | <0.01 |
| delete | 2 | 0.1 | <0.01 |
| flush | 2 | 0.1 | <0.01 |
| release savepoint | 1 | <0.1 | <0.01 |
| savepoint | 1 | <0.1 | <0.01 |
| show create db | 1 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |
| show function status | 1 | <0.1 | <0.01 |
| show package status | 1 | <0.1 | <0.01 |
| show package body status | 1 | <0.1 | <0.01 |
| show procedure status | 1 | <0.1 | <0.01 |
| unlock tables | 1 | <0.1 | <0.01 |