| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 20,957 k | 4,561 | 77.28 |
| show fields | 1,450 k | 315.5 | 5.35 |
| show tables | 1,193 k | 259.6 | 4.40 |
| show keys | 918 k | 199.8 | 3.39 |
| change db | 914 k | 199 | 3.37 |
| set option | 686 k | 149.2 | 2.53 |
| show variables | 369 k | 80.2 | 1.36 |
| show create table | 192 k | 41.7 | 0.71 |
| show warnings | 176 k | 38.4 | 0.65 |
| show grants | 166 k | 36.1 | 0.61 |
| replace | 65,450 | 14.2 | 0.24 |
| show storage engines | 8,999 | 2 | 0.03 |
| show binlogs | 5,800 | 1.3 | 0.02 |
| stmt close | 3,992 | 0.9 | 0.01 |
| stmt execute | 3,992 | 0.9 | 0.01 |
| stmt prepare | 3,992 | 0.9 | 0.01 |
| show slave status | 1,696 | 0.4 | 0.01 |
| show master status | 1,487 | 0.3 | 0.01 |
| show table status | 1,178 | 0.3 | <0.01 |
| update | 1,040 | 0.2 | <0.01 |
| show status | 326 | 0.1 | <0.01 |
| show processlist | 31 | <0.1 | <0.01 |
| flush | 29 | <0.1 | <0.01 |
| show engine status | 23 | <0.1 | <0.01 |
| insert | 1 | <0.1 | <0.01 |