说明 | 查询数量 | ø 每小时 | % |
---|---|---|---|
select | 167 k | 966.4 | 78.49 |
show tables | 13,288 | 77.1 | 6.26 |
show fields | 7,662 | 44.5 | 3.61 |
change db | 7,189 | 41.7 | 3.39 |
set option | 6,750 | 39.2 | 3.18 |
stmt execute | 3,158 | 18.3 | 1.49 |
stmt prepare | 3,060 | 17.8 | 1.44 |
stmt close | 1,963 | 11.4 | 0.92 |
show keys | 745 | 4.3 | 0.35 |
show variables | 335 | 1.9 | 0.16 |
show grants | 334 | 1.9 | 0.16 |
update | 290 | 1.7 | 0.14 |
show create table | 213 | 1.2 | 0.10 |
show binlogs | 153 | 0.9 | 0.07 |
show warnings | 99 | 0.6 | 0.05 |
show slave status | 82 | 0.5 | 0.04 |
show master status | 77 | 0.4 | 0.04 |
replace | 63 | 0.4 | 0.03 |
begin | 50 | 0.3 | 0.02 |
commit | 50 | 0.3 | 0.02 |
show status | 25 | 0.1 | 0.01 |
show storage engines | 24 | 0.1 | 0.01 |
delete | 20 | 0.1 | 0.01 |
insert | 10 | 0.1 | <0.01 |
create table | 8 | <0.1 | <0.01 |
create db | 3 | <0.1 | <0.01 |
show processlist | 3 | <0.1 | <0.01 |
show engine status | 2 | <0.1 | <0.01 |
show table status | 2 | <0.1 | <0.01 |
drop db | 1 | <0.1 | <0.01 |
flush | 1 | <0.1 | <0.01 |