控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| stmt execute | 10,815 k | 470.3 k | 21.50 |
| select | 9,404 k | 409 k | 18.70 |
| stmt close | 7,117 k | 309.5 k | 14.15 |
| stmt prepare | 7,117 k | 309.5 k | 14.15 |
| begin | 6,869 k | 298.8 k | 13.66 |
| commit | 6,869 k | 298.7 k | 13.66 |
| update | 1,850 k | 80.5 k | 3.68 |
| insert | 77,311 | 3,362.2 | 0.15 |
| show tables | 36,617 | 1,592.5 | 0.07 |
| show fields | 34,058 | 1,481.2 | 0.07 |
| create table | 27,674 | 1,203.5 | 0.06 |
| change db | 26,533 | 1,153.9 | 0.05 |
| set option | 23,545 | 1,024 | 0.05 |
| show keys | 9,917 | 431.3 | 0.02 |
| replace | 4,470 | 194.4 | 0.01 |
| show variables | 4,115 | 179 | 0.01 |
| show create table | 4,001 | 174 | 0.01 |
| delete | 1,407 | 61.2 | <0.01 |
| insert select | 1,380 | 60 | <0.01 |
| show warnings | 789 | 34.3 | <0.01 |
| show storage engines | 732 | 31.8 | <0.01 |
| show grants | 466 | 20.3 | <0.01 |
| rollback to savepoint | 377 | 16.4 | <0.01 |
| show table status | 235 | 10.2 | <0.01 |
| show binlogs | 142 | 6.2 | <0.01 |
| rollback | 136 | 5.9 | <0.01 |
| show slave status | 80 | 3.5 | <0.01 |
| show master status | 76 | 3.3 | <0.01 |
| show status | 18 | 0.8 | <0.01 |
| show events | 15 | 0.7 | <0.01 |
| show function status | 15 | 0.7 | <0.01 |
| show package status | 15 | 0.7 | <0.01 |
| show package body status | 15 | 0.7 | <0.01 |
| show procedure status | 15 | 0.7 | <0.01 |
| show create db | 12 | 0.5 | <0.01 |
| release savepoint | 5 | 0.2 | <0.01 |
| savepoint | 5 | 0.2 | <0.01 |
| unlock tables | 5 | 0.2 | <0.01 |
| flush | 3 | 0.1 | <0.01 |
| show engine status | 3 | 0.1 | <0.01 |
| show create trigger | 2 | 0.1 | <0.01 |
| show databases | 2 | 0.1 | <0.01 |
| show processlist | 2 | 0.1 | <0.01 |