控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 28,779 k | 4,628.9 | 77.66 |
| show tables | 2,014 k | 324 | 5.44 |
| change db | 1,596 k | 256.8 | 4.31 |
| show fields | 1,386 k | 222.9 | 3.74 |
| show variables | 1,374 k | 221 | 3.71 |
| set option | 1,196 k | 192.3 | 3.23 |
| show warnings | 365 k | 58.7 | 0.99 |
| show keys | 157 k | 25.3 | 0.42 |
| show grants | 76,313 | 12.3 | 0.21 |
| show create table | 59,539 | 9.6 | 0.16 |
| replace | 30,546 | 4.9 | 0.08 |
| show binlogs | 9,495 | 1.5 | 0.03 |
| show storage engines | 3,568 | 0.6 | 0.01 |
| stmt prepare | 2,643 | 0.4 | 0.01 |
| show slave status | 1,578 | 0.3 | <0.01 |
| stmt close | 1,568 | 0.3 | <0.01 |
| stmt execute | 1,568 | 0.3 | <0.01 |
| show master status | 1,503 | 0.2 | <0.01 |
| show table status | 765 | 0.1 | <0.01 |
| update | 387 | 0.1 | <0.01 |
| show status | 352 | 0.1 | <0.01 |
| flush | 41 | <0.1 | <0.01 |
| show processlist | 38 | <0.1 | <0.01 |
| insert | 25 | <0.1 | <0.01 |
| alter table | 24 | <0.1 | <0.01 |
| create db | 24 | <0.1 | <0.01 |
| create table | 24 | <0.1 | <0.01 |
| delete | 24 | <0.1 | <0.01 |
| drop db | 24 | <0.1 | <0.01 |
| show engine status | 24 | <0.1 | <0.01 |
| show databases | 19 | <0.1 | <0.01 |
| reset | 18 | <0.1 | <0.01 |
| grant | 9 | <0.1 | <0.01 |
| truncate | 9 | <0.1 | <0.01 |