oceanbase / oceanbase

OceanBase is an enterprise distributed relational database with high availability, high performance, horizontal scalability, and compatibility with SQL standards.
https://open.oceanbase.com
Other
7.78k stars 1.57k forks source link

[Enhancement]: ASH报告支持WR || [Enhancement]: ASH report supports WR #2012

Open huasiy opened 2 weeks ago

huasiy commented 2 weeks ago

Enhancement 当前,ASH报告只会使用ash buffer中保存的采样点。为了使用WR持久化的采样点,首先要划分ASH和WR中采样点的时间区间。

ASH Report
...
User Input Begin Time: 2024-06-17 10:30:45
User Input End Time: 2024-06-17 18:45:38
Analysis Begin Time: 2024-06-17 17:40:56
Analysis End Time: 2024-06-17 17:56:29
AWR Begin Time: 2024-06-17 10:32:40
AWR End Time: 2024-06-17 16:43:11
...

Enhancement Currently, the ASH report only uses the sampling points saved in the ash buffer. In order to use the WR persistent sampling points, you must first divide the time intervals of the sampling points in ASH and WR.

ASH Report
...
User Input Begin Time: 2024-06-17 10:30:45
User Input End Time: 2024-06-17 18:45:38
Analysis Begin Time: 2024-06-17 17:40:56
Analysis End Time: 2024-06-17 17:56:29
AWR Begin Time: 2024-06-17 10:32:40
AWR End Time: 2024-06-17 16:43:11
...
huasiy commented 2 weeks ago

/assign