Console
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 1,842 k | 246.8 k | 78.36 |
| show tables | 123 k | 16.4 k | 5.22 |
| show fields | 113 k | 15.1 k | 4.80 |
| change db | 85,604 | 11.5 k | 3.64 |
| set option | 63,189 | 8,464.4 | 2.69 |
| show keys | 55,532 | 7,438.7 | 2.36 |
| replace | 19,104 | 2,559 | 0.81 |
| show variables | 18,554 | 2,485.4 | 0.79 |
| show create table | 13,227 | 1,771.8 | 0.56 |
| show warnings | 7,426 | 994.7 | 0.32 |
| show create proc | 2,668 | 357.4 | 0.11 |
| show storage engines | 2,665 | 357 | 0.11 |
| show create func | 2,241 | 300.2 | 0.10 |
| show grants | 633 | 84.8 | 0.03 |
| stmt close | 351 | 47 | 0.01 |
| stmt execute | 351 | 47 | 0.01 |
| stmt prepare | 351 | 47 | 0.01 |
| show binlogs | 239 | 32 | 0.01 |
| show slave status | 231 | 30.9 | 0.01 |
| show table status | 225 | 30.1 | 0.01 |
| show binlog status | 224 | 30 | 0.01 |
| insert | 143 | 19.2 | 0.01 |
| update | 141 | 18.9 | 0.01 |
| create table | 52 | 7 | <0.01 |
| show status | 39 | 5.2 | <0.01 |
| alter table | 14 | 1.9 | <0.01 |
| delete | 7 | 0.9 | <0.01 |
| show processlist | 5 | 0.7 | <0.01 |
| commit | 3 | 0.4 | <0.01 |
| create db | 3 | 0.4 | <0.01 |
| show engine status | 3 | 0.4 | <0.01 |
| flush | 2 | 0.3 | <0.01 |
| begin | 1 | 0.1 | <0.01 |
| show databases | 1 | 0.1 | <0.01 |