| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 1,313 k | 3,843.3 | 60.56 |
| stmt execute | 176 k | 515.3 | 8.12 |
| stmt prepare | 176 k | 515.3 | 8.12 |
| stmt close | 170 k | 496.7 | 7.83 |
| show tables | 76,209 | 223.1 | 3.51 |
| show fields | 73,848 | 216.2 | 3.41 |
| change db | 54,387 | 159.2 | 2.51 |
| set option | 42,433 | 124.2 | 1.96 |
| show keys | 38,596 | 113 | 1.78 |
| show variables | 14,722 | 43.1 | 0.68 |
| replace | 11,613 | 34 | 0.54 |
| show create table | 9,133 | 26.7 | 0.42 |
| show warnings | 6,337 | 18.5 | 0.29 |
| insert | 3,469 | 10.2 | 0.16 |
| show storage engines | 1,301 | 3.8 | 0.06 |
| show grants | 287 | 0.8 | 0.01 |
| update | 274 | 0.8 | 0.01 |
| show slave status | 198 | 0.6 | 0.01 |
| show master status | 194 | 0.6 | 0.01 |
| show table status | 137 | 0.4 | 0.01 |
| show binlogs | 125 | 0.4 | 0.01 |
| delete | 37 | 0.1 | <0.01 |
| show status | 33 | 0.1 | <0.01 |
| insert select | 14 | <0.1 | <0.01 |
| load | 10 | <0.1 | <0.01 |
| show processlist | 4 | <0.1 | <0.01 |
| truncate | 3 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |