控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 1,990 k | 92.5 k | 79.97 |
| show fields | 106 k | 4,920 | 4.25 |
| show tables | 101 k | 4,691.5 | 4.05 |
| change db | 85,126 | 3,959.8 | 3.42 |
| set option | 84,095 | 3,911.9 | 3.38 |
| show variables | 33,521 | 1,559.3 | 1.35 |
| show keys | 21,821 | 1,015 | 0.88 |
| show grants | 17,027 | 792 | 0.68 |
| show create table | 15,428 | 717.7 | 0.62 |
| show warnings | 14,829 | 689.8 | 0.60 |
| insert | 6,216 | 289.1 | 0.25 |
| replace | 4,191 | 195 | 0.17 |
| delete | 3,115 | 144.9 | 0.13 |
| stmt prepare | 1,569 | 73 | 0.06 |
| stmt close | 1,524 | 70.9 | 0.06 |
| stmt execute | 1,524 | 70.9 | 0.06 |
| show storage engines | 741 | 34.5 | 0.03 |
| update | 497 | 23.1 | 0.02 |
| show binlogs | 303 | 14.1 | 0.01 |
| show slave status | 77 | 3.6 | <0.01 |
| show master status | 74 | 3.4 | <0.01 |
| show table status | 65 | 3 | <0.01 |
| show status | 19 | 0.9 | <0.01 |
| delete multi | 6 | 0.3 | <0.01 |
| show processlist | 2 | 0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |