| Statements | # | ø per hour | % |
|---|---|---|---|
| insert | 2,025 k | 4,449.6 | 61.52 |
| select | 608 k | 1,336.6 | 18.48 |
| commit | 295 k | 647.8 | 8.96 |
| delete | 158 k | 347.7 | 4.81 |
| set option | 106 k | 231.9 | 3.21 |
| insert select | 51,082 | 112.2 | 1.55 |
| show tables | 11,794 | 25.9 | 0.36 |
| show fields | 11,058 | 24.3 | 0.34 |
| change db | 9,567 | 21 | 0.29 |
| show keys | 4,331 | 9.5 | 0.13 |
| truncate | 3,364 | 7.4 | 0.10 |
| update | 2,636 | 5.8 | 0.08 |
| show create table | 1,574 | 3.5 | 0.05 |
| show variables | 1,294 | 2.8 | 0.04 |
| replace | 1,203 | 2.6 | 0.04 |
| show storage engines | 365 | 0.8 | 0.01 |
| show grants | 344 | 0.8 | 0.01 |
| create temporary table | 219 | 0.5 | 0.01 |
| drop temporary table | 219 | 0.5 | 0.01 |
| show binlogs | 157 | 0.3 | <0.01 |
| stmt execute | 96 | 0.2 | <0.01 |
| stmt prepare | 96 | 0.2 | <0.01 |
| show warnings | 85 | 0.2 | <0.01 |
| stmt reprepare | 72 | 0.2 | <0.01 |
| show table status | 63 | 0.1 | <0.01 |
| show status | 48 | 0.1 | <0.01 |
| show slave status | 46 | 0.1 | <0.01 |
| show master status | 43 | 0.1 | <0.01 |
| alter table | 38 | 0.1 | <0.01 |
| stmt close | 24 | 0.1 | <0.01 |
| show procedure status | 8 | <0.1 | <0.01 |
| show create proc | 8 | <0.1 | <0.01 |
| show triggers | 8 | <0.1 | <0.01 |
| show function status | 8 | <0.1 | <0.01 |
| show databases | 5 | <0.1 | <0.01 |
| show open tables | 5 | <0.1 | <0.01 |
| show collations | 4 | <0.1 | <0.01 |
| show processlist | 1 | <0.1 | <0.01 |
| create table | 1 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |