控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 28,754 k | 4,627.2 | 77.66 |
| show tables | 2,012 k | 323.8 | 5.43 |
| change db | 1,595 k | 256.7 | 4.31 |
| show fields | 1,385 k | 222.8 | 3.74 |
| show variables | 1,373 k | 221 | 3.71 |
| set option | 1,195 k | 192.3 | 3.23 |
| show warnings | 365 k | 58.7 | 0.99 |
| show keys | 157 k | 25.3 | 0.42 |
| show grants | 76,227 | 12.3 | 0.21 |
| show create table | 59,522 | 9.6 | 0.16 |
| replace | 30,526 | 4.9 | 0.08 |
| show binlogs | 9,454 | 1.5 | 0.03 |
| show storage engines | 3,559 | 0.6 | 0.01 |
| stmt prepare | 2,599 | 0.4 | 0.01 |
| show slave status | 1,570 | 0.3 | <0.01 |
| stmt close | 1,544 | 0.2 | <0.01 |
| stmt execute | 1,544 | 0.2 | <0.01 |
| show master status | 1,495 | 0.2 | <0.01 |
| show table status | 759 | 0.1 | <0.01 |
| update | 387 | 0.1 | <0.01 |
| show status | 345 | 0.1 | <0.01 |
| flush | 41 | <0.1 | <0.01 |
| show processlist | 37 | <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 | 22 | <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 |