doris icon indicating copy to clipboard operation
doris copied to clipboard

[feature](be jvm monitor)append enable_jvm_monitor in be.conf to control jvm monitor.

Open hubgeter opened this issue 1 year ago • 14 comments

Proposed changes

before pr : #35023 In order to prevent doris_be from crashing when collecting jvm information due to jvm incompatibility issues, you can set enable_jvm_monitor = true / false in be.conf to enable the jvm metrics.

The default value of enable_jvm_monitor is false.

When JVM monitoring has 30 consecutive exceptions, turn off JVM information collection and set all values ​​to 0.

Issue Number: close #xxx

hubgeter avatar May 29 '24 10:05 hubgeter

Thank you for your contribution to Apache Doris. Don't know what should be done next? See How to process your PR

Since 2024-03-18, the Document has been moved to doris-website. See Doris Document.

doris-robot avatar May 29 '24 10:05 doris-robot

run buildall

hubgeter avatar May 29 '24 10:05 hubgeter

TPC-H: Total hot run time: 42292 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 2709d73476823b61210a37fa8a6389ba69777bd5, data reload: false

------ Round 1 ----------------------------------
q1	17609	4516	4307	4307
q2	2025	204	199	199
q3	10463	1262	1171	1171
q4	10202	822	804	804
q5	7496	2741	2777	2741
q6	218	137	132	132
q7	990	625	636	625
q8	9224	2440	2133	2133
q9	9394	6762	6763	6762
q10	9222	3854	3885	3854
q11	449	245	251	245
q12	491	221	231	221
q13	17552	3182	3277	3182
q14	272	221	234	221
q15	517	469	479	469
q16	498	402	397	397
q17	1034	744	725	725
q18	8505	7877	7740	7740
q19	6509	1655	1651	1651
q20	653	330	331	330
q21	5268	4128	4054	4054
q22	390	329	338	329
Total cold run time: 118981 ms
Total hot run time: 42292 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4556	4428	4464	4428
q2	379	277	283	277
q3	3147	2987	2880	2880
q4	1886	1612	1647	1612
q5	5507	5535	5525	5525
q6	213	124	128	124
q7	2213	1856	1806	1806
q8	3312	3433	3423	3423
q9	8736	8755	8801	8755
q10	3948	3782	3878	3782
q11	601	514	507	507
q12	819	600	632	600
q13	16260	3168	3202	3168
q14	301	283	269	269
q15	523	500	483	483
q16	503	439	438	438
q17	1801	1471	1492	1471
q18	7726	7700	7488	7488
q19	1692	1630	1637	1630
q20	1994	1804	1777	1777
q21	4960	4776	4869	4776
q22	655	523	540	523
Total cold run time: 71732 ms
Total hot run time: 55742 ms

doris-robot avatar May 29 '24 12:05 doris-robot

TeamCity be ut coverage result: Function Coverage: 35.89% (9123/25418) Line Coverage: 27.36% (74947/273932) Region Coverage: 26.60% (38805/145895) Branch Coverage: 23.44% (19752/84254) Coverage Report: http://coverage.selectdb-in.cc/coverage/2709d73476823b61210a37fa8a6389ba69777bd5_2709d73476823b61210a37fa8a6389ba69777bd5/report/index.html

doris-robot avatar May 29 '24 12:05 doris-robot

TPC-DS: Total hot run time: 172714 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 2709d73476823b61210a37fa8a6389ba69777bd5, data reload: false

