| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 5,387 k | 10.7 k | 86.24 |
| set option | 299 k | 593.6 | 4.79 |
| change db | 103 k | 204.1 | 1.65 |
| create table | 84,368 | 167.5 | 1.35 |
| show fields | 81,871 | 162.6 | 1.31 |
| update | 66,334 | 131.7 | 1.06 |
| show tables | 66,067 | 131.2 | 1.06 |
| insert | 47,588 | 94.5 | 0.76 |
| delete | 38,492 | 76.4 | 0.62 |
| show keys | 25,911 | 51.5 | 0.41 |
| update multi | 13,482 | 26.8 | 0.22 |
| show create table | 9,986 | 19.8 | 0.16 |
| show variables | 9,903 | 19.7 | 0.16 |
| replace | 5,072 | 10.1 | 0.08 |
| show storage engines | 2,403 | 4.8 | 0.04 |
| show warnings | 2,152 | 4.3 | 0.03 |
| insert select | 1,662 | 3.3 | 0.03 |
| show table status | 612 | 1.2 | 0.01 |
| show grants | 471 | 0.9 | 0.01 |
| show master status | 145 | 0.3 | <0.01 |
| show replica status | 145 | 0.3 | <0.01 |
| show slave status | 145 | 0.3 | <0.01 |
| delete multi | 136 | 0.3 | <0.01 |
| show binlogs | 100 | 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 | 12 | <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 processlist | 2 | <0.1 | <0.01 |
| drop table | 1 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |