控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 1,169 M | 196.1 k | 78.46 |
| show fields | 76,698 k | 12.9 k | 5.15 |
| show tables | 64,995 k | 10.9 k | 4.36 |
| change db | 48,442 k | 8,126.2 | 3.25 |
| show keys | 40,141 k | 6,733.7 | 2.69 |
| set option | 38,957 k | 6,535 | 2.61 |
| show variables | 18,852 k | 3,162.4 | 1.27 |
| show create table | 9,436 k | 1,582.8 | 0.63 |
| show warnings | 9,415 k | 1,579.4 | 0.63 |
| show grants | 9,406 k | 1,577.9 | 0.63 |
| replace | 3,420 k | 573.7 | 0.23 |
| show binlogs | 751 k | 125.9 | 0.05 |
| update | 417 k | 70 | 0.03 |
| show storage engines | 11,961 | 2 | <0.01 |
| stmt close | 4,791 | 0.8 | <0.01 |
| stmt execute | 4,791 | 0.8 | <0.01 |
| stmt prepare | 4,791 | 0.8 | <0.01 |
| show slave status | 2,287 | 0.4 | <0.01 |
| show master status | 2,053 | 0.3 | <0.01 |
| show table status | 1,664 | 0.3 | <0.01 |
| show status | 423 | 0.1 | <0.01 |
| show processlist | 41 | <0.1 | <0.01 |
| flush | 33 | <0.1 | <0.01 |
| show engine status | 31 | <0.1 | <0.01 |
| insert | 1 | <0.1 | <0.01 |