Console
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 2,210 k | 48.8 k | 35.26 |
| stmt execute | 1,258 k | 27.8 k | 20.07 |
| stmt close | 1,258 k | 27.8 k | 20.07 |
| stmt prepare | 1,258 k | 27.8 k | 20.07 |
| show tables | 61,979 | 1,370 | 0.99 |
| set option | 58,654 | 1,296.5 | 0.94 |
| show fields | 56,300 | 1,244.4 | 0.90 |
| change db | 42,963 | 949.6 | 0.69 |
| show keys | 19,600 | 433.2 | 0.31 |
| replace | 8,286 | 183.2 | 0.13 |
| insert | 8,103 | 179.1 | 0.13 |
| show create table | 6,994 | 154.6 | 0.11 |
| show variables | 6,568 | 145.2 | 0.10 |
| update | 4,956 | 109.5 | 0.08 |
| begin | 1,589 | 35.1 | 0.03 |
| commit | 1,572 | 34.7 | 0.03 |
| show storage engines | 1,384 | 30.6 | 0.02 |
| show grants | 1,354 | 29.9 | 0.02 |
| show warnings | 1,298 | 28.7 | 0.02 |
| show table status | 768 | 17 | 0.01 |
| delete | 279 | 6.2 | <0.01 |
| show binlogs | 207 | 4.6 | <0.01 |
| show slave status | 64 | 1.4 | <0.01 |
| show master status | 60 | 1.3 | <0.01 |
| show status | 51 | 1.1 | <0.01 |
| rollback | 23 | 0.5 | <0.01 |
| show function status | 21 | 0.5 | <0.01 |
| show procedure status | 21 | 0.5 | <0.01 |
| show triggers | 20 | 0.4 | <0.01 |
| show databases | 12 | 0.3 | <0.01 |
| alter table | 9 | 0.2 | <0.01 |
| show open tables | 9 | 0.2 | <0.01 |
| show collations | 6 | 0.1 | <0.01 |
| show processlist | 3 | 0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |
| truncate | 2 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |