| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 35,381 k | 144.3 k | 49.55 |
| set option | 9,349 k | 38.1 k | 13.09 |
| show fields | 6,197 k | 25.3 k | 8.68 |
| show tables | 4,490 k | 18.3 k | 6.29 |
| change db | 2,980 k | 12.2 k | 4.17 |
| show variables | 2,958 k | 12.1 k | 4.14 |
| show keys | 1,485 k | 6,058.4 | 2.08 |
| show grants | 1,480 k | 6,035.8 | 2.07 |
| show create table | 1,479 k | 6,033.6 | 2.07 |
| show warnings | 1,478 k | 6,030 | 2.07 |
| insert | 1,180 k | 4,811.9 | 1.65 |
| update | 819 k | 3,340.3 | 1.15 |
| begin | 708 k | 2,889.4 | 0.99 |
| commit | 708 k | 2,889.4 | 0.99 |
| delete | 597 k | 2,435.3 | 0.84 |
| insert select | 91,627 | 373.8 | 0.13 |
| show binlogs | 13,397 | 54.6 | 0.02 |
| create temporary table | 2,699 | 11 | <0.01 |
| drop temporary table | 2,695 | 11 | <0.01 |
| show storage engines | 489 | 2 | <0.01 |
| show slave status | 130 | 0.5 | <0.01 |
| show master status | 125 | 0.5 | <0.01 |
| stmt close | 111 | 0.5 | <0.01 |
| stmt execute | 111 | 0.5 | <0.01 |
| stmt prepare | 111 | 0.5 | <0.01 |
| show table status | 51 | 0.2 | <0.01 |
| alter table | 24 | 0.1 | <0.01 |
| create table | 24 | 0.1 | <0.01 |
| show status | 20 | 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 databases | 2 | <0.1 | <0.01 |
| show function status | 2 | <0.1 | <0.01 |
| show procedure status | 2 | <0.1 | <0.01 |
| show processlist | 2 | <0.1 | <0.01 |
| show triggers | 2 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
| show collations | 1 | <0.1 | <0.01 |