| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 162 k | 769.9 | 78.63 |
| show tables | 11,385 | 54 | 5.51 |
| show fields | 9,549 | 45.3 | 4.62 |
| change db | 8,636 | 40.9 | 4.18 |
| set option | 6,012 | 28.5 | 2.91 |
| show keys | 4,010 | 19 | 1.94 |
| show variables | 1,438 | 6.8 | 0.70 |
| replace | 872 | 4.1 | 0.42 |
| show create table | 788 | 3.7 | 0.38 |
| show grants | 507 | 2.4 | 0.25 |
| show storage engines | 240 | 1.1 | 0.12 |
| show warnings | 165 | 0.8 | 0.08 |
| show binlogs | 137 | 0.6 | 0.07 |
| insert | 94 | 0.4 | 0.05 |
| show slave status | 57 | 0.3 | 0.03 |
| show master status | 54 | 0.3 | 0.03 |
| stmt prepare | 40 | 0.2 | 0.02 |
| stmt close | 39 | 0.2 | 0.02 |
| stmt execute | 39 | 0.2 | 0.02 |
| update | 28 | 0.1 | 0.01 |
| show status | 22 | 0.1 | 0.01 |
| create table | 14 | 0.1 | 0.01 |
| show databases | 13 | 0.1 | 0.01 |
| create db | 12 | 0.1 | 0.01 |
| show processlist | 2 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |
| show table status | 1 | <0.1 | <0.01 |