| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 86,243 | 522.6 | 81.00 |
| show tables | 6,023 | 36.5 | 5.66 |
| change db | 4,576 | 27.7 | 4.30 |
| show fields | 3,987 | 24.2 | 3.74 |
| set option | 3,488 | 21.1 | 3.28 |
| show variables | 927 | 5.6 | 0.87 |
| show keys | 622 | 3.8 | 0.58 |
| replace | 75 | 0.5 | 0.07 |
| show create table | 68 | 0.4 | 0.06 |
| show storage engines | 60 | 0.4 | 0.06 |
| update | 49 | 0.3 | 0.05 |
| show slave status | 46 | 0.3 | 0.04 |
| show master status | 43 | 0.3 | 0.04 |
| show warnings | 34 | 0.2 | 0.03 |
| show binlogs | 26 | 0.2 | 0.02 |
| show grants | 26 | 0.2 | 0.02 |
| show table status | 25 | 0.2 | 0.02 |
| insert | 22 | 0.1 | 0.02 |
| empty query | 20 | 0.1 | 0.02 |
| lock tables | 20 | 0.1 | 0.02 |
| show create db | 20 | 0.1 | 0.02 |
| show databases | 20 | 0.1 | 0.02 |
| create table | 9 | 0.1 | 0.01 |
| stmt close | 9 | 0.1 | 0.01 |
| stmt execute | 9 | 0.1 | 0.01 |
| stmt prepare | 9 | 0.1 | 0.01 |
| show status | 8 | <0.1 | 0.01 |
| alter table | 4 | <0.1 | <0.01 |
| insert select | 2 | <0.1 | <0.01 |
| show function status | 2 | <0.1 | <0.01 |
| show procedure status | 2 | <0.1 | <0.01 |
| begin | 1 | <0.1 | <0.01 |
| show processlist | 1 | <0.1 | <0.01 |