| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 92,326 | 6,288.9 | 78.67 |
| show tables | 6,012 | 409.5 | 5.12 |
| show fields | 5,130 | 349.4 | 4.37 |
| change db | 4,956 | 337.6 | 4.22 |
| set option | 4,368 | 297.5 | 3.72 |
| show keys | 1,977 | 134.7 | 1.68 |
| show variables | 892 | 60.8 | 0.76 |
| show grants | 402 | 27.4 | 0.34 |
| show create table | 390 | 26.6 | 0.33 |
| show binlogs | 311 | 21.2 | 0.26 |
| replace | 172 | 11.7 | 0.15 |
| show storage engines | 88 | 6 | 0.07 |
| show slave status | 44 | 3 | 0.04 |
| stmt close | 44 | 3 | 0.04 |
| stmt execute | 44 | 3 | 0.04 |
| stmt prepare | 44 | 3 | 0.04 |
| show master status | 40 | 2.7 | 0.03 |
| show table status | 28 | 1.9 | 0.02 |
| show warnings | 25 | 1.7 | 0.02 |
| show status | 20 | 1.4 | 0.02 |
| update | 20 | 1.4 | 0.02 |
| insert | 17 | 1.2 | 0.01 |
| insert select | 7 | 0.5 | 0.01 |
| delete | 5 | 0.3 | <0.01 |
| show processlist | 2 | 0.1 | <0.01 |
| flush | 1 | 0.1 | <0.01 |
| show engine status | 1 | 0.1 | <0.01 |