| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 41,742 | 4,067.4 | 76.20 |
| show tables | 3,513 | 342.3 | 6.41 |
| show fields | 2,963 | 288.7 | 5.41 |
| change db | 2,071 | 201.8 | 3.78 |
| set option | 1,899 | 185 | 3.47 |
| show keys | 795 | 77.5 | 1.45 |
| create table | 357 | 34.8 | 0.65 |
| replace | 349 | 34 | 0.64 |
| show variables | 218 | 21.2 | 0.40 |
| show create table | 188 | 18.3 | 0.34 |
| show grants | 171 | 16.7 | 0.31 |
| insert | 129 | 12.6 | 0.24 |
| rollback to savepoint | 62 | 6 | 0.11 |
| stmt execute | 43 | 4.2 | 0.08 |
| show storage engines | 35 | 3.4 | 0.06 |
| show table status | 34 | 3.3 | 0.06 |
| stmt prepare | 34 | 3.3 | 0.06 |
| show warnings | 33 | 3.2 | 0.06 |
| update | 32 | 3.1 | 0.06 |
| stmt close | 29 | 2.8 | 0.05 |
| show binlogs | 26 | 2.5 | 0.05 |
| alter table | 7 | 0.7 | 0.01 |
| show master status | 7 | 0.7 | 0.01 |
| show slave status | 7 | 0.7 | 0.01 |
| show status | 5 | 0.5 | 0.01 |
| begin | 3 | 0.3 | 0.01 |
| delete | 3 | 0.3 | 0.01 |
| release savepoint | 3 | 0.3 | 0.01 |
| savepoint | 3 | 0.3 | 0.01 |
| show function status | 3 | 0.3 | 0.01 |
| show package status | 3 | 0.3 | 0.01 |
| show package body status | 3 | 0.3 | 0.01 |
| show procedure status | 3 | 0.3 | 0.01 |
| unlock tables | 3 | 0.3 | 0.01 |
| show engine status | 1 | 0.1 | <0.01 |