Statements | # | ø per hour | % |
---|---|---|---|
select | 22,415 k | 260.6 k | 80.37 |
change db | 5,058 k | 58.8 k | 18.14 |
insert | 278 k | 3,231.6 | 1.00 |
set option | 40,670 | 472.8 | 0.15 |
delete | 28,953 | 336.6 | 0.10 |
update | 22,096 | 256.9 | 0.08 |
show create table | 10,802 | 125.6 | 0.04 |
commit | 8,275 | 96.2 | 0.03 |
show table status | 7,333 | 85.2 | 0.03 |
show fields | 5,974 | 69.4 | 0.02 |
show keys | 4,252 | 49.4 | 0.02 |
show triggers | 4,183 | 48.6 | 0.01 |
show create db | 3,126 | 36.3 | 0.01 |
show tables | 578 | 6.7 | <0.01 |
rollback | 199 | 2.3 | <0.01 |
truncate | 143 | 1.7 | <0.01 |
show grants | 67 | 0.8 | <0.01 |
show variables | 53 | 0.6 | <0.01 |
show binlogs | 32 | 0.4 | <0.01 |
show slave status | 12 | 0.1 | <0.01 |
show master status | 10 | 0.1 | <0.01 |
show storage engines | 5 | 0.1 | <0.01 |
show databases | 4 | <0.1 | <0.01 |
show collations | 4 | <0.1 | <0.01 |
show status | 3 | <0.1 | <0.01 |
show engine status | 2 | <0.1 | <0.01 |
replace | 1 | <0.1 | <0.01 |
show warnings | 1 | <0.1 | <0.01 |