| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 1,184 k | 2,009 | 78.94 |
| show tables | 87,030 | 147.7 | 5.80 |
| change db | 69,071 | 117.2 | 4.61 |
| show fields | 52,254 | 88.7 | 3.48 |
| set option | 51,833 | 88 | 3.46 |
| show variables | 45,723 | 77.6 | 3.05 |
| stmt prepare | 2,280 | 3.9 | 0.15 |
| show grants | 1,911 | 3.2 | 0.13 |
| show binlogs | 1,675 | 2.8 | 0.11 |
| stmt close | 1,245 | 2.1 | 0.08 |
| stmt execute | 1,245 | 2.1 | 0.08 |
| show keys | 399 | 0.7 | 0.03 |
| show slave status | 383 | 0.6 | 0.03 |
| show master status | 380 | 0.6 | 0.03 |
| show warnings | 107 | 0.2 | 0.01 |
| show create table | 87 | 0.1 | 0.01 |
| replace | 47 | 0.1 | <0.01 |
| show table status | 30 | 0.1 | <0.01 |
| show storage engines | 10 | <0.1 | <0.01 |
| show status | 5 | <0.1 | <0.01 |
| update | 2 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
| show processlist | 1 | <0.1 | <0.01 |