| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 91,420 | 7,951.7 | 77.94 |
| show tables | 6,134 | 533.5 | 5.23 |
| show fields | 6,038 | 525.2 | 5.15 |
| change db | 5,227 | 454.6 | 4.46 |
| set option | 3,358 | 292.1 | 2.86 |
| show keys | 2,508 | 218.1 | 2.14 |
| show create table | 746 | 64.9 | 0.64 |
| show variables | 631 | 54.9 | 0.54 |
| replace | 582 | 50.6 | 0.50 |
| show storage engines | 213 | 18.5 | 0.18 |
| show grants | 115 | 10 | 0.10 |
| stmt prepare | 78 | 6.8 | 0.07 |
| show binlogs | 61 | 5.3 | 0.05 |
| stmt close | 42 | 3.7 | 0.04 |
| stmt execute | 42 | 3.7 | 0.04 |
| show slave status | 34 | 3 | 0.03 |
| show master status | 31 | 2.7 | 0.03 |
| show table status | 18 | 1.6 | 0.02 |
| show status | 6 | 0.5 | 0.01 |
| show warnings | 4 | 0.3 | <0.01 |
| flush | 1 | 0.1 | <0.01 |
| show databases | 1 | 0.1 | <0.01 |
| show processlist | 1 | 0.1 | <0.01 |