| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 17,798 k | 21.1 k | 78.75 |
| show fields | 1,236 k | 1,466.2 | 5.47 |
| show tables | 921 k | 1,091.7 | 4.07 |
| change db | 726 k | 860.7 | 3.21 |
| set option | 551 k | 653.2 | 2.44 |
| show keys | 409 k | 485.6 | 1.81 |
| show variables | 343 k | 406.7 | 1.52 |
| show grants | 174 k | 205.8 | 0.77 |
| show create table | 171 k | 203 | 0.76 |
| show warnings | 170 k | 202.2 | 0.75 |
| replace | 91,624 | 108.7 | 0.41 |
| show binlogs | 2,650 | 3.1 | 0.01 |
| update | 1,238 | 1.5 | 0.01 |
| stmt close | 985 | 1.2 | <0.01 |
| stmt execute | 985 | 1.2 | <0.01 |
| stmt prepare | 985 | 1.2 | <0.01 |
| show storage engines | 465 | 0.6 | <0.01 |
| show slave status | 455 | 0.5 | <0.01 |
| show master status | 355 | 0.4 | <0.01 |
| show status | 95 | 0.1 | <0.01 |
| show table status | 69 | 0.1 | <0.01 |
| flush | 4 | <0.1 | <0.01 |
| show processlist | 4 | <0.1 | <0.01 |