Console
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 415 k | 90 k | 71.86 |
| show fields | 39,470 | 8,552 | 6.83 |
| show tables | 31,042 | 6,725.9 | 5.37 |
| change db | 21,297 | 4,614.5 | 3.69 |
| set option | 15,039 | 3,258.5 | 2.60 |
| stmt execute | 10,795 | 2,339 | 1.87 |
| stmt prepare | 10,510 | 2,277.2 | 1.82 |
| stmt close | 10,471 | 2,268.8 | 1.81 |
| show keys | 9,597 | 2,079.4 | 1.66 |
| replace | 3,685 | 798.4 | 0.64 |
| show variables | 3,525 | 763.8 | 0.61 |
| show create table | 3,098 | 671.2 | 0.54 |
| show grants | 1,503 | 325.7 | 0.26 |
| show storage engines | 692 | 149.9 | 0.12 |
| show warnings | 628 | 136.1 | 0.11 |
| update | 400 | 86.7 | 0.07 |
| show table status | 356 | 77.1 | 0.06 |
| show binlogs | 249 | 54 | 0.04 |
| insert | 54 | 11.7 | 0.01 |
| show slave status | 40 | 8.7 | 0.01 |
| show master status | 38 | 8.2 | 0.01 |
| show status | 21 | 4.6 | <0.01 |
| insert select | 20 | 4.3 | <0.01 |
| begin | 14 | 3 | <0.01 |
| rollback | 8 | 1.7 | <0.01 |
| delete | 7 | 1.5 | <0.01 |
| commit | 6 | 1.3 | <0.01 |
| update multi | 5 | 1.1 | <0.01 |
| show processlist | 3 | 0.7 | <0.01 |
| flush | 2 | 0.4 | <0.01 |
| show engine status | 2 | 0.4 | <0.01 |
| show function status | 1 | 0.2 | <0.01 |
| show procedure status | 1 | 0.2 | <0.01 |