| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 1,593 k | 6,299.4 | 66.44 |
| stmt execute | 127 k | 502.3 | 5.30 |
| stmt prepare | 127 k | 502.3 | 5.30 |
| stmt close | 123 k | 485.4 | 5.12 |
| show tables | 97,063 | 383.9 | 4.05 |
| show fields | 96,092 | 380 | 4.01 |
| change db | 69,949 | 276.7 | 2.92 |
| set option | 53,523 | 211.7 | 2.23 |
| show keys | 51,504 | 203.7 | 2.15 |
| show variables | 19,965 | 79 | 0.83 |
| replace | 14,438 | 57.1 | 0.60 |
| show create table | 11,715 | 46.3 | 0.49 |
| show warnings | 8,666 | 34.3 | 0.36 |
| insert | 2,022 | 8 | 0.08 |
| show storage engines | 1,496 | 5.9 | 0.06 |
| show grants | 347 | 1.4 | 0.01 |
| show slave status | 233 | 0.9 | 0.01 |
| show master status | 226 | 0.9 | 0.01 |
| update | 174 | 0.7 | 0.01 |
| show table status | 173 | 0.7 | 0.01 |
| show binlogs | 151 | 0.6 | 0.01 |
| show status | 44 | 0.2 | <0.01 |
| delete | 22 | 0.1 | <0.01 |
| insert select | 10 | <0.1 | <0.01 |
| show processlist | 7 | <0.1 | <0.01 |
| show engine status | 4 | <0.1 | <0.01 |
| load | 3 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| truncate | 1 | <0.1 | <0.01 |