Các câu lệnh | # | ø per hour | % |
---|---|---|---|
select | 11.266 k | 40,5 k | 80,70 |
show tables | 744 k | 2.670,3 | 5,33 |
show fields | 563 k | 2.022,1 | 4,03 |
change db | 487 k | 1.748,8 | 3,49 |
set option | 452 k | 1.624,9 | 3,24 |
show keys | 191 k | 686,7 | 1,37 |
show variables | 75.681 | 271,8 | <0.01 |
show grants | 38.423 | 138 | <0.01 |
show create table | 37.901 | 136,1 | <0.01 |
show warnings | 37.624 | 135,1 | <0.01 |
show binlogs | 33.190 | 119,2 | <0.01 |
update | 22.755 | 81,7 | <0.01 |
replace | 4.249 | 15,3 | <0.01 |
delete | 3.412 | 12,3 | <0.01 |
insert | 2.953 | 10,6 | <0.01 |
show storage engines | 238 | 0,9 | <0.01 |
show slave status | 97 | 0,3 | <0.01 |
show master status | 93 | 0,3 | <0.01 |
stmt close | 63 | 0,2 | <0.01 |
stmt execute | 63 | 0,2 | <0.01 |
stmt prepare | 63 | 0,2 | <0.01 |
delete multi | 41 | 0,1 | <0.01 |
insert select | 34 | 0,1 | <0.01 |
show table status | 20 | 0,1 | <0.01 |
show status | 17 | 0,1 | <0.01 |
flush | 1 | <0,1 | <0.01 |
show processlist | 1 | <0,1 | <0.01 |