| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 32,730 k | 28.7 k | 87.84 |
| insert | 967 k | 847.9 | 2.59 |
| stmt execute | 775 k | 679.7 | 2.08 |
| show fields | 625 k | 548.2 | 1.68 |
| set option | 601 k | 526.8 | 1.61 |
| show tables | 554 k | 486.2 | 1.49 |
| show keys | 202 k | 177.4 | 0.54 |
| delete multi | 194 k | 170.5 | 0.52 |
| change db | 186 k | 163 | 0.50 |
| update | 130 k | 113.6 | 0.35 |
| show variables | 82,182 | 72.1 | 0.22 |
| show create table | 80,508 | 70.6 | 0.22 |
| show grants | 50,039 | 43.9 | 0.13 |
| show warnings | 26,235 | 23 | 0.07 |
| stmt close | 19,571 | 17.2 | 0.05 |
| stmt prepare | 19,571 | 17.2 | 0.05 |
| show storage engines | 13,925 | 12.2 | 0.04 |
| show binlogs | 1,314 | 1.2 | <0.01 |
| show table status | 797 | 0.7 | <0.01 |
| show slave status | 786 | 0.7 | <0.01 |
| show master status | 759 | 0.7 | <0.01 |
| show status | 127 | 0.1 | <0.01 |
| delete | 90 | 0.1 | <0.01 |
| show processlist | 23 | <0.1 | <0.01 |
| show engine status | 5 | <0.1 | <0.01 |