Các câu lệnh | # | ø per hour | % |
---|---|---|---|
select | 60.398 k | 92,2 k | 78,48 |
show fields | 3.957 k | 6.039,3 | 5,14 |
show tables | 3.318 k | 5.064,2 | 4,31 |
change db | 2.646 k | 4.038 | 3,44 |
set option | 2.003 k | 3.057,6 | 2,60 |
show keys | 1.323 k | 2.019 | 1,72 |
show variables | 1.311 k | 2.001,4 | 1,70 |
show grants | 656 k | 1.001,6 | <0.01 |
show create table | 656 k | 1.000,9 | <0.01 |
show warnings | 655 k | 1.000,3 | <0.01 |
update | 22.485 | 34,3 | <0.01 |
show binlogs | 6.535 | 10 | <0.01 |
begin | 1.587 | 2,4 | <0.01 |
commit | 1.567 | 2,4 | <0.01 |
insert | 923 | 1,4 | <0.01 |
replace | 811 | 1,2 | <0.01 |
create table | 584 | 0,9 | <0.01 |
stmt execute | 578 | 0,9 | <0.01 |
stmt prepare | 578 | 0,9 | <0.01 |
delete | 250 | 0,4 | <0.01 |
stmt close | 243 | 0,4 | <0.01 |
show storage engines | 146 | 0,2 | <0.01 |
show slave status | 134 | 0,2 | <0.01 |
show master status | 121 | 0,2 | <0.01 |
show table status | 80 | 0,1 | <0.01 |
show status | 32 | <0,1 | <0.01 |
rollback | 20 | <0,1 | <0.01 |
flush | 4 | <0,1 | <0.01 |
show processlist | 3 | <0,1 | <0.01 |