说明 | 查询数量 | ø 每小时 | % |
---|---|---|---|
select | 47,527 k | 29.8 k | 79.46 |
show fields | 2,857 k | 1,791.1 | 4.78 |
show tables | 2,328 k | 1,459.1 | 3.89 |
change db | 1,831 k | 1,147.5 | 3.06 |
show keys | 1,486 k | 931.6 | 2.48 |
set option | 1,388 k | 870.3 | 2.32 |
show variables | 855 k | 536 | 1.43 |
show create table | 429 k | 269.2 | 0.72 |
show warnings | 427 k | 267.9 | 0.71 |
show grants | 351 k | 220.2 | 0.59 |
replace | 166 k | 103.9 | 0.28 |
stmt close | 50,600 | 31.7 | 0.08 |
stmt execute | 50,600 | 31.7 | 0.08 |
stmt prepare | 50,600 | 31.7 | 0.08 |
show binlogs | 8,426 | 5.3 | 0.01 |
show storage engines | 2,430 | 1.5 | <0.01 |
update | 1,873 | 1.2 | <0.01 |
show slave status | 340 | 0.2 | <0.01 |
show master status | 326 | 0.2 | <0.01 |
show table status | 239 | 0.1 | <0.01 |
show status | 86 | 0.1 | <0.01 |
show processlist | 12 | <0.1 | <0.01 |
show engine status | 7 | <0.1 | <0.01 |
flush | 6 | <0.1 | <0.01 |
delete | 5 | <0.1 | <0.01 |
insert | 5 | <0.1 | <0.01 |
show databases | 1 | <0.1 | <0.01 |