说明 | 查询数量 | ø 每小时 | % |
---|---|---|---|
select | 1,795 k | 18.8 k | 77.20 |
show tables | 122 k | 1,273.3 | 5.24 |
show fields | 118 k | 1,234.8 | 5.08 |
change db | 85,823 | 897 | 3.69 |
show keys | 64,636 | 675.5 | 2.78 |
set option | 63,780 | 666.6 | 2.74 |
show variables | 22,665 | 236.9 | 0.97 |
replace | 16,576 | 173.2 | 0.71 |
show create table | 14,927 | 156 | 0.64 |
show warnings | 9,814 | 102.6 | 0.42 |
show grants | 6,504 | 68 | 0.28 |
show storage engines | 1,858 | 19.4 | 0.08 |
show binlogs | 907 | 9.5 | 0.04 |
stmt prepare | 727 | 7.6 | 0.03 |
stmt close | 452 | 4.7 | 0.02 |
stmt execute | 452 | 4.7 | 0.02 |
show table status | 444 | 4.6 | 0.02 |
show slave status | 354 | 3.7 | 0.02 |
show master status | 338 | 3.5 | 0.01 |
show status | 80 | 0.8 | <0.01 |
update | 15 | 0.2 | <0.01 |
show processlist | 9 | 0.1 | <0.01 |
flush | 4 | <0.1 | <0.01 |
show engine status | 4 | <0.1 | <0.01 |