| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 4,966 k | 1,760.4 | 77.66 |
| show tables | 354 k | 125.5 | 5.54 |
| show fields | 316 k | 112.1 | 4.95 |
| change db | 243 k | 86.1 | 3.80 |
| set option | 181 k | 64.2 | 2.83 |
| show keys | 143 k | 50.8 | 2.24 |
| replace | 51,493 | 18.3 | 0.81 |
| show variables | 48,355 | 17.1 | 0.76 |
| show create table | 35,600 | 12.6 | 0.56 |
| show warnings | 18,333 | 6.5 | 0.29 |
| show grants | 16,436 | 5.8 | 0.26 |
| show storage engines | 8,367 | 3 | 0.13 |
| stmt prepare | 2,776 | 1 | 0.04 |
| stmt close | 1,966 | 0.7 | 0.03 |
| stmt execute | 1,966 | 0.7 | 0.03 |
| show binlogs | 1,307 | 0.5 | 0.02 |
| insert | 1,080 | 0.4 | 0.02 |
| show table status | 972 | 0.3 | 0.02 |
| show slave status | 912 | 0.3 | 0.01 |
| show master status | 875 | 0.3 | 0.01 |
| show status | 200 | 0.1 | <0.01 |
| show processlist | 26 | <0.1 | <0.01 |
| show engine status | 22 | <0.1 | <0.01 |
| flush | 14 | <0.1 | <0.01 |
| create table | 1 | <0.1 | <0.01 |
| update | 1 | <0.1 | <0.01 |