说明 | 查询数量 | ø 每小时 | % |
---|---|---|---|
select | 852 k | 539.7 | 78.24 |
show tables | 61,729 | 39.1 | 5.67 |
show fields | 50,805 | 32.2 | 4.66 |
change db | 40,950 | 25.9 | 3.76 |
set option | 30,258 | 19.2 | 2.78 |
show keys | 17,659 | 11.2 | 1.62 |
show grants | 9,471 | 6 | 0.87 |
replace | 8,120 | 5.1 | 0.75 |
show variables | 5,765 | 3.7 | 0.53 |
show create table | 5,246 | 3.3 | 0.48 |
show warnings | 1,770 | 1.1 | 0.16 |
show storage engines | 1,643 | 1 | 0.15 |
show binlogs | 650 | 0.4 | 0.06 |
stmt prepare | 630 | 0.4 | 0.06 |
insert | 525 | 0.3 | 0.05 |
stmt close | 450 | 0.3 | 0.04 |
stmt execute | 450 | 0.3 | 0.04 |
show table status | 256 | 0.2 | 0.02 |
show slave status | 255 | 0.2 | 0.02 |
show master status | 245 | 0.2 | 0.02 |
show status | 64 | <0.1 | 0.01 |
show processlist | 8 | <0.1 | <0.01 |
show engine status | 6 | <0.1 | <0.01 |
flush | 4 | <0.1 | <0.01 |