说明 | 查询数量 | ø 每小时 | % |
---|---|---|---|
select | 164 M | 314.3 k | 80.65 |
show fields | 8,921 k | 17.1 k | 4.39 |
show tables | 7,463 k | 14.3 k | 3.67 |
change db | 5,966 k | 11.4 k | 2.93 |
set option | 4,476 k | 8,580.1 | 2.20 |
show keys | 4,071 k | 7,804.1 | 2.00 |
show variables | 2,969 k | 5,691.1 | 1.46 |
show grants | 1,486 k | 2,849.3 | 0.73 |
show create table | 1,481 k | 2,839.4 | 0.73 |
show warnings | 1,480 k | 2,837.9 | 0.73 |
replace | 1,006 k | 1,928.5 | 0.49 |
show binlogs | 4,767 | 9.1 | <0.01 |
stmt prepare | 880 | 1.7 | <0.01 |
stmt close | 535 | 1 | <0.01 |
stmt execute | 535 | 1 | <0.01 |
show storage engines | 413 | 0.8 | <0.01 |
show slave status | 282 | 0.5 | <0.01 |
show master status | 263 | 0.5 | <0.01 |
show table status | 210 | 0.4 | <0.01 |
update | 185 | 0.4 | <0.01 |
show status | 105 | 0.2 | <0.01 |
show processlist | 14 | <0.1 | <0.01 |
show engine status | 10 | <0.1 | <0.01 |
flush | 5 | <0.1 | <0.01 |
insert | 1 | <0.1 | <0.01 |