| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 61,666 | 388.8 k | 19.29 |
| stmt close | 51,516 | 324.8 k | 16.12 |
| stmt prepare | 51,516 | 324.8 k | 16.12 |
| stmt execute | 51,506 | 324.7 k | 16.11 |
| begin | 49,786 | 313.9 k | 15.58 |
| commit | 49,786 | 313.9 k | 15.58 |
| show tables | 880 | 5,548.2 | 0.28 |
| show fields | 658 | 4,148.5 | 0.21 |
| change db | 531 | 3,347.8 | 0.17 |
| insert | 421 | 2,654.3 | 0.13 |
| set option | 407 | 2,566 | 0.13 |
| update | 218 | 1,374.4 | 0.07 |
| create table | 201 | 1,267.3 | 0.06 |
| show keys | 162 | 1,021.4 | 0.05 |
| replace | 122 | 769.2 | 0.04 |
| show variables | 83 | 523.3 | 0.03 |
| show grants | 68 | 428.7 | 0.02 |
| show create table | 41 | 258.5 | 0.01 |
| show warnings | 18 | 113.5 | 0.01 |
| delete | 10 | 63 | <0.01 |
| insert select | 10 | 63 | <0.01 |
| show storage engines | 8 | 50.4 | <0.01 |
| show table status | 8 | 50.4 | <0.01 |
| show binlogs | 6 | 37.8 | <0.01 |
| show status | 6 | 37.8 | <0.01 |
| show master status | 5 | 31.5 | <0.01 |
| show slave status | 5 | 31.5 | <0.01 |
| show processlist | 1 | 6.3 | <0.01 |