说明 | 查询数量 | ø 每小时 | % |
---|---|---|---|
select | 1,200 k | 16.3 k | 64.26 |
set option | 166 k | 2,251.5 | 8.88 |
show fields | 133 k | 1,803 | 7.11 |
show keys | 104 k | 1,416.5 | 5.59 |
change db | 54,251 | 736.5 | 2.91 |
replace | 49,872 | 677 | 2.67 |
show variables | 45,243 | 614.2 | 2.42 |
show tables | 39,324 | 533.8 | 2.11 |
show create table | 37,029 | 502.7 | 1.98 |
show warnings | 17,356 | 235.6 | 0.93 |
show storage engines | 10,766 | 146.2 | 0.58 |
show table status | 4,741 | 64.4 | 0.25 |
stmt close | 1,557 | 21.1 | 0.08 |
stmt execute | 1,557 | 21.1 | 0.08 |
stmt prepare | 1,557 | 21.1 | 0.08 |
delete | 721 | 9.8 | 0.04 |
show slave status | 149 | 2 | 0.01 |
show master status | 145 | 2 | 0.01 |
show grants | 36 | 0.5 | <0.01 |
show binlogs | 27 | 0.4 | <0.01 |
show status | 25 | 0.3 | <0.01 |
show processlist | 3 | <0.1 | <0.01 |
show engine status | 2 | <0.1 | <0.01 |
flush | 1 | <0.1 | <0.01 |