| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 9,263 k | 69.9 k | 80.05 |
| show fields | 527 k | 3,976.4 | 4.56 |
| show tables | 463 k | 3,489.9 | 4.00 |
| change db | 364 k | 2,748 | 3.15 |
| set option | 309 k | 2,329.7 | 2.67 |
| show keys | 276 k | 2,085 | 2.39 |
| show variables | 136 k | 1,028 | 1.18 |
| replace | 75,413 | 568.9 | 0.65 |
| show create table | 72,778 | 549.1 | 0.63 |
| show warnings | 65,478 | 494 | 0.57 |
| show grants | 7,322 | 55.2 | 0.06 |
| update | 3,352 | 25.3 | 0.03 |
| show storage engines | 3,255 | 24.6 | 0.03 |
| stmt close | 733 | 5.5 | 0.01 |
| stmt execute | 733 | 5.5 | 0.01 |
| stmt prepare | 733 | 5.5 | 0.01 |
| show binlogs | 541 | 4.1 | <0.01 |
| insert | 533 | 4 | <0.01 |
| delete | 530 | 4 | <0.01 |
| show table status | 453 | 3.4 | <0.01 |
| show slave status | 339 | 2.6 | <0.01 |
| show master status | 320 | 2.4 | <0.01 |
| show status | 82 | 0.6 | <0.01 |
| show processlist | 9 | 0.1 | <0.01 |
| flush | 5 | <0.1 | <0.01 |
| show engine status | 5 | <0.1 | <0.01 |