| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 334 k | 107.5 k | 78.28 |
| show tables | 25,601 | 8,242.1 | 6.00 |
| show fields | 19,528 | 6,287 | 4.58 |
| change db | 17,526 | 5,642.4 | 4.11 |
| set option | 12,525 | 4,032.4 | 2.94 |
| show keys | 7,302 | 2,350.8 | 1.71 |
| show variables | 3,261 | 1,049.9 | 0.76 |
| replace | 2,475 | 796.8 | 0.58 |
| show create table | 1,410 | 453.9 | 0.33 |
| show warnings | 703 | 226.3 | 0.16 |
| show grants | 601 | 193.5 | 0.14 |
| show storage engines | 455 | 146.5 | 0.11 |
| stmt execute | 229 | 73.7 | 0.05 |
| stmt prepare | 229 | 73.7 | 0.05 |
| show binlogs | 212 | 68.3 | 0.05 |
| show table status | 138 | 44.4 | 0.03 |
| stmt close | 138 | 44.4 | 0.03 |
| show slave status | 107 | 34.4 | 0.03 |
| show master status | 101 | 32.5 | 0.02 |
| update | 62 | 20 | 0.01 |
| show status | 37 | 11.9 | 0.01 |
| insert | 13 | 4.2 | <0.01 |
| create table | 6 | 1.9 | <0.01 |
| show processlist | 5 | 1.6 | <0.01 |
| show engine status | 4 | 1.3 | <0.01 |
| alter table | 1 | 0.3 | <0.01 |
| create db | 1 | 0.3 | <0.01 |