说明 | 查询数量 | ø 每小时 | % |
---|---|---|---|
select | 113 M | 105.3 k | 79.24 |
show tables | 6,389 k | 5,957.5 | 4.48 |
show fields | 6,191 k | 5,772.7 | 4.34 |
change db | 4,620 k | 4,307.6 | 3.24 |
set option | 3,832 k | 3,572.9 | 2.69 |
show keys | 3,708 k | 3,457.7 | 2.60 |
show variables | 1,562 k | 1,456.3 | 1.10 |
show grants | 796 k | 742.6 | 0.56 |
show create table | 785 k | 732.2 | 0.55 |
show warnings | 779 k | 726.1 | 0.55 |
replace | 521 k | 485.4 | 0.37 |
show binlogs | 364 k | 339.1 | 0.26 |
update | 23,727 | 22.1 | 0.02 |
show storage engines | 3,870 | 3.6 | <0.01 |
stmt prepare | 2,178 | 2 | <0.01 |
stmt close | 1,322 | 1.2 | <0.01 |
stmt execute | 1,322 | 1.2 | <0.01 |
insert | 1,071 | 1 | <0.01 |
show table status | 954 | 0.9 | <0.01 |
delete | 702 | 0.7 | <0.01 |
show slave status | 259 | 0.2 | <0.01 |
show master status | 250 | 0.2 | <0.01 |
show status | 51 | <0.1 | <0.01 |
show engine status | 9 | <0.1 | <0.01 |
flush | 4 | <0.1 | <0.01 |
show processlist | 4 | <0.1 | <0.01 |