| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 70,068 | 5,153.7 | 80.00 |
| show tables | 4,393 | 323.1 | 5.02 |
| change db | 3,824 | 281.3 | 4.37 |
| set option | 3,606 | 265.2 | 4.12 |
| show fields | 3,208 | 236 | 3.66 |
| show keys | 796 | 58.5 | 0.91 |
| show variables | 731 | 53.8 | 0.83 |
| show grants | 331 | 24.3 | 0.38 |
| show binlogs | 283 | 20.8 | 0.32 |
| replace | 62 | 4.6 | 0.07 |
| show create table | 50 | 3.7 | 0.06 |
| show storage engines | 35 | 2.6 | 0.04 |
| show slave status | 30 | 2.2 | 0.03 |
| show master status | 27 | 2 | 0.03 |
| stmt close | 22 | 1.6 | 0.03 |
| stmt execute | 22 | 1.6 | 0.03 |
| stmt prepare | 22 | 1.6 | 0.03 |
| update | 20 | 1.5 | 0.02 |
| insert | 17 | 1.3 | 0.02 |
| show table status | 13 | 1 | 0.01 |
| show status | 9 | 0.7 | 0.01 |
| insert select | 7 | 0.5 | 0.01 |
| delete | 5 | 0.4 | 0.01 |
| show processlist | 1 | 0.1 | <0.01 |