| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 35,454 k | 144.5 k | 49.56 |
| set option | 9,367 k | 38.2 k | 13.09 |
| show fields | 6,209 k | 25.3 k | 8.68 |
| show tables | 4,501 k | 18.3 k | 6.29 |
| change db | 2,986 k | 12.2 k | 4.17 |
| show variables | 2,962 k | 12.1 k | 4.14 |
| show keys | 1,492 k | 6,083 | 2.09 |
| show create table | 1,482 k | 6,041.7 | 2.07 |
| show grants | 1,481 k | 6,038 | 2.07 |
| show warnings | 1,480 k | 6,033.4 | 2.07 |
| insert | 1,181 k | 4,811.9 | 1.65 |
| update | 819 k | 3,340.3 | 1.15 |
| begin | 709 k | 2,889.4 | 0.99 |
| commit | 709 k | 2,889.4 | 0.99 |
| delete | 597 k | 2,435.3 | 0.84 |
| insert select | 91,695 | 373.8 | 0.13 |
| show binlogs | 13,423 | 54.7 | 0.02 |
| create temporary table | 2,701 | 11 | <0.01 |
| drop temporary table | 2,697 | 11 | <0.01 |
| show storage engines | 919 | 3.7 | <0.01 |
| show table status | 229 | 0.9 | <0.01 |
| stmt close | 183 | 0.7 | <0.01 |
| stmt execute | 183 | 0.7 | <0.01 |
| stmt prepare | 183 | 0.7 | <0.01 |
| show slave status | 143 | 0.6 | <0.01 |
| show master status | 138 | 0.6 | <0.01 |
| show status | 28 | 0.1 | <0.01 |
| alter table | 24 | 0.1 | <0.01 |
| create table | 24 | 0.1 | <0.01 |
| drop table | 18 | 0.1 | <0.01 |
| update multi | 7 | <0.1 | <0.01 |
| show binlog events | 5 | <0.1 | <0.01 |
| show slave hosts | 5 | <0.1 | <0.01 |
| show processlist | 3 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| show databases | 2 | <0.1 | <0.01 |
| show function status | 2 | <0.1 | <0.01 |
| show procedure status | 2 | <0.1 | <0.01 |
| show triggers | 2 | <0.1 | <0.01 |
| show collations | 1 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |