| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| Select | 12,160 k | 1,032 k | 82.51 |
| Show Keys | 489 k | 41.5 k | 3.31 |
| Set Option | 422 k | 35.8 k | 2.86 |
| Show Fields | 397 k | 33.7 k | 2.69 |
| Show Tables | 295 k | 25 k | 2.00 |
| Change Db | 278 k | 23.6 k | 1.89 |
| Show Variables | 249 k | 21.1 k | 1.69 |
| Show Grants | 133 k | 11.3 k | 0.90 |
| Show Create Table | 125 k | 10.6 k | 0.85 |
| Show Warnings | 122 k | 10.4 k | 0.83 |
| Replace | 53,626 | 4,551 | 0.36 |
| Show Binlogs | 3,769 | 319.9 | 0.03 |
| Update | 3,101 | 263.2 | 0.02 |
| Show Table Status | 2,242 | 190.3 | 0.02 |
| Show Storage Engines | 1,325 | 112.4 | 0.01 |
| Show Master Status | 663 | 56.3 | <0.01 |
| Show Slave Status | 663 | 56.3 | <0.01 |
| Stmt Prepare | 635 | 53.9 | <0.01 |
| Stmt Close | 509 | 43.2 | <0.01 |
| Stmt Execute | 509 | 43.2 | <0.01 |
| Show Status | 103 | 8.7 | <0.01 |
| Show Databases | 95 | 8.1 | <0.01 |
| Insert | 86 | 7.3 | <0.01 |
| Create Db | 45 | 3.8 | <0.01 |
| Create Table | 23 | 2 | <0.01 |
| Alter Table | 16 | 1.4 | <0.01 |
| Delete | 9 | 0.8 | <0.01 |
| Flush | 7 | 0.6 | <0.01 |
| Show Processlist | 6 | 0.5 | <0.01 |
| Drop Db | 3 | 0.3 | <0.01 |
| Drop Table | 3 | 0.3 | <0.01 |
| Alter Db | 1 | 0.1 | <0.01 |
| Empty Query | 1 | 0.1 | <0.01 |
| Show Engine Status | 1 | 0.1 | <0.01 |
| Truncate | 1 | 0.1 | <0.01 |