query1	937	385	370	370
query2	6438	2495	2406	2406
query3	6655	203	213	203
query4	19359	17471	17243	17243
query5	4111	426	419	419
query6	238	155	152	152
query7	4589	305	288	288
query8	312	281	281	281
query9	8731	2450	2437	2437
query10	460	290	306	290
query11	10469	10167	10167	10167
query12	143	88	90	88
query13	1643	397	369	369
query14	9447	7756	6861	6861
query15	227	197	187	187
query16	7632	273	266	266
query17	1310	535	529	529
query18	1933	283	272	272
query19	200	162	154	154
query20	92	89	89	89
query21	194	135	132	132
query22	4136	4091	3951	3951
query23	33522	33224	33026	33026
query24	5115	2834	2920	2834
query25	459	364	377	364
query26	693	155	158	155
query27	1839	319	337	319
query28	3819	2115	2127	2115
query29	865	621	588	588
query30	227	155	156	155
query31	931	757	747	747
query32	63	52	54	52
query33	506	275	262	262
query34	868	481	481	481
query35	707	626	611	611
query36	1071	894	928	894
query37	110	67	67	67
query38	2843	2790	2760	2760
query39	844	799	790	790
query40	198	124	127	124
query41	57	53	54	53
query42	108	100	99	99
query43	615	569	552	552
query44	1084	772	751	751
query45	191	173	168	168
query46	1068	719	714	714
query47	1875	1744	1765	1744
query48	371	299	296	296
query49	761	382	396	382
query50	773	388	403	388
query51	6912	6750	6648	6648
query52	99	91	90	90
query53	357	304	296	296
query54	541	440	434	434
query55	76	75	73	73
query56	264	248	271	248
query57	1087	1068	1057	1057
query58	224	208	208	208
query59	3512	3020	3298	3020
query60	275	258	271	258
query61	92	93	88	88
query62	554	482	478	478
query63	322	298	294	294
query64	2557	1774	1745	1745
query65	3200	3131	3132	3131
query66	765	328	332	328
query67	15111	14878	15014	14878
query68	4524	563	542	542
query69	442	275	277	275
query70	1162	1095	1136	1095
query71	421	270	275	270
query72	7572	5515	5307	5307
query73	734	332	327	327
query74	5993	5611	5626	5611
query75	3310	2648	2613	2613
query76	2186	992	959	959
query77	382	267	268	267
query78	10274	10009	9753	9753
query79	2421	513	521	513
query80	976	442	436	436
query81	520	229	220	220
query82	718	95	94	94
query83	243	173	175	173
query84	244	89	87	87
query85	1078	275	269	269
query86	448	291	322	291
query87	3280	3159	3097	3097
query88	4302	2445	2435	2435
query89	488	394	397	394
query90	2019	200	198	198
query91	136	162	96	96
query92	63	49	53	49
query93	1994	539	515	515
query94	1084	192	187	187
query95	418	321	319	319
query96	586	276	273	273
query97	3191	3064	3080	3064
query98	237	216	219	216
query99	1140	865	850	850
Total cold run time: 249373 ms
Total hot run time: 172714 ms

doris-robot avatar May 29 '24 12:05 doris-robot

ClickBench: Total hot run time: 31.32 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 2709d73476823b61210a37fa8a6389ba69777bd5, data reload: false

query1	0.04	0.04	0.03
query2	0.08	0.03	0.04
query3	0.23	0.04	0.04
query4	1.69	0.07	0.07
query5	0.51	0.48	0.50
query6	1.12	0.73	0.71
query7	0.01	0.01	0.01
query8	0.05	0.04	0.04
query9	0.54	0.48	0.49
query10	0.55	0.55	0.55
query11	0.16	0.11	0.11
query12	0.15	0.12	0.11
query13	0.60	0.58	0.59
query14	0.79	0.75	0.79
query15	0.83	0.82	0.80
query16	0.39	0.37	0.37
query17	0.99	0.99	1.03
query18	0.24	0.21	0.26
query19	1.77	1.78	1.77
query20	0.01	0.01	0.01
query21	15.46	0.69	0.67
query22	4.44	6.27	2.65
query23	18.27	1.33	1.27
query24	1.66	0.31	0.22
query25	0.14	0.09	0.08
query26	0.25	0.16	0.16
query27	0.08	0.08	0.08
query28	13.33	1.00	1.00
query29	12.65	3.39	3.36
query30	0.24	0.05	0.06
query31	2.87	0.38	0.39
query32	3.30	0.47	0.47
query33	2.82	2.88	2.85
query34	17.09	4.43	4.40
query35	4.47	4.49	4.55
query36	0.70	0.49	0.46
query37	0.18	0.16	0.16
query38	0.15	0.14	0.15
query39	0.04	0.04	0.04
query40	0.19	0.14	0.14
query41	0.09	0.04	0.04
query42	0.05	0.04	0.04
query43	0.04	0.04	0.03
Total cold run time: 109.26 s
Total hot run time: 31.32 s

doris-robot avatar May 29 '24 12:05 doris-robot

run buildall

hubgeter avatar May 30 '24 07:05 hubgeter

run buildall

hubgeter avatar May 30 '24 07:05 hubgeter

