说明 | 查询数量 | ø 每小时 | % |
---|---|---|---|
select | 3,532 k | 2,421.3 | 94.00 |
insert | 55,562 | 38.1 | 1.48 |
set option | 47,949 | 32.9 | 1.28 |
show tables | 25,644 | 17.6 | 0.68 |
update | 24,115 | 16.5 | 0.64 |
show fields | 19,316 | 13.2 | 0.51 |
change db | 19,210 | 13.2 | 0.51 |
insert select | 15,814 | 10.8 | 0.42 |
delete | 13,845 | 9.5 | 0.37 |
show keys | 1,456 | 1 | 0.04 |
show variables | 595 | 0.4 | 0.02 |
show create table | 431 | 0.3 | 0.01 |
replace | 412 | 0.3 | 0.01 |
show grants | 189 | 0.1 | 0.01 |
show storage engines | 136 | 0.1 | <0.01 |
delete multi | 116 | 0.1 | <0.01 |
stmt prepare | 104 | 0.1 | <0.01 |
show binlogs | 100 | 0.1 | <0.01 |
show warnings | 100 | 0.1 | <0.01 |
alter table | 92 | 0.1 | <0.01 |
show slave status | 59 | <0.1 | <0.01 |
show master status | 56 | <0.1 | <0.01 |
stmt close | 56 | <0.1 | <0.01 |
stmt execute | 56 | <0.1 | <0.01 |
show table status | 30 | <0.1 | <0.01 |
show status | 8 | <0.1 | <0.01 |
truncate | 7 | <0.1 | <0.01 |
show databases | 3 | <0.1 | <0.01 |
flush | 1 | <0.1 | <0.01 |
show processlist | 1 | <0.1 | <0.01 |