| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 1,296 k | 3,794.2 | 60.38 |
| stmt execute | 176 k | 515.5 | 8.20 |
| stmt prepare | 176 k | 515.5 | 8.20 |
| stmt close | 170 k | 497 | 7.91 |
| show tables | 74,850 | 219.2 | 3.49 |
| show fields | 72,693 | 212.9 | 3.39 |
| change db | 53,470 | 156.6 | 2.49 |
| set option | 41,770 | 122.3 | 1.95 |
| show keys | 38,177 | 111.8 | 1.78 |
| show variables | 14,591 | 42.7 | 0.68 |
| replace | 11,528 | 33.8 | 0.54 |
| show create table | 9,085 | 26.6 | 0.42 |
| show warnings | 6,321 | 18.5 | 0.29 |
| insert | 3,467 | 10.2 | 0.16 |
| show storage engines | 1,282 | 3.8 | 0.06 |
| update | 274 | 0.8 | 0.01 |
| show grants | 203 | 0.6 | 0.01 |
| show slave status | 188 | 0.6 | 0.01 |
| show master status | 184 | 0.5 | 0.01 |
| show table status | 132 | 0.4 | 0.01 |
| show binlogs | 95 | 0.3 | <0.01 |
| delete | 37 | 0.1 | <0.01 |
| show status | 25 | 0.1 | <0.01 |
| insert select | 14 | <0.1 | <0.01 |
| load | 10 | <0.1 | <0.01 |
| show processlist | 3 | <0.1 | <0.01 |
| truncate | 3 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |