Console
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 11,477 k | 6,960.9 | 61.99 |
| set option | 2,802 k | 1,699.7 | 15.14 |
| show tables | 2,289 k | 1,388.5 | 12.37 |
| show fields | 498 k | 302.3 | 2.69 |
| show keys | 310 k | 187.9 | 1.67 |
| show variables | 308 k | 186.8 | 1.66 |
| change db | 175 k | 106.2 | 0.95 |
| show grants | 171 k | 104 | 0.93 |
| show create table | 158 k | 96.1 | 0.86 |
| show warnings | 151 k | 91.5 | 0.82 |
| show binlogs | 139 k | 84.2 | 0.75 |
| show create proc | 5,367 | 3.3 | 0.03 |
| update | 5,293 | 3.2 | 0.03 |
| show create func | 4,549 | 2.8 | 0.02 |
| show storage engines | 4,419 | 2.7 | 0.02 |
| show master status | 1,986 | 1.2 | 0.01 |
| show replica status | 1,986 | 1.2 | 0.01 |
| show slave status | 1,986 | 1.2 | 0.01 |
| commit | 1,882 | 1.1 | 0.01 |
| begin | 1,834 | 1.1 | 0.01 |
| stmt execute | 738 | 0.4 | <0.01 |
| stmt close | 738 | 0.4 | <0.01 |
| stmt prepare | 738 | 0.4 | <0.01 |
| show table status | 383 | 0.2 | <0.01 |
| insert | 353 | 0.2 | <0.01 |
| delete | 228 | 0.1 | <0.01 |
| show status | 103 | 0.1 | <0.01 |
| flush | 76 | <0.1 | <0.01 |
| show charsets | 52 | <0.1 | <0.01 |
| show collations | 52 | <0.1 | <0.01 |
| show databases | 52 | <0.1 | <0.01 |
| show plugins | 52 | <0.1 | <0.01 |
| alter table | 50 | <0.1 | <0.01 |
| create table | 38 | <0.1 | <0.01 |
| show replicas | 24 | <0.1 | <0.01 |
| show slave hosts | 24 | <0.1 | <0.01 |
| show binlog events | 23 | <0.1 | <0.01 |
| show processlist | 12 | <0.1 | <0.01 |
| show engine status | 7 | <0.1 | <0.01 |
| rollback | 4 | <0.1 | <0.01 |
| create db | 2 | <0.1 | <0.01 |
| show profile | 2 | <0.1 | <0.01 |
| rename table | 1 | <0.1 | <0.01 |