| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 3,009 k | 1,414 | 77.60 |
| show tables | 204 k | 95.6 | 5.25 |
| show fields | 192 k | 90.3 | 4.96 |
| change db | 145 k | 67.9 | 3.73 |
| set option | 109 k | 51.3 | 2.81 |
| show keys | 101 k | 47.3 | 2.59 |
| show variables | 35,135 | 16.5 | 0.91 |
| replace | 28,876 | 13.6 | 0.74 |
| show create table | 21,630 | 10.2 | 0.56 |
| show warnings | 14,487 | 6.8 | 0.37 |
| show grants | 8,132 | 3.8 | 0.21 |
| show storage engines | 3,697 | 1.7 | 0.10 |
| show binlogs | 1,474 | 0.7 | 0.04 |
| stmt close | 1,063 | 0.5 | 0.03 |
| stmt execute | 1,063 | 0.5 | 0.03 |
| stmt prepare | 1,063 | 0.5 | 0.03 |
| update | 573 | 0.3 | 0.01 |
| show slave status | 543 | 0.3 | 0.01 |
| show master status | 520 | 0.2 | 0.01 |
| show table status | 380 | 0.2 | 0.01 |
| show status | 127 | 0.1 | <0.01 |
| show processlist | 17 | <0.1 | <0.01 |
| show engine status | 12 | <0.1 | <0.01 |
| flush | 9 | <0.1 | <0.01 |
| insert | 1 | <0.1 | <0.01 |