控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 11,797 k | 66.3 k | 74.95 |
| show fields | 1,012 k | 5,688.5 | 6.43 |
| set option | 943 k | 5,300.1 | 5.99 |
| show variables | 503 k | 2,825.4 | 3.19 |
| change db | 352 k | 1,977.1 | 2.24 |
| show create table | 288 k | 1,617.2 | 1.83 |
| show keys | 283 k | 1,592.2 | 1.80 |
| show warnings | 250 k | 1,403.3 | 1.59 |
| show tables | 69,746 | 391.9 | 0.44 |
| replace | 63,506 | 356.8 | 0.40 |
| show grants | 58,625 | 329.4 | 0.37 |
| insert | 32,720 | 183.8 | 0.21 |
| show table status | 31,502 | 177 | 0.20 |
| show triggers | 30,822 | 173.2 | 0.20 |
| delete | 14,297 | 80.3 | 0.09 |
| update | 4,087 | 23 | 0.03 |
| commit | 3,074 | 17.3 | 0.02 |
| show storage engines | 1,620 | 9.1 | 0.01 |
| show binlogs | 1,150 | 6.5 | 0.01 |
| stmt close | 250 | 1.4 | <0.01 |
| stmt execute | 250 | 1.4 | <0.01 |
| stmt prepare | 250 | 1.4 | <0.01 |
| create table | 208 | 1.2 | <0.01 |
| show slave status | 83 | 0.5 | <0.01 |
| rollback | 82 | 0.5 | <0.01 |
| show master status | 78 | 0.4 | <0.01 |
| show collations | 22 | 0.1 | <0.01 |
| show status | 20 | 0.1 | <0.01 |
| show processlist | 3 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |