| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 1,576 k | 6,233.8 | 66.33 |
| stmt execute | 127 k | 502.3 | 5.34 |
| stmt prepare | 127 k | 502.3 | 5.34 |
| stmt close | 123 k | 485.3 | 5.16 |
| show tables | 95,754 | 378.7 | 4.03 |
| show fields | 95,062 | 376 | 4.00 |
| change db | 69,058 | 273.1 | 2.91 |
| set option | 52,893 | 209.2 | 2.23 |
| show keys | 51,196 | 202.5 | 2.15 |
| show variables | 19,861 | 78.6 | 0.84 |
| replace | 14,337 | 56.7 | 0.60 |
| show create table | 11,668 | 46.2 | 0.49 |
| show warnings | 8,656 | 34.2 | 0.36 |
| insert | 2,022 | 8 | 0.09 |
| show storage engines | 1,471 | 5.8 | 0.06 |
| show grants | 318 | 1.3 | 0.01 |
| show slave status | 229 | 0.9 | 0.01 |
| show master status | 222 | 0.9 | 0.01 |
| update | 174 | 0.7 | 0.01 |
| show table status | 164 | 0.6 | 0.01 |
| show binlogs | 141 | 0.6 | 0.01 |
| show status | 38 | 0.2 | <0.01 |
| delete | 22 | 0.1 | <0.01 |
| insert select | 10 | <0.1 | <0.01 |
| show processlist | 6 | <0.1 | <0.01 |
| load | 3 | <0.1 | <0.01 |
| show engine status | 3 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| truncate | 1 | <0.1 | <0.01 |