控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 1,946 k | 47.7 k | 77.86 |
| show tables | 137 k | 3,348.8 | 5.47 |
| show fields | 118 k | 2,881.8 | 4.71 |
| change db | 96,795 | 2,371.7 | 3.87 |
| set option | 70,054 | 1,716.5 | 2.80 |
| show keys | 42,076 | 1,030.9 | 1.68 |
| show variables | 13,152 | 322.2 | 0.53 |
| show create table | 12,559 | 307.7 | 0.50 |
| stmt prepare | 11,993 | 293.9 | 0.48 |
| stmt close | 11,992 | 293.8 | 0.48 |
| stmt execute | 11,992 | 293.8 | 0.48 |
| replace | 11,530 | 282.5 | 0.46 |
| show grants | 6,541 | 160.3 | 0.26 |
| show warnings | 3,591 | 88 | 0.14 |
| show storage engines | 3,132 | 76.7 | 0.13 |
| show table status | 864 | 21.2 | 0.03 |
| show binlogs | 736 | 18 | 0.03 |
| show slave status | 647 | 15.9 | 0.03 |
| show master status | 632 | 15.5 | 0.03 |
| update | 300 | 7.4 | 0.01 |
| insert | 164 | 4 | 0.01 |
| show status | 71 | 1.7 | <0.01 |
| delete | 37 | 0.9 | <0.01 |
| show create proc | 36 | 0.9 | <0.01 |
| show create func | 9 | 0.2 | <0.01 |
| show processlist | 7 | 0.2 | <0.01 |
| flush | 6 | 0.1 | <0.01 |
| empty query | 4 | 0.1 | <0.01 |
| show engine status | 4 | 0.1 | <0.01 |
| alter table | 3 | 0.1 | <0.01 |
| insert select | 2 | <0.1 | <0.01 |