| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 5,982 k | 1,257.9 | 64.19 |
| set option | 810 k | 170.4 | 8.70 |
| show fields | 664 k | 139.6 | 7.12 |
| show keys | 511 k | 107.4 | 5.48 |
| change db | 282 k | 59.2 | 3.02 |
| replace | 262 k | 55.2 | 2.82 |
| show tables | 227 k | 47.7 | 2.43 |
| show variables | 208 k | 43.8 | 2.23 |
| show create table | 180 k | 37.8 | 1.93 |
| show warnings | 77,139 | 16.2 | 0.83 |
| show storage engines | 55,260 | 11.6 | 0.59 |
| show table status | 25,844 | 5.4 | 0.28 |
| show grants | 7,087 | 1.5 | 0.08 |
| stmt close | 6,519 | 1.4 | 0.07 |
| stmt execute | 6,519 | 1.4 | 0.07 |
| stmt prepare | 6,519 | 1.4 | 0.07 |
| delete | 3,488 | 0.7 | 0.04 |
| show binlogs | 2,540 | 0.5 | 0.03 |
| show slave status | 848 | 0.2 | 0.01 |
| show master status | 813 | 0.2 | 0.01 |
| show status | 198 | <0.1 | <0.01 |
| show processlist | 26 | <0.1 | <0.01 |
| show engine status | 20 | <0.1 | <0.01 |
| insert | 14 | <0.1 | <0.01 |
| flush | 11 | <0.1 | <0.01 |
| create table | 1 | <0.1 | <0.01 |
| drop table | 1 | <0.1 | <0.01 |