| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 1,063 k | 1,213.6 | 77.38 |
| show tables | 71,171 | 81.3 | 5.18 |
| show fields | 67,265 | 76.8 | 4.90 |
| change db | 49,660 | 56.7 | 3.62 |
| show keys | 41,185 | 47 | 3.00 |
| set option | 36,600 | 41.8 | 2.67 |
| show grants | 9,776 | 11.2 | 0.71 |
| show create table | 9,710 | 11.1 | 0.71 |
| show variables | 8,044 | 9.2 | 0.59 |
| replace | 7,338 | 8.4 | 0.53 |
| show binlogs | 2,756 | 3.1 | 0.20 |
| show warnings | 1,786 | 2 | 0.13 |
| show storage engines | 1,393 | 1.6 | 0.10 |
| stmt prepare | 1,317 | 1.5 | 0.10 |
| stmt close | 772 | 0.9 | 0.06 |
| stmt execute | 772 | 0.9 | 0.06 |
| show slave status | 374 | 0.4 | 0.03 |
| show master status | 362 | 0.4 | 0.03 |
| show table status | 160 | 0.2 | 0.01 |
| show status | 55 | 0.1 | <0.01 |
| update | 42 | <0.1 | <0.01 |
| show processlist | 7 | <0.1 | <0.01 |
| show engine status | 6 | <0.1 | <0.01 |
| flush | 3 | <0.1 | <0.01 |