Statements | # | ø per hour | % |
---|---|---|---|
select | 3,976 k | 99.2 k | 63.41 |
show tables | 1,151 k | 28.7 k | 18.36 |
change db | 1,013 k | 25.3 k | 16.15 |
insert | 75,313 | 1,879.5 | 1.20 |
set option | 16,723 | 417.3 | 0.27 |
show fields | 7,666 | 191.3 | 0.12 |
update | 6,283 | 156.8 | 0.10 |
delete | 6,281 | 156.7 | 0.10 |
show keys | 5,294 | 132.1 | 0.08 |
show create table | 5,000 | 124.8 | 0.08 |
commit | 2,519 | 62.9 | 0.04 |
show table status | 2,056 | 51.3 | 0.03 |
show triggers | 2,048 | 51.1 | 0.03 |
show grants | 124 | 3.1 | <0.01 |
rollback | 98 | 2.4 | <0.01 |
show variables | 51 | 1.3 | <0.01 |
show binlogs | 47 | 1.2 | <0.01 |
truncate | 35 | 0.9 | <0.01 |
show slave status | 28 | 0.7 | <0.01 |
show master status | 26 | 0.6 | <0.01 |
stmt close | 22 | 0.5 | <0.01 |
stmt execute | 22 | 0.5 | <0.01 |
stmt prepare | 22 | 0.5 | <0.01 |
replace | 10 | 0.2 | <0.01 |
show warnings | 9 | 0.2 | <0.01 |
show storage engines | 6 | 0.1 | <0.01 |
show status | 4 | 0.1 | <0.01 |
show collations | 2 | <0.1 | <0.01 |