控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 1,281 k | 87.8 k | 77.61 |
| show tables | 86,895 | 5,959.2 | 5.27 |
| show fields | 78,289 | 5,369 | 4.74 |
| change db | 63,863 | 4,379.7 | 3.87 |
| set option | 45,357 | 3,110.5 | 2.75 |
| show keys | 29,981 | 2,056.1 | 1.82 |
| stmt close | 10,606 | 727.4 | 0.64 |
| stmt execute | 10,606 | 727.4 | 0.64 |
| stmt prepare | 10,606 | 727.4 | 0.64 |
| show create table | 9,327 | 639.6 | 0.57 |
| show variables | 8,027 | 550.5 | 0.49 |
| replace | 5,855 | 401.5 | 0.35 |
| show grants | 2,968 | 203.5 | 0.18 |
| show warnings | 2,541 | 174.3 | 0.15 |
| show storage engines | 2,281 | 156.4 | 0.14 |
| show slave status | 601 | 41.2 | 0.04 |
| show master status | 586 | 40.2 | 0.04 |
| show table status | 343 | 23.5 | 0.02 |
| show binlogs | 341 | 23.4 | 0.02 |
| update | 198 | 13.6 | 0.01 |
| insert | 155 | 10.6 | 0.01 |
| show status | 43 | 2.9 | <0.01 |
| delete | 37 | 2.5 | <0.01 |
| show create proc | 24 | 1.6 | <0.01 |
| flush | 5 | 0.3 | <0.01 |
| show create func | 5 | 0.3 | <0.01 |
| show processlist | 5 | 0.3 | <0.01 |
| alter table | 2 | 0.1 | <0.01 |