说明 | 查询数量 | ø 每小时 | % |
---|---|---|---|
select | 246 M | 325.6 k | 79.89 |
show tables | 15,248 k | 20.2 k | 4.96 |
show fields | 12,890 k | 17.1 k | 4.19 |
change db | 10,397 k | 13.8 k | 3.38 |
set option | 9,150 k | 12.1 k | 2.97 |
show keys | 5,672 k | 7,515.5 | 1.84 |
show variables | 2,490 k | 3,299.2 | 0.81 |
show grants | 1,255 k | 1,662.9 | 0.41 |
show create table | 1,246 k | 1,651.6 | 0.41 |
show warnings | 1,244 k | 1,648.1 | 0.40 |
show binlogs | 1,182 k | 1,566.4 | 0.38 |
replace | 962 k | 1,274.5 | 0.31 |
update | 121 k | 160.6 | 0.04 |
show storage engines | 2,282 | 3 | <0.01 |
stmt prepare | 1,398 | 1.9 | <0.01 |
stmt close | 782 | 1 | <0.01 |
stmt execute | 782 | 1 | <0.01 |
insert | 574 | 0.8 | <0.01 |
delete | 414 | 0.5 | <0.01 |
show slave status | 124 | 0.2 | <0.01 |
show master status | 120 | 0.2 | <0.01 |
show table status | 113 | 0.1 | <0.01 |
show status | 27 | <0.1 | <0.01 |
show processlist | 4 | <0.1 | <0.01 |
flush | 2 | <0.1 | <0.01 |
show engine status | 2 | <0.1 | <0.01 |