| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 300 k | 24 k | 78.08 |
| show tables | 21,830 | 1,745.6 | 5.69 |
| show fields | 18,879 | 1,509.6 | 4.92 |
| change db | 16,105 | 1,287.8 | 4.20 |
| set option | 11,065 | 884.8 | 2.88 |
| show keys | 6,831 | 546.2 | 1.78 |
| show variables | 2,671 | 213.6 | 0.70 |
| replace | 2,656 | 212.4 | 0.69 |
| show create table | 1,787 | 142.9 | 0.47 |
| show grants | 578 | 46.2 | 0.15 |
| show storage engines | 499 | 39.9 | 0.13 |
| show warnings | 421 | 33.7 | 0.11 |
| show table status | 215 | 17.2 | 0.06 |
| show binlogs | 200 | 16 | 0.05 |
| stmt prepare | 130 | 10.4 | 0.03 |
| stmt close | 70 | 5.6 | 0.02 |
| stmt execute | 70 | 5.6 | 0.02 |
| show slave status | 42 | 3.4 | 0.01 |
| show master status | 39 | 3.1 | 0.01 |
| show status | 13 | 1 | <0.01 |
| show processlist | 2 | 0.2 | <0.01 |
| flush | 1 | 0.1 | <0.01 |
| show databases | 1 | 0.1 | <0.01 |