说明 | 查询数量 | ø 每小时 | % |
---|---|---|---|
select | 559 M | 372.5 k | 79.34 |
show fields | 32,218 k | 21.5 k | 4.57 |
show tables | 30,793 k | 20.5 k | 4.37 |
change db | 23,066 k | 15.4 k | 3.27 |
set option | 18,484 k | 12.3 k | 2.62 |
show keys | 13,331 k | 8,886.6 | 1.89 |
show variables | 9,184 k | 6,122.3 | 1.30 |
show grants | 4,588 k | 3,058.6 | 0.65 |
show create table | 4,581 k | 3,053.5 | 0.65 |
show warnings | 4,579 k | 3,052.5 | 0.65 |
replace | 3,513 k | 2,341.7 | 0.50 |
show binlogs | 1,182 k | 787.9 | 0.17 |
update | 12,862 | 8.6 | <0.01 |
show storage engines | 2,971 | 2 | <0.01 |
stmt prepare | 1,585 | 1.1 | <0.01 |
insert | 1,564 | 1 | <0.01 |
delete | 1,022 | 0.7 | <0.01 |
stmt close | 1,017 | 0.7 | <0.01 |
stmt execute | 1,017 | 0.7 | <0.01 |
show table status | 811 | 0.5 | <0.01 |
show slave status | 202 | 0.1 | <0.01 |
show master status | 193 | 0.1 | <0.01 |
show status | 25 | <0.1 | <0.01 |
flush | 4 | <0.1 | <0.01 |
show databases | 2 | <0.1 | <0.01 |
show engine status | 2 | <0.1 | <0.01 |
show processlist | 2 | <0.1 | <0.01 |