控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 229 k | 683.6 | 49.63 |
| set option | 52,170 | 155.9 | 11.32 |
| change db | 32,971 | 98.5 | 7.15 |
| show fields | 28,010 | 83.7 | 6.08 |
| stmt execute | 20,458 | 61.1 | 4.44 |
| stmt prepare | 20,454 | 61.1 | 4.44 |
| stmt close | 20,453 | 61.1 | 4.44 |
| show tables | 15,098 | 45.1 | 3.28 |
| show table status | 12,357 | 36.9 | 2.68 |
| show variables | 8,504 | 25.4 | 1.84 |
| show grants | 8,381 | 25 | 1.82 |
| show keys | 7,177 | 21.4 | 1.56 |
| show create table | 2,376 | 7.1 | 0.52 |
| replace | 2,177 | 6.5 | 0.47 |
| show binlogs | 503 | 1.5 | 0.11 |
| show slave status | 216 | 0.6 | 0.05 |
| show master status | 212 | 0.6 | 0.05 |
| show plugins | 128 | 0.4 | 0.03 |
| show status | 113 | 0.3 | 0.02 |
| delete | 104 | 0.3 | 0.02 |
| update | 82 | 0.2 | 0.02 |
| show storage engines | 61 | 0.2 | 0.01 |
| begin | 37 | 0.1 | 0.01 |
| commit | 37 | 0.1 | 0.01 |
| insert | 27 | 0.1 | 0.01 |
| insert select | 20 | 0.1 | <0.01 |
| kill | 18 | 0.1 | <0.01 |
| alter table | 8 | <0.1 | <0.01 |
| show warnings | 7 | <0.1 | <0.01 |
| flush | 5 | <0.1 | <0.01 |
| create db | 4 | <0.1 | <0.01 |
| create table | 4 | <0.1 | <0.01 |
| drop db | 4 | <0.1 | <0.01 |
| show processlist | 4 | <0.1 | <0.01 |
| show databases | 3 | <0.1 | <0.01 |
| truncate | 3 | <0.1 | <0.01 |
| drop table | 2 | <0.1 | <0.01 |
| checksum | 2 | <0.1 | <0.01 |
| optimize | 2 | <0.1 | <0.01 |
| show open tables | 1 | <0.1 | <0.01 |
| check | 1 | <0.1 | <0.01 |
| analyze | 1 | <0.1 | <0.01 |
mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO) 使用配置文件中定义的控制用户连接失败。
