控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 14,533 k | 116.9 k | 80.13 |
| show tables | 822 k | 6,612.3 | 4.53 |
| show fields | 640 k | 5,147.1 | 3.53 |
| change db | 551 k | 4,434.6 | 3.04 |
| set option | 461 k | 3,707 | 2.54 |
| stmt prepare | 233 k | 1,871.3 | 1.28 |
| stmt close | 233 k | 1,871.1 | 1.28 |
| stmt execute | 233 k | 1,871 | 1.28 |
| show keys | 142 k | 1,145.1 | 0.79 |
| show create table | 53,048 | 426.7 | 0.29 |
| show variables | 49,694 | 399.7 | 0.27 |
| replace | 46,400 | 373.2 | 0.26 |
| insert | 38,003 | 305.7 | 0.21 |
| show grants | 35,636 | 286.6 | 0.20 |
| show warnings | 16,631 | 133.8 | 0.09 |
| show storage engines | 15,505 | 124.7 | 0.09 |
| update | 13,756 | 110.6 | 0.08 |
| show binlogs | 11,379 | 91.5 | 0.06 |
| show table status | 3,324 | 26.7 | 0.02 |
| show slave status | 1,710 | 13.8 | 0.01 |
| insert select | 1,694 | 13.6 | 0.01 |
| show master status | 1,677 | 13.5 | 0.01 |
| rollback to savepoint | 338 | 2.7 | <0.01 |
| delete | 250 | 2 | <0.01 |
| show status | 149 | 1.2 | <0.01 |
| show create proc | 87 | 0.7 | <0.01 |
| alter table | 39 | 0.3 | <0.01 |
| commit | 34 | 0.3 | <0.01 |
| show create func | 22 | 0.2 | <0.01 |
| show processlist | 18 | 0.1 | <0.01 |
| create table | 13 | 0.1 | <0.01 |
| flush | 11 | 0.1 | <0.01 |
| unlock tables | 9 | 0.1 | <0.01 |
| drop table | 8 | 0.1 | <0.01 |
| lock tables | 6 | <0.1 | <0.01 |
| show create trigger | 6 | <0.1 | <0.01 |
| show engine status | 4 | <0.1 | <0.01 |
| begin | 3 | <0.1 | <0.01 |
| savepoint | 3 | <0.1 | <0.01 |
| release savepoint | 2 | <0.1 | <0.01 |
| show events | 2 | <0.1 | <0.01 |
| show function status | 2 | <0.1 | <0.01 |
| show package status | 2 | <0.1 | <0.01 |
| show package body status | 2 | <0.1 | <0.01 |
| show procedure status | 2 | <0.1 | <0.01 |
| show databases | 1 | <0.1 | <0.01 |