Console
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 11,463 k | 6,952.4 | 61.99 |
| set option | 2,801 k | 1,698.7 | 15.15 |
| show tables | 2,286 k | 1,386.8 | 12.37 |
| show fields | 497 k | 301.7 | 2.69 |
| show keys | 309 k | 187.2 | 1.67 |
| show variables | 308 k | 186.6 | 1.66 |
| change db | 174 k | 105.8 | 0.94 |
| show grants | 171 k | 104 | 0.93 |
| show create table | 158 k | 95.9 | 0.85 |
| 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,343 | 2.6 | 0.02 |
| show master status | 1,982 | 1.2 | 0.01 |
| show replica status | 1,982 | 1.2 | 0.01 |
| show slave status | 1,982 | 1.2 | 0.01 |
| commit | 1,882 | 1.1 | 0.01 |
| begin | 1,834 | 1.1 | 0.01 |
| stmt execute | 726 | 0.4 | <0.01 |
| stmt close | 726 | 0.4 | <0.01 |
| stmt prepare | 726 | 0.4 | <0.01 |
| show table status | 373 | 0.2 | <0.01 |
| insert | 353 | 0.2 | <0.01 |
| delete | 228 | 0.1 | <0.01 |
| show status | 100 | 0.1 | <0.01 |
| flush | 75 | <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 |