说明 | 查询数量 | ø 每小时 | % |
---|---|---|---|
select | 1,050 k | 7,114.5 | 27.97 |
change db | 836 k | 5,663 | 22.26 |
delete | 798 k | 5,404.6 | 21.25 |
insert | 798 k | 5,404.5 | 21.25 |
show fields | 73,452 | 497.5 | 1.96 |
set option | 58,738 | 397.8 | 1.56 |
show variables | 36,293 | 245.8 | 0.97 |
show tables | 19,736 | 133.7 | 0.53 |
show grants | 18,958 | 128.4 | 0.50 |
show keys | 18,664 | 126.4 | 0.50 |
show create table | 17,996 | 121.9 | 0.48 |
show warnings | 17,834 | 120.8 | 0.47 |
replace | 10,339 | 70 | 0.28 |
show binlogs | 850 | 5.8 | 0.02 |
show storage engines | 145 | 1 | <0.01 |
update | 59 | 0.4 | <0.01 |
show table status | 40 | 0.3 | <0.01 |
show slave status | 35 | 0.2 | <0.01 |
show master status | 34 | 0.2 | <0.01 |
show collations | 11 | 0.1 | <0.01 |
stmt close | 7 | <0.1 | <0.01 |
stmt execute | 7 | <0.1 | <0.01 |
stmt prepare | 7 | <0.1 | <0.01 |
show status | 5 | <0.1 | <0.01 |
show processlist | 1 | <0.1 | <0.01 |
flush | 1 | <0.1 | <0.01 |
show databases | 1 | <0.1 | <0.01 |