| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 486 k | 212.3 k | 76.48 |
| show tables | 33,129 | 14.5 k | 5.22 |
| show fields | 32,440 | 14.2 k | 5.11 |
| change db | 23,975 | 10.5 k | 3.78 |
| set option | 19,082 | 8,339.8 | 3.00 |
| show keys | 16,053 | 7,016 | 2.53 |
| show variables | 5,267 | 2,302 | 0.83 |
| alter table | 5,152 | 2,251.7 | 0.81 |
| replace | 4,566 | 1,995.6 | 0.72 |
| show create table | 3,449 | 1,507.4 | 0.54 |
| show warnings | 1,929 | 843.1 | 0.30 |
| update | 1,698 | 742.1 | 0.27 |
| show storage engines | 716 | 312.9 | 0.11 |
| show grants | 416 | 181.8 | 0.07 |
| insert | 283 | 123.7 | 0.04 |
| delete | 274 | 119.8 | 0.04 |
| show binlogs | 165 | 72.1 | 0.03 |
| stmt close | 122 | 53.3 | 0.02 |
| stmt execute | 122 | 53.3 | 0.02 |
| stmt prepare | 122 | 53.3 | 0.02 |
| show table status | 112 | 48.9 | 0.02 |
| update multi | 107 | 46.8 | 0.02 |
| show slave status | 74 | 32.3 | 0.01 |
| show master status | 70 | 30.6 | 0.01 |
| show status | 25 | 10.9 | <0.01 |
| show processlist | 4 | 1.7 | <0.01 |
| flush | 1 | 0.4 | <0.01 |
| insert select | 1 | 0.4 | <0.01 |
| show engine status | 1 | 0.4 | <0.01 |