| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 599 k | 190.8 k | 76.49 |
| show tables | 42,059 | 13.4 k | 5.37 |
| show fields | 39,987 | 12.7 k | 5.11 |
| change db | 29,742 | 9,476.2 | 3.80 |
| set option | 23,370 | 7,446 | 2.98 |
| show keys | 19,478 | 6,205.9 | 2.49 |
| show variables | 6,235 | 1,986.5 | 0.80 |
| replace | 5,744 | 1,830.1 | 0.73 |
| alter table | 5,552 | 1,768.9 | 0.71 |
| show create table | 4,081 | 1,300.3 | 0.52 |
| show warnings | 2,210 | 704.1 | 0.28 |
| update | 1,884 | 600.3 | 0.24 |
| show grants | 998 | 318 | 0.13 |
| show storage engines | 839 | 267.3 | 0.11 |
| insert | 342 | 109 | 0.04 |
| delete | 333 | 106.1 | 0.04 |
| show binlogs | 245 | 78.1 | 0.03 |
| stmt close | 167 | 53.2 | 0.02 |
| stmt execute | 167 | 53.2 | 0.02 |
| stmt prepare | 167 | 53.2 | 0.02 |
| show table status | 143 | 45.6 | 0.02 |
| update multi | 132 | 42.1 | 0.02 |
| show slave status | 82 | 26.1 | 0.01 |
| show master status | 77 | 24.5 | 0.01 |
| show status | 33 | 10.5 | <0.01 |
| show processlist | 6 | 1.9 | <0.01 |
| show engine status | 3 | 1 | <0.01 |
| flush | 2 | 0.6 | <0.01 |
| insert select | 1 | 0.3 | <0.01 |