控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 31,027 k | 176.9 k | 70.36 |
| change db | 9,292 k | 53 k | 21.07 |
| set option | 1,036 k | 5,905.1 | 2.35 |
| show fields | 703 k | 4,010.4 | 1.60 |
| show tables | 474 k | 2,702 | 1.07 |
| insert | 429 k | 2,444.3 | 0.97 |
| show create table | 258 k | 1,469.7 | 0.58 |
| show variables | 157 k | 896.5 | 0.36 |
| show table status | 143 k | 815.3 | 0.32 |
| show triggers | 142 k | 812.4 | 0.32 |
| show keys | 142 k | 810.9 | 0.32 |
| show warnings | 76,884 | 438.4 | 0.17 |
| delete | 71,724 | 409 | 0.16 |
| replace | 63,867 | 364.2 | 0.14 |
| update | 51,342 | 292.7 | 0.12 |
| commit | 19,991 | 114 | 0.05 |
| show storage engines | 2,226 | 12.7 | 0.01 |
| stmt prepare | 1,373 | 7.8 | <0.01 |
| stmt execute | 1,373 | 7.8 | <0.01 |
| stmt close | 1,283 | 7.3 | <0.01 |
| show grants | 755 | 4.3 | <0.01 |
| create table | 713 | 4.1 | <0.01 |
| truncate | 221 | 1.3 | <0.01 |
| show binlogs | 177 | 1 | <0.01 |
| show collations | 105 | 0.6 | <0.01 |
| rollback | 101 | 0.6 | <0.01 |
| stmt reprepare | 90 | 0.5 | <0.01 |
| show slave status | 70 | 0.4 | <0.01 |
| show master status | 67 | 0.4 | <0.01 |
| show status | 23 | 0.1 | <0.01 |
| show databases | 10 | 0.1 | <0.01 |
| show processlist | 3 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |