| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 633 k | 284.5 k | 77.72 |
| show tables | 44,962 | 20.2 k | 5.52 |
| show fields | 40,267 | 18.1 k | 4.95 |
| change db | 30,883 | 13.9 k | 3.79 |
| set option | 23,244 | 10.5 k | 2.86 |
| show keys | 19,010 | 8,551.3 | 2.34 |
| replace | 7,072 | 3,181.2 | 0.87 |
| show variables | 6,714 | 3,020.2 | 0.82 |
| show create table | 4,302 | 1,935.2 | 0.53 |
| show warnings | 2,673 | 1,202.4 | 0.33 |
| show storage engines | 1,081 | 486.3 | 0.13 |
| stmt close | 249 | 112 | 0.03 |
| stmt execute | 249 | 112 | 0.03 |
| stmt prepare | 249 | 112 | 0.03 |
| show table status | 91 | 40.9 | 0.01 |
| show grants | 86 | 38.7 | 0.01 |
| show slave status | 80 | 36 | 0.01 |
| show master status | 76 | 34.2 | 0.01 |
| show binlogs | 53 | 23.8 | 0.01 |
| show status | 24 | 10.8 | <0.01 |
| update | 6 | 2.7 | <0.01 |
| show processlist | 3 | 1.3 | <0.01 |
| show engine status | 2 | 0.9 | <0.01 |
| flush | 1 | 0.4 | <0.01 |