TeamCity be ut coverage result: Function Coverage: 36.27% (9231/25449) Line Coverage: 27.62% (75693/274077) Region Coverage: 26.84% (39180/145980) Branch Coverage: 23.60% (19893/84288) Coverage Report: http://coverage.selectdb-in.cc/coverage/044c6d4d9edb4666143bf654924da24b53d3c5a7_044c6d4d9edb4666143bf654924da24b53d3c5a7/report/index.html

doris-robot avatar May 30 '24 09:05 doris-robot

run buildall

morningman avatar May 31 '24 06:05 morningman

TPC-H: Total hot run time: 41242 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 251daced77cf6f683f69d65f70f4b99939cabd4c, data reload: false

------ Round 1 ----------------------------------
q1	17613	4419	4234	4234
q2	2034	198	193	193
q3	10447	1270	1082	1082
q4	10194	832	773	773
q5	7515	2732	2706	2706
q6	225	139	137	137
q7	976	649	613	613
q8	9237	2174	2113	2113
q9	9625	6755	6796	6755
q10	9332	3928	3904	3904
q11	463	243	234	234
q12	493	232	233	232
q13	17309	3211	3284	3211
q14	271	228	224	224
q15	517	461	484	461
q16	471	387	390	387
q17	992	687	850	687
q18	8587	8022	7735	7735
q19	6383	1599	1600	1599
q20	663	311	319	311
q21	5267	4060	3324	3324
q22	382	330	327	327
Total cold run time: 118996 ms
Total hot run time: 41242 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4666	4391	4433	4391
q2	384	279	277	277
q3	3149	2985	2819	2819
q4	1870	1580	1605	1580
q5	5514	5522	5529	5522
q6	213	123	122	122
q7	2207	1820	1850	1820
q8	3299	3391	3379	3379
q9	8664	8745	8683	8683
q10	3931	3817	3873	3817
q11	600	493	511	493
q12	785	645	629	629
q13	15872	3162	3202	3162
q14	308	265	270	265
q15	536	481	498	481
q16	501	441	449	441
q17	1822	1485	1479	1479
q18	7833	7489	7655	7489
q19	1709	1572	1636	1572
q20	1988	1791	1783	1783
q21	4846	4749	4652	4652
q22	594	535	532	532
Total cold run time: 71291 ms
Total hot run time: 55388 ms

doris-robot avatar May 31 '24 07:05 doris-robot

TeamCity be ut coverage result: Function Coverage: 36.29% (9232/25443) Line Coverage: 27.63% (75713/274023) Region Coverage: 26.85% (39199/146014) Branch Coverage: 23.60% (19896/84292) Coverage Report: http://coverage.selectdb-in.cc/coverage/251daced77cf6f683f69d65f70f4b99939cabd4c_251daced77cf6f683f69d65f70f4b99939cabd4c/report/index.html

doris-robot avatar May 31 '24 07:05 doris-robot

TPC-DS: Total hot run time: 172719 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 251daced77cf6f683f69d65f70f4b99939cabd4c, data reload: false

query1	919	375	378	375
query2	6472	2388	2341	2341
query3	6669	208	201	201
query4	19745	17186	17165	17165
query5	4111	419	402	402
query6	246	162	155	155
query7	4580	305	296	296
query8	318	293	281	281
query9	8508	2367	2340	2340
query10	453	288	266	266
query11	10621	10187	10077	10077
query12	146	91	87	87
query13	1668	373	370	370
query14	9375	7616	7487	7487
query15	259	192	185	185
query16	7813	279	261	261
query17	1738	518	514	514
query18	1977	270	267	267
query19	201	152	149	149
query20	95	86	87	86
query21	199	137	129	129
query22	4125	3889	3847	3847
query23	33612	33010	33045	33010
query24	6648	2850	2772	2772
query25	529	355	381	355
query26	699	158	154	154
query27	1918	326	324	324
query28	3693	2078	2050	2050
query29	858	601	591	591
query30	225	152	152	152
query31	955	767	755	755
query32	95	54	55	54
query33	499	298	259	259
query34	857	485	475	475
query35	693	627	605	605
query36	1063	961	920	920
query37	104	67	69	67
query38	2924	2815	2763	2763
query39	831	779	788	779
query40	203	158	122	122
query41	46	44	52	44
query42	99	96	94	94
query43	586	554	553	553
query44	1093	744	756	744
query45	182	174	176	174
query46	1051	709	726	709
query47	1849	1780	1790	1780
query48	391	298	298	298
query49	764	391	385	385
query50	780	389	379	379
query51	6822	6569	6666	6569
query52	104	88	91	88
query53	355	287	296	287
query54	543	436	431	431
query55	72	75	72	72
query56	263	248	247	247
query57	1125	1032	1061	1032
query58	228	207	210	207
query59	3462	3286	3144	3144
query60	278	265	254	254
query61	109	87	86	86
query62	550	464	456	456
query63	311	285	285	285
query64	8400	2263	1787	1787
query65	3169	3065	3080	3065
query66	778	320	335	320
query67	15451	14863	14794	14794
query68	4573	555	562	555
query69	447	267	276	267
query70	1202	1161	1122	1122
query71	386	271	264	264
query72	7425	5648	5407	5407
query73	748	326	326	326
query74	6093	5642	5606	5606
query75	3385	2627	2639	2627
query76	2198	994	938	938
query77	416	269	270	269
query78	10380	9972	9754	9754
query79	2402	520	520	520
query80	895	466	456	456
query81	503	237	221	221
query82	650	97	94	94
query83	248	179	176	176
query84	244	89	91	89
query85	1212	324	317	317
query86	482	301	298	298
query87	3293	3117	3151	3117
query88	4225	2441	2440	2440
query89	471	391	401	391
query90	2073	203	193	193
query91	134	110	107	107
query92	60	49	51	49
query93	2345	528	504	504
query94	1193	202	192	192
query95	412	322	322	322
query96	590	273	269	269
query97	3188	3015	2995	2995
query98	253	217	211	211
query99	1170	851	871	851
Total cold run time: 258801 ms
Total hot run time: 172719 ms

