说明 | 查询数量 | ø 每小时 | % |
---|---|---|---|
select | 858 k | 543.5 | 78.24 |
show tables | 62,170 | 39.4 | 5.67 |
show fields | 51,165 | 32.4 | 4.66 |
change db | 41,277 | 26.1 | 3.76 |
set option | 30,483 | 19.3 | 2.78 |
show keys | 17,777 | 11.3 | 1.62 |
show grants | 9,481 | 6 | 0.86 |
replace | 8,170 | 5.2 | 0.74 |
show variables | 5,797 | 3.7 | 0.53 |
show create table | 5,274 | 3.3 | 0.48 |
show warnings | 1,779 | 1.1 | 0.16 |
show storage engines | 1,652 | 1 | 0.15 |
stmt prepare | 674 | 0.4 | 0.06 |
show binlogs | 653 | 0.4 | 0.06 |
insert | 525 | 0.3 | 0.05 |
stmt close | 474 | 0.3 | 0.04 |
stmt execute | 474 | 0.3 | 0.04 |
show slave status | 258 | 0.2 | 0.02 |
show table status | 257 | 0.2 | 0.02 |
show master status | 248 | 0.2 | 0.02 |
show status | 65 | <0.1 | 0.01 |
show processlist | 8 | <0.1 | <0.01 |
show engine status | 6 | <0.1 | <0.01 |
flush | 5 | <0.1 | <0.01 |