| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 5,457 k | 10.8 k | 85.61 |
| set option | 311 k | 615.6 | 4.87 |
| change db | 107 k | 212.7 | 1.68 |
| show fields | 91,281 | 180.9 | 1.43 |
| create table | 84,439 | 167.3 | 1.32 |
| show tables | 84,286 | 167 | 1.32 |
| update | 66,469 | 131.7 | 1.04 |
| insert | 47,676 | 94.5 | 0.75 |
| delete | 38,574 | 76.4 | 0.61 |
| show keys | 32,209 | 63.8 | 0.51 |
| update multi | 13,517 | 26.8 | 0.21 |
| show variables | 12,928 | 25.6 | 0.20 |
| show create table | 12,612 | 25 | 0.20 |
| replace | 5,072 | 10.1 | 0.08 |
| show storage engines | 3,010 | 6 | 0.05 |
| show warnings | 2,836 | 5.6 | 0.04 |
| insert select | 1,663 | 3.3 | 0.03 |
| show table status | 842 | 1.7 | 0.01 |
| show grants | 589 | 1.2 | 0.01 |
| show master status | 154 | 0.3 | <0.01 |
| show replica status | 154 | 0.3 | <0.01 |
| show slave status | 154 | 0.3 | <0.01 |
| delete multi | 138 | 0.3 | <0.01 |
| show binlogs | 115 | 0.2 | <0.01 |
| stmt execute | 79 | 0.2 | <0.01 |
| stmt close | 79 | 0.2 | <0.01 |
| stmt prepare | 79 | 0.2 | <0.01 |
| stmt send long data | 55 | 0.1 | <0.01 |
| do | 33 | 0.1 | <0.01 |
| truncate | 33 | 0.1 | <0.01 |
| show status | 14 | <0.1 | <0.01 |
| alter table | 6 | <0.1 | <0.01 |
| show triggers | 6 | <0.1 | <0.01 |
| show binlog events | 4 | <0.1 | <0.01 |
| show replicas | 4 | <0.1 | <0.01 |
| show slave hosts | 4 | <0.1 | <0.01 |
| create db | 3 | <0.1 | <0.01 |
| flush | 3 | <0.1 | <0.01 |
| lock tables | 3 | <0.1 | <0.01 |
| show function status | 3 | <0.1 | <0.01 |
| show procedure status | 3 | <0.1 | <0.01 |
| unlock tables | 3 | <0.1 | <0.01 |
| drop db | 2 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |
| show processlist | 2 | <0.1 | <0.01 |
| drop table | 1 | <0.1 | <0.01 |