| Statements | # | ø per hour | % |
|---|---|---|---|
| insert | 2,025 k | 4,406.5 | 53.32 |
| select | 1,000 k | 2,176.9 | 26.34 |
| commit | 295 k | 641.5 | 7.76 |
| delete | 158 k | 344.4 | 4.17 |
| set option | 120 k | 260.8 | 3.16 |
| insert select | 51,082 | 111.2 | 1.35 |
| show tables | 43,653 | 95 | 1.15 |
| show fields | 36,177 | 78.7 | 0.95 |
| change db | 29,986 | 65.3 | 0.79 |
| show keys | 13,032 | 28.4 | 0.34 |
| replace | 5,317 | 11.6 | 0.14 |
| show variables | 4,789 | 10.4 | 0.13 |
| show create table | 3,903 | 8.5 | 0.10 |
| truncate | 3,364 | 7.3 | 0.09 |
| update | 2,636 | 5.7 | 0.07 |
| show grants | 1,288 | 2.8 | 0.03 |
| show storage engines | 950 | 2.1 | 0.03 |
| show warnings | 926 | 2 | 0.02 |
| show binlogs | 297 | 0.6 | 0.01 |
| stmt prepare | 287 | 0.6 | 0.01 |
| stmt execute | 287 | 0.6 | 0.01 |
| show table status | 278 | 0.6 | 0.01 |
| drop temporary table | 219 | 0.5 | 0.01 |
| create temporary table | 219 | 0.5 | 0.01 |
| stmt reprepare | 214 | 0.5 | 0.01 |
| stmt close | 73 | 0.2 | <0.01 |
| show slave status | 69 | 0.2 | <0.01 |
| show master status | 65 | 0.1 | <0.01 |
| show status | 61 | 0.1 | <0.01 |
| alter table | 38 | 0.1 | <0.01 |
| show create proc | 12 | <0.1 | <0.01 |
| show procedure status | 8 | <0.1 | <0.01 |
| show triggers | 8 | <0.1 | <0.01 |
| show function status | 8 | <0.1 | <0.01 |
| show open tables | 5 | <0.1 | <0.01 |
| show databases | 5 | <0.1 | <0.01 |
| show collations | 4 | <0.1 | <0.01 |
| show processlist | 3 | <0.1 | <0.01 |
| show engine status | 3 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| create table | 1 | <0.1 | <0.01 |