Console
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 1,416 k | 2,591.4 | 77.10 |
| show fields | 93,480 | 171 | 5.09 |
| show tables | 89,865 | 164.4 | 4.89 |
| change db | 65,410 | 119.7 | 3.56 |
| show keys | 55,047 | 100.7 | 3.00 |
| set option | 48,759 | 89.2 | 2.65 |
| show variables | 20,551 | 37.6 | 1.12 |
| replace | 14,756 | 27 | 0.80 |
| show create table | 12,431 | 22.7 | 0.68 |
| show warnings | 9,461 | 17.3 | 0.52 |
| stmt execute | 2,852 | 5.2 | 0.16 |
| stmt prepare | 2,852 | 5.2 | 0.16 |
| stmt close | 2,755 | 5 | 0.15 |
| show storage engines | 1,387 | 2.5 | 0.08 |
| show slave status | 163 | 0.3 | 0.01 |
| show master status | 158 | 0.3 | 0.01 |
| insert | 155 | 0.3 | 0.01 |
| update | 147 | 0.3 | 0.01 |
| show table status | 126 | 0.2 | 0.01 |
| show grants | 95 | 0.2 | 0.01 |
| show status | 71 | 0.1 | <0.01 |
| show binlogs | 52 | 0.1 | <0.01 |
| delete | 22 | <0.1 | <0.01 |
| show function status | 8 | <0.1 | <0.01 |
| show procedure status | 8 | <0.1 | <0.01 |
| show triggers | 8 | <0.1 | <0.01 |
| alter table | 5 | <0.1 | <0.01 |
| show engine status | 4 | <0.1 | <0.01 |
| show processlist | 3 | <0.1 | <0.01 |
| create table | 2 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
| show collations | 1 | <0.1 | <0.01 |
| show databases | 1 | <0.1 | <0.01 |
| show open tables | 1 | <0.1 | <0.01 |