Keterangan | # | ø per hour | % |
---|---|---|---|
select | 2,047 k | 41.5 k | 72.31 |
change db | 564 k | 11.4 k | 19.93 |
insert | 97,992 | 1,985.7 | 3.46 |
update | 47,721 | 967 | 1.69 |
set option | 18,387 | 372.6 | 0.65 |
show fields | 13,833 | 280.3 | 0.49 |
delete | 11,428 | 231.6 | 0.40 |
show keys | 11,160 | 226.1 | 0.39 |
show create table | 7,477 | 151.5 | 0.26 |
show tables | 3,256 | 66 | 0.12 |
show table status | 2,074 | 42 | 0.07 |
show triggers | 2,062 | 41.8 | 0.07 |
commit | 1,827 | 37 | 0.06 |
show grants | 793 | 16.1 | 0.03 |
replace | 604 | 12.2 | 0.02 |
show variables | 306 | 6.2 | 0.01 |
show storage engines | 218 | 4.4 | 0.01 |
truncate | 148 | 3 | 0.01 |
show binlogs | 116 | 2.4 | <0.01 |
show warnings | 49 | 1 | <0.01 |
rollback | 42 | 0.9 | <0.01 |
show slave status | 41 | 0.8 | <0.01 |
show master status | 38 | 0.8 | <0.01 |
show status | 15 | 0.3 | <0.01 |
show collations | 8 | 0.2 | <0.01 |
show processlist | 2 | <0.1 | <0.01 |
flush | 1 | <0.1 | <0.01 |
show engine status | 1 | <0.1 | <0.01 |