| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 15,182 k | 200.7 k | 80.75 |
| show fields | 852 k | 11.3 k | 4.53 |
| show tables | 656 k | 8,666.7 | 3.49 |
| show keys | 538 k | 7,110.6 | 2.86 |
| change db | 512 k | 6,770.7 | 2.72 |
| set option | 383 k | 5,067.1 | 2.04 |
| show variables | 230 k | 3,046 | 1.23 |
| show create table | 120 k | 1,581.3 | 0.64 |
| show warnings | 113 k | 1,497.9 | 0.60 |
| show grants | 105 k | 1,385.8 | 0.56 |
| replace | 104 k | 1,373.7 | 0.55 |
| show storage engines | 3,002 | 39.7 | 0.02 |
| show table status | 678 | 9 | <0.01 |
| show slave status | 398 | 5.3 | <0.01 |
| show master status | 391 | 5.2 | <0.01 |
| stmt close | 387 | 5.1 | <0.01 |
| stmt execute | 387 | 5.1 | <0.01 |
| stmt prepare | 387 | 5.1 | <0.01 |
| delete | 145 | 1.9 | <0.01 |
| show binlogs | 85 | 1.1 | <0.01 |
| update | 82 | 1.1 | <0.01 |
| insert | 61 | 0.8 | <0.01 |
| show status | 38 | 0.5 | <0.01 |
| show processlist | 5 | 0.1 | <0.01 |
| show engine status | 4 | 0.1 | <0.01 |
| delete multi | 3 | <0.1 | <0.01 |