doris-robot avatar May 31 '24 07:05 doris-robot

ClickBench: Total hot run time: 30.54 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 251daced77cf6f683f69d65f70f4b99939cabd4c, data reload: false

query1	0.04	0.04	0.03
query2	0.09	0.05	0.04
query3	0.23	0.04	0.05
query4	1.67	0.07	0.07
query5	0.50	0.49	0.51
query6	1.13	0.73	0.72
query7	0.02	0.01	0.01
query8	0.05	0.04	0.05
query9	0.53	0.48	0.49
query10	0.53	0.56	0.55
query11	0.15	0.12	0.11
query12	0.14	0.13	0.12
query13	0.60	0.59	0.59
query14	0.78	0.79	0.80
query15	0.82	0.82	0.81
query16	0.37	0.38	0.37
query17	0.93	0.99	0.95
query18	0.20	0.26	0.25
query19	1.76	1.68	1.74
query20	0.01	0.00	0.01
query21	15.62	0.65	0.64
query22	4.31	7.27	2.00
query23	18.29	1.41	1.25
query24	2.05	0.23	0.20
query25	0.14	0.08	0.09
query26	0.28	0.17	0.17
query27	0.08	0.08	0.07
query28	13.23	1.05	0.99
query29	13.77	3.29	3.26
query30	0.24	0.05	0.05
query31	2.91	0.38	0.39
query32	3.25	0.47	0.48
query33	2.88	2.90	2.91
query34	17.24	4.47	4.40
query35	4.52	4.51	4.67
query36	0.65	0.46	0.46
query37	0.17	0.16	0.15
query38	0.15	0.15	0.14
query39	0.04	0.03	0.03
query40	0.17	0.14	0.15
query41	0.10	0.04	0.05
query42	0.06	0.04	0.05
query43	0.04	0.03	0.04
Total cold run time: 110.74 s
Total hot run time: 30.54 s

doris-robot avatar May 31 '24 07:05 doris-robot

run buildall

morningman avatar May 31 '24 14:05 morningman

TPC-H: Total hot run time: 41766 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit dbf3f98b260f1e1a8cb0d7fdd108fc4b4f3f16c6, data reload: false

