控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 566 M | 373 k | 79.35 |
| show fields | 32,622 k | 21.5 k | 4.57 |
| show tables | 31,249 k | 20.6 k | 4.38 |
| change db | 23,382 k | 15.4 k | 3.28 |
| set option | 18,756 k | 12.4 k | 2.63 |
| show keys | 13,481 k | 8,878.8 | 1.89 |
| show variables | 9,271 k | 6,106.1 | 1.30 |
| show grants | 4,633 k | 3,051 | 0.65 |
| show create table | 4,624 k | 3,045.6 | 0.65 |
| show warnings | 4,623 k | 3,044.4 | 0.65 |
| replace | 3,548 k | 2,337 | 0.50 |
| show binlogs | 1,214 k | 799.3 | 0.17 |
| update | 13,162 | 8.7 | <0.01 |
| show storage engines | 3,084 | 2 | <0.01 |
| stmt prepare | 1,694 | 1.1 | <0.01 |
| insert | 1,571 | 1 | <0.01 |
| stmt close | 1,086 | 0.7 | <0.01 |
| stmt execute | 1,086 | 0.7 | <0.01 |
| delete | 1,028 | 0.7 | <0.01 |
| show table status | 857 | 0.6 | <0.01 |
| show slave status | 208 | 0.1 | <0.01 |
| show master status | 198 | 0.1 | <0.01 |
| show status | 29 | <0.1 | <0.01 |
| flush | 5 | <0.1 | <0.01 |
| show processlist | 3 | <0.1 | <0.01 |
| show databases | 2 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |