说明 | 查询数量 | ø 每小时 | % |
---|---|---|---|
select | 824 k | 522.3 | 78.29 |
show tables | 59,248 | 37.6 | 5.63 |
show fields | 48,924 | 31 | 4.65 |
change db | 39,362 | 25 | 3.74 |
set option | 29,181 | 18.5 | 2.77 |
show keys | 16,918 | 10.7 | 1.61 |
show grants | 9,427 | 6 | 0.90 |
replace | 7,920 | 5 | 0.75 |
show variables | 5,561 | 3.5 | 0.53 |
show create table | 5,080 | 3.2 | 0.48 |
show warnings | 1,731 | 1.1 | 0.16 |
show storage engines | 1,587 | 1 | 0.15 |
show binlogs | 635 | 0.4 | 0.06 |
stmt prepare | 575 | 0.4 | 0.05 |
insert | 525 | 0.3 | 0.05 |
stmt close | 420 | 0.3 | 0.04 |
stmt execute | 420 | 0.3 | 0.04 |
show table status | 245 | 0.2 | 0.02 |
show slave status | 238 | 0.2 | 0.02 |
show master status | 230 | 0.1 | 0.02 |
show status | 57 | <0.1 | 0.01 |
show processlist | 7 | <0.1 | <0.01 |
show engine status | 6 | <0.1 | <0.01 |
flush | 4 | <0.1 | <0.01 |