------ Round 1 ----------------------------------
q1	17623	4442	4273	4273
q2	2030	201	192	192
q3	10458	1250	1193	1193
q4	10198	882	844	844
q5	7525	2789	2757	2757
q6	223	135	143	135
q7	999	636	609	609
q8	9219	2153	2116	2116
q9	9339	6725	6754	6725
q10	9304	3881	3883	3881
q11	444	247	262	247
q12	443	234	230	230
q13	17520	3218	3263	3218
q14	278	230	222	222
q15	529	478	484	478
q16	468	400	393	393
q17	1020	636	585	585
q18	8459	7848	7815	7815
q19	3143	1256	1451	1256
q20	663	310	319	310
q21	5165	3957	4165	3957
q22	399	330	331	330
Total cold run time: 115449 ms
Total hot run time: 41766 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4572	4493	4471	4471
q2	373	263	265	263
q3	3146	2947	2957	2947
q4	1955	1639	1626	1626
q5	5453	5544	5475	5475
q6	229	131	128	128
q7	2219	1820	1814	1814
q8	3234	3384	3431	3384
q9	8690	8647	8756	8647
q10	4129	3921	3684	3684
q11	578	493	498	493
q12	824	611	626	611
q13	16087	3140	3122	3122
q14	302	277	258	258
q15	533	484	473	473
q16	477	410	423	410
q17	1800	1486	1478	1478
q18	8094	7632	7342	7342
q19	1726	1650	1563	1563
q20	3037	1769	1770	1769
q21	8219	4624	4749	4624
q22	676	546	549	546
Total cold run time: 76353 ms
Total hot run time: 55128 ms

doris-robot avatar May 31 '24 16:05 doris-robot

TeamCity be ut coverage result: Function Coverage: 36.27% (9234/25459) Line Coverage: 27.63% (75751/274128) Region Coverage: 26.84% (39206/146061) Branch Coverage: 23.60% (19904/84324) Coverage Report: http://coverage.selectdb-in.cc/coverage/dbf3f98b260f1e1a8cb0d7fdd108fc4b4f3f16c6_dbf3f98b260f1e1a8cb0d7fdd108fc4b4f3f16c6/report/index.html

doris-robot avatar May 31 '24 16:05 doris-robot

TPC-H: Total hot run time: 41097 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit dbf3f98b260f1e1a8cb0d7fdd108fc4b4f3f16c6, data reload: false

------ Round 1 ----------------------------------
q1	17709	4662	4284	4284
q2	2043	205	200	200
q3	10550	1169	1157	1157
q4	10957	777	948	777
q5	7759	2772	2652	2652
q6	221	140	147	140
q7	1002	633	618	618
q8	9294	2180	2085	2085
q9	9643	6758	6786	6758
q10	7100	3951	3936	3936
q11	469	236	235	235
q12	439	234	248	234
q13	17906	3159	3121	3121
q14	264	227	224	224
q15	506	489	481	481
q16	531	420	401	401
q17	1019	777	645	645
q18	8462	8006	7876	7876
q19	6880	1368	1606	1368
q20	660	324	330	324
q21	5113	3251	3336	3251
q22	393	330	339	330
Total cold run time: 118920 ms
Total hot run time: 41097 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4677	4330	4318	4318
q2	378	264	274	264
q3	3168	2870	2869	2869
q4	1997	1677	1737	1677
q5	5455	5517	5495	5495
q6	231	130	133	130
q7	2228	1841	1847	1841
q8	3241	3460	3422	3422
q9	8792	8643	8595	8595
q10	4100	3773	3816	3773
q11	598	489	500	489
q12	823	615	664	615
q13	17571	3142	3056	3056
q14	293	263	268	263
q15	509	478	470	470
q16	484	424	431	424
q17	1811	1484	1494	1484
q18	7743	7502	7458	7458
q19	1718	1555	1622	1555
q20	2056	1810	1757	1757
q21	7263	4780	4712	4712
q22	598	509	531	509
Total cold run time: 75734 ms
Total hot run time: 55176 ms

doris-robot avatar Jun 01 '24 01:06 doris-robot

TPC-DS: Total hot run time: 170186 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit dbf3f98b260f1e1a8cb0d7fdd108fc4b4f3f16c6, data reload: false

