| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 23,944 k | 63.3 k | 74.03 |
| show tables | 1,852 k | 4,900.8 | 5.73 |
| set option | 1,492 k | 3,946.1 | 4.61 |
| show keys | 1,471 k | 3,891.4 | 4.55 |
| show fields | 1,117 k | 2,955.3 | 3.45 |
| change db | 718 k | 1,898.5 | 2.22 |
| show variables | 598 k | 1,580.9 | 1.85 |
| show create table | 299 k | 790.4 | 0.92 |
| show grants | 298 k | 789 | 0.92 |
| show warnings | 298 k | 788.7 | 0.92 |
| update | 167 k | 443.1 | 0.52 |
| insert | 35,614 | 94.2 | 0.11 |
| delete | 30,996 | 82 | 0.10 |
| show binlogs | 19,292 | 51 | 0.06 |
| replace | 813 | 2.2 | <0.01 |
| update multi | 583 | 1.5 | <0.01 |
| show storage engines | 316 | 0.8 | <0.01 |
| insert select | 288 | 0.8 | <0.01 |
| show table status | 166 | 0.4 | <0.01 |
| show slave status | 99 | 0.3 | <0.01 |
| show master status | 96 | 0.3 | <0.01 |
| delete multi | 26 | 0.1 | <0.01 |
| show status | 16 | <0.1 | <0.01 |
| truncate | 10 | <0.1 | <0.01 |
| alter table | 6 | <0.1 | <0.01 |
| create table | 2 | <0.1 | <0.01 |
| drop table | 2 | <0.1 | <0.01 |
| show processlist | 2 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |