| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 574 k | 26.7 k | 56.63 |
| set option | 153 k | 7,144.1 | 15.13 |
| change db | 66,302 | 3,090.7 | 6.54 |
| show fields | 53,775 | 2,506.8 | 5.31 |
| show create table | 35,631 | 1,661 | 3.52 |
| show tables | 29,722 | 1,385.5 | 2.93 |
| show table status | 28,382 | 1,323.1 | 2.80 |
| show triggers | 28,267 | 1,317.7 | 2.79 |
| show keys | 13,559 | 632.1 | 1.34 |
| insert | 11,761 | 548.2 | 1.16 |
| delete | 5,088 | 237.2 | 0.50 |
| show variables | 3,843 | 179.1 | 0.38 |
| replace | 3,315 | 154.5 | 0.33 |
| show grants | 2,471 | 115.2 | 0.24 |
| update | 1,659 | 77.3 | 0.16 |
| show storage engines | 1,078 | 50.3 | 0.11 |
| show warnings | 605 | 28.2 | 0.06 |
| commit | 397 | 18.5 | 0.04 |
| create table | 74 | 3.4 | 0.01 |
| show collations | 23 | 1.1 | <0.01 |
| show binlogs | 22 | 1 | <0.01 |
| stmt close | 22 | 1 | <0.01 |
| stmt execute | 22 | 1 | <0.01 |
| stmt prepare | 22 | 1 | <0.01 |
| show slave status | 21 | 1 | <0.01 |
| show master status | 20 | 0.9 | <0.01 |
| truncate | 13 | 0.6 | <0.01 |
| show status | 6 | 0.3 | <0.01 |
| rollback | 3 | 0.1 | <0.01 |
| show processlist | 1 | <0.1 | <0.01 |