query1	918	375	370	370
query2	6463	2461	2359	2359
query3	6644	200	202	200
query4	19877	17512	17278	17278
query5	4216	450	450	450
query6	253	158	156	156
query7	4588	304	296	296
query8	308	292	276	276
query9	8536	2420	2418	2418
query10	446	299	294	294
query11	10826	10106	10260	10106
query12	134	87	92	87
query13	1631	363	363	363
query14	10161	7440	7547	7440
query15	239	191	193	191
query16	7794	274	271	271
query17	1812	531	511	511
query18	1949	271	281	271
query19	213	146	160	146
query20	95	88	88	88
query21	207	129	127	127
query22	4209	4022	3879	3879
query23	33657	33029	33149	33029
query24	10954	2808	2825	2808
query25	596	351	364	351
query26	955	156	154	154
query27	2280	304	312	304
query28	6568	2071	2070	2070
query29	864	646	600	600
query30	294	149	152	149
query31	966	767	781	767
query32	89	53	53	53
query33	766	294	276	276
query34	988	477	473	473
query35	749	606	603	603
query36	1063	941	907	907
query37	135	68	70	68
query38	2930	2794	2794	2794
query39	868	800	801	800
query40	203	128	129	128
query41	53	52	53	52
query42	118	98	98	98
query43	575	548	530	530
query44	1217	720	735	720
query45	211	178	171	171
query46	1079	742	739	739
query47	1854	1766	1819	1766
query48	372	299	293	293
query49	1069	414	429	414
query50	795	399	395	395
query51	6899	6644	6589	6589
query52	111	86	92	86
query53	357	294	288	288
query54	885	466	441	441
query55	73	73	72	72
query56	285	261	267	261
query57	1135	1058	1028	1028
query58	261	242	256	242
query59	3474	3194	3127	3127
query60	297	296	305	296
query61	94	90	90	90
query62	651	443	441	441
query63	304	285	285	285
query64	8718	2209	1750	1750
query65	3146	3129	3131	3129
query66	843	337	343	337
query67	15331	14744	14710	14710
query68	4528	542	528	528
query69	474	326	310	310
query70	1197	1061	1145	1061
query71	377	341	290	290
query72	6977	2712	2575	2575
query73	760	329	322	322
query74	6156	5544	5648	5544
query75	3358	2628	2668	2628
query76	2245	941	952	941
query77	449	298	298	298
query78	10305	9708	9756	9708
query79	2807	502	510	502
query80	1166	470	453	453
query81	580	224	226	224
query82	719	102	103	102
query83	233	174	168	168
query84	246	89	88	88
query85	1539	280	267	267
query86	520	305	322	305
query87	3322	3156	3182	3156
query88	4087	2440	2421	2421
query89	458	386	373	373
query90	1767	194	195	194
query91	125	98	97	97
query92	62	53	50	50
query93	1880	515	496	496
query94	1188	196	189	189
query95	406	319	319	319
query96	597	281	270	270
query97	3170	3066	2997	2997
query98	232	223	207	207
query99	1288	843	842	842
Total cold run time: 269869 ms
Total hot run time: 170186 ms

doris-robot avatar Jun 01 '24 01:06 doris-robot

ClickBench: Total hot run time: 30.69 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit dbf3f98b260f1e1a8cb0d7fdd108fc4b4f3f16c6, data reload: false

query1	0.04	0.03	0.03
query2	0.08	0.03	0.04
query3	0.24	0.06	0.05
query4	1.66	0.09	0.09
query5	0.51	0.48	0.51
query6	1.13	0.71	0.74
query7	0.02	0.01	0.01
query8	0.05	0.05	0.05
query9	0.54	0.48	0.48
query10	0.55	0.55	0.54
query11	0.16	0.11	0.12
query12	0.16	0.12	0.12
query13	0.59	0.60	0.60
query14	0.80	0.78	0.78
query15	0.83	0.83	0.81
query16	0.35	0.37	0.35
query17	1.01	1.01	1.02
query18	0.21	0.26	0.23
query19	1.90	1.74	1.80
query20	0.02	0.01	0.01
query21	15.61	0.67	0.66
query22	4.36	7.64	1.89
query23	18.28	1.35	1.24
query24	1.31	0.42	0.23
query25	0.15	0.09	0.08
query26	0.27	0.17	0.17
query27	0.08	0.08	0.09
query28	13.37	1.02	1.01
query29	13.33	3.34	3.26
query30	0.23	0.05	0.07
query31	2.88	0.41	0.38
query32	3.28	0.47	0.46
query33	2.88	2.91	2.92
query34	17.12	4.48	4.41
query35	4.49	4.57	4.60
query36	0.65	0.49	0.46
query37	0.17	0.15	0.16
query38	0.15	0.14	0.15
query39	0.05	0.04	0.04
query40	0.17	0.15	0.15
query41	0.09	0.04	0.04
query42	0.06	0.05	0.04
query43	0.04	0.04	0.04
Total cold run time: 109.87 s
Total hot run time: 30.69 s

doris-robot avatar Jun 01 '24 01:06 doris-robot

PR approved by at least one committer and no changes requested.

github-actions[bot] avatar Jun 01 '24 01:06 github-actions[bot]

PR approved by anyone and no changes requested.

github-actions[bot] avatar Jun 01 '24 01:06 github-actions[bot]