Capacityanalysis » 历史记录 » 版本 8
赵鹏军, 2021-08-11 09:24
| 1 | 1 | 赵鹏军 | h1. Capacityanalysis |
|---|---|---|---|
| 2 | |||
| 3 | > es地址： |
||
| 4 | 2 | 赵鹏军 | * 【http://113.200.75.45:19200/】 |
| 5 | 1 | 赵鹏军 | |
| 6 | > 数据信息 |
||
| 7 | 7 | 赵鹏军 | * 索引：monitor-performance-search |
| 8 | 6 | 赵鹏军 | {{collapse() |
| 9 | !WX20210811-002045@2x.png! |
||
| 10 | 8 | 赵鹏军 | |
| 11 | <pre> |
||
| 12 | { |
||
| 13 | "id": "7fca92f6d5314681988e5f251014d799", |
||
| 14 | "dbTime": "2021-06-24T12:18:32.000+0800", |
||
| 15 | "kpiValue": 97.51, |
||
| 16 | "kpiUnit": "null", |
||
| 17 | "resId": "d8e9edfd25da4982b21fbfda29bf8198", |
||
| 18 | "flag": "mem", |
||
| 19 | "kpiId": "KPI31CB8D97", |
||
| 20 | "dbTimeStr": "2021/6/24", |
||
| 21 | "busId": "null", |
||
| 22 | "busIds": null, |
||
| 23 | "busNames": null |
||
| 24 | } |
||
| 25 | </pre> |
||
| 26 | |||
| 27 | 1 | 赵鹏军 | }} |
| 28 | * type：performance |
||
| 29 | * 查询sql |
||
| 30 | <pre><code class="sql"> |
||
| 31 | -- 资源d8e9edfd25da4982b21fbfda29bf8198的内存使用率 |
||
| 32 | SELECT * FROM monitor-performance-search where resId = 'd8e9edfd25da4982b21fbfda29bf8198' and kpiId = 'KPI31CB8D97' limit 1000; |
||
| 33 | |||
| 34 | -- 资源d8e9edfd25da4982b21fbfda29bf8198的CPU使用率 |
||
| 35 | SELECT * FROM monitor-performance-search where resId = 'd8e9edfd25da4982b21fbfda29bf8198' and kpiId = 'KPI7054BC34' limit 1000; |
||
| 36 | |||
| 37 | -- 资源8b4d5cebe8dd47518149829dd31d9239的内存使用率 |
||
| 38 | SELECT * FROM monitor-performance-search where resId = '8b4d5cebe8dd47518149829dd31d9239' and kpiId = 'KPI31CB8D97' limit 1000; |
||
| 39 | 3 | 赵鹏军 | </code></pre> |
| 40 | {{collapse() |
||
| 41 | 5 | 赵鹏军 | !WX20210811-002539@2x.png! |
| 42 | 3 | 赵鹏军 | }} |