| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 1,672 k | 6,584 | 66.91 |
| stmt execute | 127 k | 500.2 | 5.08 |
| stmt prepare | 127 k | 500.2 | 5.08 |
| stmt close | 123 k | 483.3 | 4.91 |
| show tables | 103 k | 407.1 | 4.14 |
| show fields | 101 k | 396.9 | 4.03 |
| change db | 73,988 | 291.4 | 2.96 |
| set option | 56,474 | 222.4 | 2.26 |
| show keys | 53,117 | 209.2 | 2.13 |
| show variables | 20,701 | 81.5 | 0.83 |
| replace | 15,114 | 59.5 | 0.60 |
| show create table | 12,080 | 47.6 | 0.48 |
| show warnings | 8,865 | 34.9 | 0.35 |
| insert | 2,022 | 8 | 0.08 |
| show storage engines | 1,574 | 6.2 | 0.06 |
| show grants | 594 | 2.3 | 0.02 |
| show slave status | 241 | 0.9 | 0.01 |
| show binlogs | 234 | 0.9 | 0.01 |
| show master status | 234 | 0.9 | 0.01 |
| show table status | 196 | 0.8 | 0.01 |
| update | 174 | 0.7 | 0.01 |
| show status | 49 | 0.2 | <0.01 |
| delete | 22 | 0.1 | <0.01 |
| insert select | 10 | <0.1 | <0.01 |
| show processlist | 8 | <0.1 | <0.01 |
| show engine status | 5 | <0.1 | <0.01 |
| load | 3 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| truncate | 1 | <0.1 | <0.01 |