| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| Select | 7,123 k | 449.3 k | 74.87 |
| Show Keys | 427 k | 26.9 k | 4.49 |
| Set Option | 425 k | 26.8 k | 4.47 |
| Show Fields | 365 k | 23 k | 3.83 |
| Show Tables | 295 k | 18.6 k | 3.10 |
| Change Db | 262 k | 16.5 k | 2.76 |
| Show Variables | 219 k | 13.8 k | 2.30 |
| Show Grants | 116 k | 7,313.2 | 1.22 |
| Show Create Table | 109 k | 6,869.8 | 1.14 |
| Show Warnings | 107 k | 6,755.2 | 1.13 |
| Replace | 41,425 | 2,613.1 | 0.44 |
| Show Binlogs | 9,908 | 625 | 0.10 |
| Update | 7,986 | 503.8 | 0.08 |
| Show Table Status | 3,538 | 223.2 | 0.04 |
| Show Storage Engines | 847 | 53.4 | 0.01 |
| Stmt Prepare | 578 | 36.5 | 0.01 |
| Stmt Close | 452 | 28.5 | <0.01 |
| Stmt Execute | 452 | 28.5 | <0.01 |
| Show Master Status | 254 | 16 | <0.01 |
| Show Slave Status | 254 | 16 | <0.01 |
| Show Databases | 127 | 8 | <0.01 |
| Show Status | 118 | 7.4 | <0.01 |
| Revoke | 16 | 1 | <0.01 |
| Grant | 8 | 0.5 | <0.01 |
| Update Multi | 7 | 0.4 | <0.01 |
| Alter Table | 4 | 0.3 | <0.01 |
| Insert | 4 | 0.3 | <0.01 |
| Delete | 3 | 0.2 | <0.01 |
| Show Processlist | 3 | 0.2 | <0.01 |
| Flush | 2 | 0.1 | <0.01 |
| Create Db | 1 | 0.1 | <0.01 |
| Show Engine Status | 1 | 0.1 | <0.01 |
| Truncate | 1 | 0.1 | <0.01 |