说明 | 查询数量 | ø 每小时 | % |
---|---|---|---|
select | 4,193 k | 209.5 k | 79.42 |
change db | 941 k | 47 k | 17.81 |
insert | 100 k | 5,000.2 | 1.90 |
delete | 14,505 | 724.6 | 0.27 |
set option | 12,043 | 601.6 | 0.23 |
update | 7,392 | 369.3 | 0.14 |
commit | 2,921 | 145.9 | 0.06 |
show table status | 2,115 | 105.7 | 0.04 |
show create table | 2,100 | 104.9 | 0.04 |
show fields | 1,411 | 70.5 | 0.03 |
show keys | 1,066 | 53.3 | 0.02 |
show triggers | 1,043 | 52.1 | 0.02 |
show create db | 1,042 | 52.1 | 0.02 |
show tables | 174 | 8.7 | <0.01 |
truncate | 97 | 4.8 | <0.01 |
show variables | 46 | 2.3 | <0.01 |
show grants | 29 | 1.4 | <0.01 |
rollback | 28 | 1.4 | <0.01 |
show warnings | 14 | 0.7 | <0.01 |
replace | 12 | 0.6 | <0.01 |
show binlogs | 5 | 0.2 | <0.01 |
show status | 2 | 0.1 | <0.01 |
show master status | 2 | 0.1 | <0.01 |
show slave status | 2 | 0.1 | <0.01 |
show storage engines | 1 | <0.1 | <0.01 |
show collations | 1 | <0.1 | <0.01 |