2026-06-04 09:40 ~ 2026-06-02 10:20 期间，运营后台系统的用户数据查询明显变慢，甚至超时。由大数据StarRocks集群压力过大引发。
基于 SR的审计日志
内存稳定在 85% 左右
|
table_name |
当天时间段 |
周环比时间段 |
差值 (A-B) |
|
dmp_ods.ods_dc_sbh_plat_order |
594 |
258 |
+336 |
|
dmp_ads.ads_c_order_detail_all_gv_view |
115 |
7 |
+108 |
| dmp_ads.ads_order_profit_sum_gv | 430 | 533 | -103 |
|
dmp_ads.ads_order_detail_all_gv_view |
297 |
218 |
+79 |
这期间有大查询，c端运营，扫描的数据量，3G-18G不等
|
table_name |
time |
A_count(今日) |
B_count(一周前) |
A-B差值 |
|
dmp_ads.ads_c_order_detail_all_gv_view |
09:40 |
1 |
0 |
1 |
|
dmp_ads.ads_c_order_detail_all_gv_view |
09:41 |
2 |
0 |
2 |
|
dmp_ads.ads_c_order_detail_all_gv_view |
09:43 |
2 |
0 |
2 |
|
dmp_ads.ads_c_order_detail_all_gv_view |
09:44 |
2 |
0 |
2 |
|
dmp_ads.ads_c_order_detail_all_gv_view |
09:50 |
2 |
0 |
2 |
|
dmp_ads.ads_c_order_detail_all_gv_view |
09:53 |
1 |
0 |
1 |
|
dmp_ads.ads_c_order_detail_all_gv_view |
09:54 |
1 |
0 |
1 |
|
dmp_ads.ads_c_order_detail_all_gv_view |
09:55 |
2 |
1 |
1 |
|
dmp_ads.ads_c_order_detail_all_gv_view |
09:56 |
3 |
0 |
3 |
|
dmp_ads.ads_c_order_detail_all_gv_view |
09:57 |
5 |
0 |
5 |
|
dmp_ads.ads_c_order_detail_all_gv_view |
09:59 |
6 |
0 |
6 |
|
dmp_ads.ads_c_order_detail_all_gv_view |
10:01 |
3 |
0 |
3 |
|
dmp_ads.ads_c_order_detail_all_gv_view |
10:02 |
4 |
0 |
4 |
|
dmp_ads.ads_c_order_detail_all_gv_view |
10:03 |
13 |
0 |
13 |
|
dmp_ads.ads_c_order_detail_all_gv_view |
10:04 |
5 |
0 |
5 |
|
dmp_ads.ads_c_order_detail_all_gv_view |
10:05 |
5 |
0 |
5 |
|
dmp_ads.ads_c_order_detail_all_gv_view |
10:06 |
7 |
0 |
7 |
|
dmp_ads.ads_c_order_detail_all_gv_view |
10:09 |
6 |
2 |
4 |
|
dmp_ads.ads_c_order_detail_all_gv_view |
10:11 |
14 |
0 |
14 |
|
dmp_ads.ads_c_order_detail_all_gv_view |
10:13 |
8 |
2 |
6 |
|
dmp_ads.ads_c_order_detail_all_gv_view |
10:14 |
9 |
1 |
8 |
|
dmp_ads.ads_c_order_detail_all_gv_view |
10:15 |
6 |
1 |
5 |
|
dmp_ads.ads_c_order_detail_all_gv_view |
10:16 |
6 |
0 |
6 |
|
dmp_ads.ads_c_order_detail_all_gv_view |
10:19 |
2 |
0 |
2 |
|
dmp_ads.ads_order_detail_all_gv_view |
09:40 |
6 |
2 |
4 |
|
dmp_ads.ads_order_detail_all_gv_view |
09:41 |
14 |
0 |
14 |
|
dmp_ads.ads_order_detail_all_gv_view |
09:42 |
7 |
0 |
7 |
|
dmp_ads.ads_order_detail_all_gv_view |
09:43 |
2 |
0 |
2 |
|
dmp_ads.ads_order_detail_all_gv_view |
09:44 |
2 |
0 |
2 |
|
dmp_ads.ads_order_detail_all_gv_view |
09:46 |
0 |
4 |
-4 |
|
dmp_ads.ads_order_detail_all_gv_view |
09:47 |
1 |
4 |
-3 |
|
dmp_ads.ads_order_detail_all_gv_view |
09:48 |
2 |
9 |
-7 |
|
dmp_ads.ads_order_detail_all_gv_view |
09:49 |
0 |
2 |
-2 |
|
dmp_ads.ads_order_detail_all_gv_view |
09:51 |
5 |
2 |
3 |
|
dmp_ads.ads_order_detail_all_gv_view |
09:53 |
0 |
3 |
-3 |
|
dmp_ads.ads_order_detail_all_gv_view |
09:54 |
2 |
6 |
-4 |
|
dmp_ads.ads_order_detail_all_gv_view |
09:55 |
23 |
0 |
23 |
|
dmp_ads.ads_order_detail_all_gv_view |
09:56 |
3 |
2 |
1 |
|
dmp_ads.ads_order_detail_all_gv_view |
09:57 |
0 |
3 |
-3 |
|
dmp_ads.ads_order_detail_all_gv_view |
09:58 |
0 |
8 |
-8 |
|
dmp_ads.ads_order_detail_all_gv_view |
09:59 |
24 |
4 |
20 |
|
dmp_ads.ads_order_detail_all_gv_view |
10:00 |
5 |
12 |
-7 |
|
dmp_ads.ads_order_detail_all_gv_view |
10:01 |
12 |
1 |
11 |
|
dmp_ads.ads_order_detail_all_gv_view |
10:02 |
19 |
1 |
18 |
|
dmp_ads.ads_order_detail_all_gv_view |
10:03 |
11 |
3 |
8 |
|
dmp_ads.ads_order_detail_all_gv_view |
10:04 |
17 |
6 |
11 |
|
dmp_ads.ads_order_detail_all_gv_view |
10:05 |
23 |
4 |
19 |
|
dmp_ads.ads_order_detail_all_gv_view |
10:06 |
11 |
6 |
5 |
|
dmp_ads.ads_order_detail_all_gv_view |
10:07 |
4 |
7 |
-3 |
|
dmp_ads.ads_order_detail_all_gv_view |
10:08 |
3 |
13 |
-10 |
|
dmp_ads.ads_order_detail_all_gv_view |
10:09 |
10 |
14 |
-4 |
|
dmp_ads.ads_order_detail_all_gv_view |
10:10 |
2 |
5 |
-3 |
|
dmp_ads.ads_order_detail_all_gv_view |
10:11 |
14 |
5 |
9 |
|
dmp_ads.ads_order_detail_all_gv_view |
10:12 |
9 |
9 |
0 |
|
dmp_ads.ads_order_detail_all_gv_view |
10:13 |
17 |
7 |
10 |
|
dmp_ads.ads_order_detail_all_gv_view |
10:14 |
3 |
15 |
-12 |
|
dmp_ads.ads_order_detail_all_gv_view |
10:15 |
11 |
24 |
-13 |
|
dmp_ads.ads_order_detail_all_gv_view |
10:16 |
3 |
6 |
-3 |
|
dmp_ads.ads_order_detail_all_gv_view |
10:17 |
2 |
5 |
-3 |
|
dmp_ads.ads_order_detail_all_gv_view |
10:18 |
4 |
18 |
-14 |
|
dmp_ads.ads_order_detail_all_gv_view |
10:19 |
26 |
8 |
18 |
|
dmp_ads.ads_order_profit_sum_gv |
09:40 |
2 |
7 |
-5 |
|
dmp_ads.ads_order_profit_sum_gv |
09:41 |
27 |
18 |
9 |
|
dmp_ads.ads_order_profit_sum_gv |
09:42 |
12 |
12 |
0 |
|
dmp_ads.ads_order_profit_sum_gv |
09:43 |
12 |
7 |
5 |
|
dmp_ads.ads_order_profit_sum_gv |
09:44 |
7 |
16 |
-9 |
|
dmp_ads.ads_order_profit_sum_gv |
09:45 |
3 |
11 |
-8 |
|
dmp_ads.ads_order_profit_sum_gv |
09:46 |
7 |
2 |
5 |
|
dmp_ads.ads_order_profit_sum_gv |
09:47 |
24 |
14 |
10 |
|
dmp_ads.ads_order_profit_sum_gv |
09:48 |
30 |
16 |
14 |
|
dmp_ads.ads_order_profit_sum_gv |
09:49 |
23 |
10 |
13 |
|
dmp_ads.ads_order_profit_sum_gv |
09:50 |
24 |
15 |
9 |
|
dmp_ads.ads_order_profit_sum_gv |
09:51 |
4 |
18 |
-14 |
|
dmp_ads.ads_order_profit_sum_gv |
09:52 |
1 |
30 |
-29 |
|
dmp_ads.ads_order_profit_sum_gv |
09:53 |
16 |
15 |
1 |
|
dmp_ads.ads_order_profit_sum_gv |
09:54 |
13 |
28 |
-15 |
|
dmp_ads.ads_order_profit_sum_gv |
09:55 |
12 |
15 |
-3 |
|
dmp_ads.ads_order_profit_sum_gv |
09:56 |
20 |
40 |
-20 |
|
dmp_ads.ads_order_profit_sum_gv |
09:57 |
9 |
20 |
-11 |
|
dmp_ads.ads_order_profit_sum_gv |
09:58 |
3 |
10 |
-7 |
|
dmp_ads.ads_order_profit_sum_gv |
09:59 |
15 |
13 |
2 |
|
dmp_ads.ads_order_profit_sum_gv |
10:00 |
4 |
16 |
-12 |
|
dmp_ads.ads_order_profit_sum_gv |
10:01 |
4 |
5 |
-1 |
|
dmp_ads.ads_order_profit_sum_gv |
10:02 |
6 |
16 |
-10 |
|
dmp_ads.ads_order_profit_sum_gv |
10:03 |
7 |
10 |
-3 |
|
dmp_ads.ads_order_profit_sum_gv |
10:04 |
2 |
8 |
-6 |
|
dmp_ads.ads_order_profit_sum_gv |
10:05 |
2 |
10 |
-8 |
|
dmp_ads.ads_order_profit_sum_gv |
10:06 |
16 |
9 |
7 |
|
dmp_ads.ads_order_profit_sum_gv |
10:07 |
2 |
11 |
-9 |
|
dmp_ads.ads_order_profit_sum_gv |
10:08 |
0 |
1 |
-1 |
|
dmp_ads.ads_order_profit_sum_gv |
10:09 |
3 |
14 |
-11 |
|
dmp_ads.ads_order_profit_sum_gv |
10:10 |
6 |
5 |
1 |
|
dmp_ads.ads_order_profit_sum_gv |
10:11 |
9 |
14 |
-5 |
|
dmp_ads.ads_order_profit_sum_gv |
10:12 |
12 |
15 |
-3 |
|
dmp_ads.ads_order_profit_sum_gv |
10:13 |
22 |
13 |
9 |
|
dmp_ads.ads_order_profit_sum_gv |
10:14 |
12 |
22 |
-10 |
|
dmp_ads.ads_order_profit_sum_gv |
10:15 |
20 |
18 |
2 |
|
dmp_ads.ads_order_profit_sum_gv |
10:16 |
11 |
6 |
5 |
|
dmp_ads.ads_order_profit_sum_gv |
10:17 |
7 |
6 |
1 |
|
dmp_ads.ads_order_profit_sum_gv |
10:18 |
12 |
10 |
2 |
|
dmp_ads.ads_order_profit_sum_gv |
10:19 |
9 |
7 |
2 |
最多 Pending 了 94 个查询，其中大资源组41，短查询资源组 53
各个资源组的资源分配情况
支持的QPS
新试图 ads_order_detail_all_gv_view_new_refund_all： 7-8
老view:dmp_ads.ads_order_detail_all_gv_view 2-3
连接上 sr
sby：mysql -h dmp02 -P9030 -uapp_admin_user -p'01wwYcMu' --default-character-set=utf8mb4
SHOW PROC '/current_queries'; 把 大查询 kill 掉
KILL QUERY <ConnectionId>;
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。