| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| Select | 10,323 k | 454.9 k | 79.78 |
| Set Option | 460 k | 20.3 k | 3.56 |
| Show Keys | 456 k | 20.1 k | 3.52 |
| Show Fields | 395 k | 17.4 k | 3.05 |
| Show Tables | 326 k | 14.4 k | 2.52 |
| Change Db | 291 k | 12.8 k | 2.25 |
| Show Variables | 235 k | 10.4 k | 1.82 |
| Show Grants | 134 k | 5,922.9 | 1.04 |
| Show Create Table | 116 k | 5,129.9 | 0.90 |
| Show Warnings | 115 k | 5,070.8 | 0.89 |
| Replace | 54,597 | 2,406.2 | 0.42 |
| Show Table Status | 10,489 | 462.3 | 0.08 |
| Show Binlogs | 10,371 | 457.1 | 0.08 |
| Update | 6,814 | 300.3 | 0.05 |
| Stmt Prepare | 1,131 | 49.8 | 0.01 |
| Stmt Close | 935 | 41.2 | 0.01 |
| Stmt Execute | 935 | 41.2 | 0.01 |
| Show Storage Engines | 553 | 24.4 | <0.01 |
| Show Master Status | 416 | 18.3 | <0.01 |
| Show Slave Status | 416 | 18.3 | <0.01 |
| Show Databases | 180 | 7.9 | <0.01 |
| Show Status | 165 | 7.3 | <0.01 |
| Delete | 36 | 1.6 | <0.01 |
| Create Db | 29 | 1.3 | <0.01 |
| Create Table | 28 | 1.2 | <0.01 |
| Insert | 18 | 0.8 | <0.01 |
| Alter Table | 8 | 0.4 | <0.01 |
| Show Profile | 7 | 0.3 | <0.01 |
| Begin | 4 | 0.2 | <0.01 |
| Commit | 4 | 0.2 | <0.01 |
| Show Processlist | 4 | 0.2 | <0.01 |
| Drop Table | 3 | 0.1 | <0.01 |
| Show Engine Status | 3 | 0.1 | <0.01 |
| Drop Db | 1 | <0.1 | <0.01 |