| Statements | # | ø per hour | % |
|---|---|---|---|
| insert | 2,025 k | 4,457.4 | 63.65 |
| select | 521 k | 1,146.7 | 16.37 |
| commit | 295 k | 649 | 9.27 |
| delete | 158 k | 348.3 | 4.97 |
| set option | 102 k | 224.9 | 3.21 |
| insert select | 51,082 | 112.4 | 1.61 |
| show fields | 6,470 | 14.2 | 0.20 |
| show tables | 5,509 | 12.1 | 0.17 |
| change db | 4,820 | 10.6 | 0.15 |
| truncate | 3,364 | 7.4 | 0.11 |
| show keys | 3,149 | 6.9 | 0.10 |
| update | 2,636 | 5.8 | 0.08 |
| show create table | 1,153 | 2.5 | 0.04 |
| replace | 730 | 1.6 | 0.02 |
| show variables | 331 | 0.7 | 0.01 |
| show storage engines | 269 | 0.6 | 0.01 |
| drop temporary table | 219 | 0.5 | 0.01 |
| create temporary table | 219 | 0.5 | 0.01 |
| show grants | 166 | 0.4 | 0.01 |
| show table status | 46 | 0.1 | <0.01 |
| show status | 44 | 0.1 | <0.01 |
| show slave status | 43 | 0.1 | <0.01 |
| show master status | 40 | 0.1 | <0.01 |
| show binlogs | 38 | 0.1 | <0.01 |
| alter table | 38 | 0.1 | <0.01 |
| stmt execute | 24 | 0.1 | <0.01 |
| stmt prepare | 24 | 0.1 | <0.01 |
| stmt reprepare | 18 | <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 |
| stmt close | 6 | <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 |