Statements | # | ø per hour | % |
---|---|---|---|
select | 22,722 k | 253.1 k | 80.26 |
change db | 5,162 k | 57.5 k | 18.24 |
insert | 281 k | 3,125.7 | 0.99 |
set option | 41,039 | 457.2 | 0.14 |
delete | 29,364 | 327.1 | 0.10 |
update | 22,343 | 248.9 | 0.08 |
show create table | 11,875 | 132.3 | 0.04 |
show table status | 8,381 | 93.4 | 0.03 |
commit | 8,325 | 92.7 | 0.03 |
show fields | 7,533 | 83.9 | 0.03 |
show keys | 6,601 | 73.5 | 0.02 |
show triggers | 4,184 | 46.6 | 0.01 |
show create db | 4,168 | 46.4 | 0.01 |
show tables | 1,093 | 12.2 | <0.01 |
rollback | 200 | 2.2 | <0.01 |
show grants | 152 | 1.7 | <0.01 |
truncate | 143 | 1.6 | <0.01 |
show variables | 92 | 1 | <0.01 |
show binlogs | 75 | 0.8 | <0.01 |
show slave status | 19 | 0.2 | <0.01 |
show storage engines | 17 | 0.2 | <0.01 |
show master status | 17 | 0.2 | <0.01 |
show status | 11 | 0.1 | <0.01 |
show databases | 4 | <0.1 | <0.01 |
show collations | 4 | <0.1 | <0.01 |
show engine status | 3 | <0.1 | <0.01 |
replace | 1 | <0.1 | <0.01 |
show processlist | 1 | <0.1 | <0.01 |
show warnings | 1 | <0.1 | <0.01 |