Console
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 1,997 k | 211.4 k | 78.78 |
| show tables | 131 k | 13.8 k | 5.16 |
| show fields | 119 k | 12.6 k | 4.70 |
| change db | 90,246 | 9,553.2 | 3.56 |
| set option | 66,777 | 7,068.8 | 2.63 |
| show keys | 58,389 | 6,180.9 | 2.30 |
| replace | 20,105 | 2,128.3 | 0.79 |
| show variables | 19,338 | 2,047.1 | 0.76 |
| show create table | 13,737 | 1,454.2 | 0.54 |
| show warnings | 7,710 | 816.2 | 0.30 |
| show storage engines | 2,683 | 284 | 0.11 |
| show create proc | 2,670 | 282.6 | 0.11 |
| show create func | 2,241 | 237.2 | 0.09 |
| show grants | 940 | 99.5 | 0.04 |
| stmt close | 367 | 38.8 | 0.01 |
| stmt execute | 367 | 38.8 | 0.01 |
| stmt prepare | 367 | 38.8 | 0.01 |
| update | 367 | 38.8 | 0.01 |
| insert | 308 | 32.6 | 0.01 |
| show binlogs | 297 | 31.4 | 0.01 |
| show table status | 247 | 26.1 | 0.01 |
| show slave status | 242 | 25.6 | 0.01 |
| show binlog status | 235 | 24.9 | 0.01 |
| create table | 112 | 11.9 | <0.01 |
| alter table | 66 | 7 | <0.01 |
| show status | 45 | 4.8 | <0.01 |
| delete | 13 | 1.4 | <0.01 |
| create db | 8 | 0.8 | <0.01 |
| show processlist | 6 | 0.6 | <0.01 |
| commit | 5 | 0.5 | <0.01 |
| flush | 5 | 0.5 | <0.01 |
| show engine status | 4 | 0.4 | <0.01 |
| begin | 3 | 0.3 | <0.01 |
| alter user | 2 | 0.2 | <0.01 |
| show databases | 2 | 0.2 | <0.01 |
| create user | 1 | 0.1 | <0.01 |
| grant | 1 | 0.1 | <0.01 |