控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 30,427 k | 174.9 k | 70.33 |
| change db | 9,182 k | 52.8 k | 21.22 |
| set option | 1,018 k | 5,848.7 | 2.35 |
| show fields | 668 k | 3,841.5 | 1.55 |
| show tables | 451 k | 2,590.2 | 1.04 |
| insert | 424 k | 2,437.8 | 0.98 |
| show create table | 250 k | 1,435.5 | 0.58 |
| show variables | 155 k | 889.9 | 0.36 |
| show table status | 142 k | 813.3 | 0.33 |
| show triggers | 141 k | 811.9 | 0.33 |
| show keys | 120 k | 691.4 | 0.28 |
| show warnings | 76,430 | 439.2 | 0.18 |
| delete | 71,216 | 409.3 | 0.16 |
| replace | 60,313 | 346.6 | 0.14 |
| update | 50,800 | 291.9 | 0.12 |
| commit | 19,809 | 113.8 | 0.05 |
| show storage engines | 1,466 | 8.4 | <0.01 |
| stmt prepare | 1,301 | 7.5 | <0.01 |
| stmt execute | 1,301 | 7.5 | <0.01 |
| stmt close | 1,265 | 7.3 | <0.01 |
| create table | 706 | 4.1 | <0.01 |
| truncate | 217 | 1.2 | <0.01 |
| show grants | 177 | 1 | <0.01 |
| show collations | 104 | 0.6 | <0.01 |
| show binlogs | 102 | 0.6 | <0.01 |
| rollback | 101 | 0.6 | <0.01 |
| show slave status | 51 | 0.3 | <0.01 |
| show master status | 48 | 0.3 | <0.01 |
| stmt reprepare | 36 | 0.2 | <0.01 |
| show databases | 10 | 0.1 | <0.01 |
| show status | 8 | <0.1 | <0.01 |
| show processlist | 1 | <0.1 | <0.01 |