| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 892 k | 1,290.6 | 77.58 |
| show tables | 59,129 | 85.5 | 5.14 |
| show fields | 55,661 | 80.5 | 4.84 |
| change db | 41,198 | 59.6 | 3.58 |
| show keys | 33,541 | 48.5 | 2.92 |
| set option | 30,690 | 44.4 | 2.67 |
| show grants | 8,784 | 12.7 | 0.76 |
| show create table | 8,080 | 11.7 | 0.70 |
| show variables | 6,575 | 9.5 | 0.57 |
| replace | 5,867 | 8.5 | 0.51 |
| show binlogs | 2,447 | 3.5 | 0.21 |
| show warnings | 1,416 | 2 | 0.12 |
| stmt prepare | 1,174 | 1.7 | 0.10 |
| show storage engines | 1,130 | 1.6 | 0.10 |
| stmt close | 694 | 1 | 0.06 |
| stmt execute | 694 | 1 | 0.06 |
| show slave status | 309 | 0.4 | 0.03 |
| show master status | 300 | 0.4 | 0.03 |
| show table status | 129 | 0.2 | 0.01 |
| show status | 42 | 0.1 | <0.01 |
| update | 42 | 0.1 | <0.01 |
| show processlist | 6 | <0.1 | <0.01 |
| show engine status | 3 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |