| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 1,046 k | 191.2 k | 78.03 |
| show tables | 74,225 | 13.6 k | 5.54 |
| show fields | 66,343 | 12.1 k | 4.95 |
| change db | 51,298 | 9,378.1 | 3.83 |
| set option | 38,908 | 7,113 | 2.90 |
| show keys | 26,131 | 4,777.1 | 1.95 |
| replace | 11,577 | 2,116.5 | 0.86 |
| show variables | 10,300 | 1,883 | 0.77 |
| show create table | 7,195 | 1,315.4 | 0.54 |
| show warnings | 3,835 | 701.1 | 0.29 |
| show storage engines | 2,028 | 370.7 | 0.15 |
| insert | 474 | 86.7 | 0.04 |
| stmt close | 403 | 73.7 | 0.03 |
| stmt execute | 403 | 73.7 | 0.03 |
| stmt prepare | 403 | 73.7 | 0.03 |
| show table status | 251 | 45.9 | 0.02 |
| update | 148 | 27.1 | 0.01 |
| show slave status | 110 | 20.1 | 0.01 |
| show master status | 104 | 19 | 0.01 |
| create table | 86 | 15.7 | 0.01 |
| drop table | 83 | 15.2 | 0.01 |
| show grants | 62 | 11.3 | <0.01 |
| show binlogs | 41 | 7.5 | <0.01 |
| show status | 26 | 4.8 | <0.01 |
| delete multi | 15 | 2.7 | <0.01 |
| delete | 12 | 2.2 | <0.01 |
| show processlist | 3 | 0.5 | <0.01 |
| show engine status | 2 | 0.4 | <0.01 |
| alter db | 1 | 0.2 | <0.01 |
| flush | 1 | 0.2 | <0.01 |
| update multi | 1 | 0.2 | <0.01 |