| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 23,924 k | 63.3 k | 74.06 |
| show tables | 1,848 k | 4,892.6 | 5.72 |
| set option | 1,487 k | 3,935.5 | 4.60 |
| show keys | 1,467 k | 3,883.8 | 4.54 |
| show fields | 1,113 k | 2,947 | 3.45 |
| change db | 716 k | 1,894.8 | 2.22 |
| show variables | 597 k | 1,579.2 | 1.85 |
| show grants | 298 k | 789.2 | 0.92 |
| show create table | 298 k | 788.7 | 0.92 |
| show warnings | 298 k | 788.6 | 0.92 |
| update | 167 k | 443.3 | 0.52 |
| insert | 35,614 | 94.3 | 0.11 |
| delete | 30,996 | 82 | 0.10 |
| show binlogs | 19,247 | 50.9 | 0.06 |
| replace | 813 | 2.2 | <0.01 |
| update multi | 583 | 1.5 | <0.01 |
| insert select | 288 | 0.8 | <0.01 |
| show table status | 132 | 0.3 | <0.01 |
| show slave status | 86 | 0.2 | <0.01 |
| show master status | 83 | 0.2 | <0.01 |
| delete multi | 26 | 0.1 | <0.01 |
| show storage engines | 15 | <0.1 | <0.01 |
| truncate | 10 | <0.1 | <0.01 |
| show status | 8 | <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 | 1 | <0.1 | <0.01 |