| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 1,501 k | 1,444.1 | 77.83 |
| show tables | 103 k | 98.7 | 5.32 |
| show fields | 93,880 | 90.3 | 4.87 |
| change db | 72,705 | 70 | 3.77 |
| set option | 55,413 | 53.3 | 2.87 |
| show keys | 46,525 | 44.8 | 2.41 |
| show variables | 16,055 | 15.4 | 0.83 |
| replace | 13,686 | 13.2 | 0.71 |
| show create table | 10,203 | 9.8 | 0.53 |
| show warnings | 6,484 | 6.2 | 0.34 |
| show grants | 4,179 | 4 | 0.22 |
| show storage engines | 1,975 | 1.9 | 0.10 |
| show binlogs | 859 | 0.8 | 0.04 |
| stmt close | 569 | 0.5 | 0.03 |
| stmt execute | 569 | 0.5 | 0.03 |
| stmt prepare | 569 | 0.5 | 0.03 |
| update | 451 | 0.4 | 0.02 |
| show slave status | 289 | 0.3 | 0.01 |
| show master status | 276 | 0.3 | 0.01 |
| show table status | 175 | 0.2 | 0.01 |
| show status | 56 | 0.1 | <0.01 |
| show processlist | 8 | <0.1 | <0.01 |
| flush | 5 | <0.1 | <0.01 |
| show engine status | 4 | <0.1 | <0.01 |
| insert | 1 | <0.1 | <0.01 |