| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 1,367 k | 839.7 | 78.67 |
| show tables | 99,044 | 60.8 | 5.70 |
| show fields | 80,287 | 49.3 | 4.62 |
| change db | 67,044 | 41.2 | 3.86 |
| set option | 49,900 | 30.7 | 2.87 |
| show keys | 25,261 | 15.5 | 1.45 |
| replace | 12,181 | 7.5 | 0.70 |
| show variables | 9,497 | 5.8 | 0.55 |
| show grants | 9,242 | 5.7 | 0.53 |
| show create table | 7,699 | 4.7 | 0.44 |
| show warnings | 2,593 | 1.6 | 0.15 |
| show storage engines | 2,436 | 1.5 | 0.14 |
| stmt prepare | 1,207 | 0.7 | 0.07 |
| stmt close | 847 | 0.5 | 0.05 |
| stmt execute | 847 | 0.5 | 0.05 |
| show binlogs | 772 | 0.5 | 0.04 |
| insert | 693 | 0.4 | 0.04 |
| show slave status | 363 | 0.2 | 0.02 |
| show table status | 362 | 0.2 | 0.02 |
| show master status | 348 | 0.2 | 0.02 |
| show status | 90 | 0.1 | 0.01 |
| show processlist | 14 | <0.1 | <0.01 |
| show engine status | 10 | <0.1 | <0.01 |
| flush | 7 | <0.1 | <0.01 |
| create table | 1 | <0.1 | <0.01 |