控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 26,507 k | 4,639.9 | 77.69 |
| show tables | 1,848 k | 323.5 | 5.42 |
| change db | 1,465 k | 256.4 | 4.29 |
| show fields | 1,281 k | 224.2 | 3.75 |
| show variables | 1,255 k | 219.7 | 3.68 |
| set option | 1,097 k | 192.1 | 3.22 |
| show warnings | 335 k | 58.7 | 0.98 |
| show keys | 150 k | 26.3 | 0.44 |
| show grants | 73,045 | 12.8 | 0.21 |
| show create table | 57,698 | 10.1 | 0.17 |
| replace | 28,626 | 5 | 0.08 |
| show binlogs | 8,559 | 1.5 | 0.03 |
| show storage engines | 3,260 | 0.6 | 0.01 |
| stmt prepare | 2,387 | 0.4 | 0.01 |
| show slave status | 1,435 | 0.3 | <0.01 |
| stmt close | 1,417 | 0.2 | <0.01 |
| stmt execute | 1,417 | 0.2 | <0.01 |
| show master status | 1,370 | 0.2 | <0.01 |
| show table status | 690 | 0.1 | <0.01 |
| update | 368 | 0.1 | <0.01 |
| show status | 297 | 0.1 | <0.01 |
| flush | 38 | <0.1 | <0.01 |
| show processlist | 34 | <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 |
| reset | 18 | <0.1 | <0.01 |
| show engine status | 18 | <0.1 | <0.01 |
| show databases | 14 | <0.1 | <0.01 |
| grant | 9 | <0.1 | <0.01 |
| truncate | 9 | <0.1 | <0.01 |