You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "dataroaring (via GitHub)" <gi...@apache.org> on 2024/01/08 15:05:36 UTC

[PR] [improvement](cooldown) do not cooldown tablet without cold data [doris]

dataroaring opened a new pull request, #29690:
URL: https://github.com/apache/doris/pull/29690

   ## Proposed changes
   
   Issue Number: close #xxx
   
   <!--Describe your changes.-->
   
   ## Further comments
   
   If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [improvement](cooldown) do not cooldown tablet without cold data [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29690:
URL: https://github.com/apache/doris/pull/29690#issuecomment-1883344507

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.56 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 60227afedfeef33e0944dc08f97e16d415bf146c, data reload: false
   
   query1	0.07	0.07	0.07
   query2	0.07	0.03	0.02
   query3	0.32	0.21	0.23
   query4	1.72	0.20	0.18
   query5	0.52	0.52	0.52
   query6	1.57	0.69	0.70
   query7	0.02	0.01	0.01
   query8	0.04	0.03	0.03
   query9	0.60	0.56	0.58
   query10	0.60	0.60	0.61
   query11	0.16	0.13	0.12
   query12	0.15	0.12	0.13
   query13	0.60	0.60	0.60
   query14	0.78	0.79	0.79
   query15	0.82	0.80	0.79
   query16	0.35	0.36	0.35
   query17	0.96	0.99	1.00
   query18	0.25	0.25	0.25
   query19	1.86	1.77	1.78
   query20	0.02	0.01	0.01
   query21	15.39	0.53	0.54
   query22	2.88	3.68	1.48
   query23	17.57	1.05	0.87
   query24	10.22	0.86	0.33
   query25	1.57	0.18	0.17
   query26	0.15	0.15	0.17
   query27	0.17	0.18	0.17
   query28	5.67	1.00	0.92
   query29	12.98	3.47	3.49
   query30	0.53	0.46	0.51
   query31	2.91	0.37	0.37
   query32	3.30	0.48	0.48
   query33	3.24	3.23	3.22
   query34	16.60	4.49	4.56
   query35	4.67	4.60	4.44
   query36	1.14	1.08	1.09
   query37	0.06	0.04	0.05
   query38	0.04	0.02	0.03
   query39	0.02	0.02	0.02
   query40	0.16	0.15	0.13
   query41	0.07	0.02	0.01
   query42	0.02	0.02	0.01
   query43	0.02	0.02	0.02
   Total cold run time: 110.86 s
   Total hot run time: 31.56 s
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [improvement](cooldown) do not cooldown tablet without cold data [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29690:
URL: https://github.com/apache/doris/pull/29690#issuecomment-1881366115

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 184065 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit cc3bd9020339363cbfe25709fd73861057cb3912, data reload: false
   
   run tpcds-sf100 query with default conf and session variables
   query1	942	341	330	330
   query2	6580	1974	2031	1974
   query3	6723	224	230	224
   query4	26360	22473	22543	22473
   query5	6074	639	624	624
   query6	343	215	202	202
   query7	4641	293	306	293
   query8	250	223	218	218
   query9	8685	2852	2855	2852
   query10	541	361	327	327
   query11	16290	15761	15641	15641
   query12	160	100	92	92
   query13	1683	339	354	339
   query14	12874	7565	7538	7538
   query15	272	227	225	225
   query16	6396	343	333	333
   query17	1700	514	520	514
   query18	1980	310	297	297
   query19	240	163	156	156
   query20	104	104	102	102
   query21	184	99	95	95
   query22	4974	4741	4726	4726
   query23	32081	31346	31733	31346
   query24	10944	2910	2907	2907
   query25	642	358	364	358
   query26	1348	160	176	160
   query27	2895	317	314	314
   query28	7177	2122	2132	2122
   query29	1167	433	427	427
   query30	282	143	147	143
   query31	1019	817	851	817
   query32	140	90	86	86
   query33	840	361	349	349
   query34	849	467	469	467
   query35	998	836	839	836
   query36	1397	1229	1275	1229
   query37	120	103	95	95
   query38	3556	3366	3372	3366
   query39	1341	1296	1309	1296
   query40	186	88	88	88
   query41	39	36	36	36
   query42	110	110	109	109
   query43	563	539	529	529
   query44	1240	812	801	801
   query45	218	206	214	206
   query46	1091	690	701	690
   query47	1699	1567	1595	1567
   query48	351	284	286	284
   query49	1071	339	306	306
   query50	760	326	329	326
   query51	5501	5277	5261	5261
   query52	111	100	95	95
   query53	242	169	161	161
   query54	1410	688	696	688
   query55	106	110	95	95
   query56	276	252	256	252
   query57	1019	991	982	982
   query58	311	280	300	280
   query59	3007	2943	3031	2943
   query60	312	301	294	294
   query61	158	152	144	144
   query62	631	476	477	476
   query63	194	186	185	185
   query64	5027	1661	1719	1661
   query65	3410	3366	3364	3364
   query66	1005	375	405	375
   query67	15506	15058	15591	15058
   query68	12548	571	538	538
   query69	569	310	338	310
   query70	1817	1703	1544	1544
   query71	611	292	253	253
   query72	5279	3439	3427	3427
   query73	2207	341	342	341
   query74	7037	6592	6588	6588
   query75	4978	2318	2322	2318
   query76	6406	1198	1203	1198
   query77	789	329	371	329
   query78	9086	8694	8543	8543
   query79	1054	534	525	525
   query80	562	339	344	339
   query81	488	215	221	215
   query82	245	108	111	108
   query83	164	139	138	138
   query84	253	55	60	55
   query85	915	272	265	265
   query86	443	444	449	444
   query87	3679	3507	3443	3443
   query88	2949	2541	2533	2533
   query89	348	299	281	281
   query90	1896	260	245	245
   query91	121	93	112	93
   query92	93	85	84	84
   query93	1035	434	435	434
   query94	844	265	249	249
   query95	575	500	493	493
   query96	647	338	335	335
   query97	4362	4224	4391	4224
   query98	242	223	209	209
   query99	1170	878	815	815
   Total cold run time: 293758 ms
   Total hot run time: 184065 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [improvement](cooldown) do not cooldown tablet without cold data [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29690:
URL: https://github.com/apache/doris/pull/29690#issuecomment-1883338468

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 45.49 seconds
    stream load tsv:          575 seconds loaded 74807831229 Bytes, about 124 MB/s
    stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
    stream load orc:          66 seconds loaded 1101869774 Bytes, about 15 MB/s
    stream load parquet:          32 seconds loaded 861443392 Bytes, about 25 MB/s
    insert into select:          21.3 seconds inserted 10000000 Rows, about 469K ops/s
    storage size: 17184130568 Bytes


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [improvement](cooldown) do not cooldown tablet without cold data [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29690:
URL: https://github.com/apache/doris/pull/29690#issuecomment-1881377443

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 46.79 seconds
    stream load tsv:          566 seconds loaded 74807831229 Bytes, about 126 MB/s
    stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
    stream load orc:          65 seconds loaded 1101869774 Bytes, about 16 MB/s
    stream load parquet:          32 seconds loaded 861443392 Bytes, about 25 MB/s
    insert into select:          27.1 seconds inserted 10000000 Rows, about 369K ops/s
    storage size: 17184067697 Bytes


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [improvement](cooldown) do not cooldown tablet without cold data [doris]

Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring merged PR #29690:
URL: https://github.com/apache/doris/pull/29690


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [improvement](cooldown) do not cooldown tablet without cold data [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29690:
URL: https://github.com/apache/doris/pull/29690#issuecomment-1883334475

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 186683 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 60227afedfeef33e0944dc08f97e16d415bf146c, data reload: false
   
   run tpcds-sf100 query with default conf and session variables
   query1	957	348	351	348
   query2	6907	2059	1967	1967
   query3	6730	240	231	231
   query4	26180	22606	22611	22606
   query5	5598	606	593	593
   query6	323	227	220	220
   query7	4654	299	305	299
   query8	275	247	243	243
   query9	9577	3309	3298	3298
   query10	511	355	307	307
   query11	16377	15665	15578	15578
   query12	198	116	127	116
   query13	1653	342	333	333
   query14	12759	7622	7515	7515
   query15	267	254	224	224
   query16	6493	361	345	345
   query17	1734	532	532	532
   query18	1989	331	304	304
   query19	262	171	167	167
   query20	117	128	125	125
   query21	198	109	99	99
   query22	5021	4585	4563	4563
   query23	32109	31610	31768	31610
   query24	11214	2995	2960	2960
   query25	606	373	378	373
   query26	1652	181	178	178
   query27	2788	305	313	305
   query28	6989	2132	2141	2132
   query29	1622	449	408	408
   query30	290	142	152	142
   query31	1063	870	865	865
   query32	155	105	90	90
   query33	834	344	362	344
   query34	869	468	474	468
   query35	1023	819	836	819
   query36	1445	1330	1348	1330
   query37	146	107	117	107
   query38	3582	3347	3365	3347
   query39	1368	1322	1312	1312
   query40	309	101	93	93
   query41	41	36	35	35
   query42	128	117	114	114
   query43	608	556	610	556
   query44	1275	827	846	827
   query45	214	209	207	207
   query46	1063	720	734	720
   query47	1770	1720	1720	1720
   query48	388	271	285	271
   query49	1106	336	321	321
   query50	791	326	326	326
   query51	5575	5417	5425	5417
   query52	118	106	114	106
   query53	244	178	173	173
   query54	1478	704	742	704
   query55	112	104	99	99
   query56	321	290	261	261
   query57	1066	1036	1036	1036
   query58	327	329	311	311
   query59	3281	2983	3089	2983
   query60	389	288	268	268
   query61	154	145	131	131
   query62	624	531	547	531
   query63	224	200	197	197
   query64	5677	1763	1717	1717
   query65	3405	3403	3405	3403
   query66	1234	389	501	389
   query67	16009	15423	15485	15423
   query68	13133	558	547	547
   query69	634	346	367	346
   query70	1947	1799	1755	1755
   query71	587	307	304	304
   query72	5392	3433	3484	3433
   query73	3037	344	336	336
   query74	7022	6666	6693	6666
   query75	5475	2289	2304	2289
   query76	6466	1107	1248	1107
   query77	799	384	349	349
   query78	9167	8848	8678	8678
   query79	2297	554	554	554
   query80	589	356	354	354
   query81	470	217	217	217
   query82	230	148	128	128
   query83	191	148	144	144
   query84	261	58	57	57
   query85	962	289	273	273
   query86	420	451	471	451
   query87	3630	3495	3492	3492
   query88	3076	2531	2427	2427
   query89	407	314	310	310
   query90	1971	271	246	246
   query91	125	96	99	96
   query92	95	109	97	97
   query93	1283	494	429	429
   query94	904	270	263	263
   query95	570	505	520	505
   query96	663	342	338	338
   query97	4390	4228	4221	4221
   query98	263	212	233	212
   query99	1221	917	950	917
   Total cold run time: 302143 ms
   Total hot run time: 186683 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [improvement](cooldown) do not cooldown tablet without cold data [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29690:
URL: https://github.com/apache/doris/pull/29690#issuecomment-1881200704

   clang-tidy review says "All clean, LGTM! :+1:"


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [improvement](cooldown) do not cooldown tablet without cold data [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29690:
URL: https://github.com/apache/doris/pull/29690#issuecomment-1882484827

   PR approved by anyone and no changes requested.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [improvement](cooldown) do not cooldown tablet without cold data [doris]

Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring commented on PR #29690:
URL: https://github.com/apache/doris/pull/29690#issuecomment-1881188130

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [improvement](cooldown) do not cooldown tablet without cold data [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29690:
URL: https://github.com/apache/doris/pull/29690#issuecomment-1882483401

   clang-tidy review says "All clean, LGTM! :+1:"


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [improvement](cooldown) do not cooldown tablet without cold data [doris]

Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring commented on PR #29690:
URL: https://github.com/apache/doris/pull/29690#issuecomment-1883225223

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [improvement](cooldown) do not cooldown tablet without cold data [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29690:
URL: https://github.com/apache/doris/pull/29690#issuecomment-1883312285

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 39443 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 60227afedfeef33e0944dc08f97e16d415bf146c, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	18305	5572	5557	5557
   q2	2035	171	143	143
   q3	10653	1129	1155	1129
   q4	10301	775	825	775
   q5	7803	3053	2947	2947
   q6	204	135	128	128
   q7	919	506	501	501
   q8	9288	2019	2024	2019
   q9	6939	6415	6392	6392
   q10	8231	3054	2966	2966
   q11	444	217	223	217
   q12	388	223	233	223
   q13	18279	3479	3476	3476
   q14	239	220	221	220
   q15	559	512	512	512
   q16	450	384	395	384
   q17	950	750	668	668
   q18	7373	6652	6715	6652
   q19	1605	1522	1515	1515
   q20	711	320	339	320
   q21	2785	2401	2371	2371
   q22	377	328	329	328
   Total cold run time: 108838 ms
   Total hot run time: 39443 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5583	5515	5507	5507
   q2	347	259	266	259
   q3	3360	3342	3302	3302
   q4	2127	2105	2068	2068
   q5	5887	5823	5865	5823
   q6	207	125	125	125
   q7	2305	1957	1896	1896
   q8	3397	3527	3518	3518
   q9	8931	8904	8845	8845
   q10	3804	3850	3895	3850
   q11	603	493	494	493
   q12	808	701	644	644
   q13	6065	3250	3247	3247
   q14	302	275	265	265
   q15	551	511	508	508
   q16	542	488	497	488
   q17	2377	2456	2378	2378
   q18	8682	8703	8513	8513
   q19	1604	1625	1637	1625
   q20	2201	1965	1987	1965
   q21	5513	5450	5194	5194
   q22	628	531	513	513
   Total cold run time: 65824 ms
   Total hot run time: 61026 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [improvement](cooldown) do not cooldown tablet without cold data [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29690:
URL: https://github.com/apache/doris/pull/29690#issuecomment-1883316762

   TeamCity be ut coverage result:
    Function Coverage: 36.67% (8647/23583) 
    Line Coverage: 28.73% (70467/245295)
    Region Coverage: 27.65% (36405/131651)
    Branch Coverage: 24.35% (18620/76458)
    Coverage Report: http://coverage.selectdb-in.cc/coverage/60227afedfeef33e0944dc08f97e16d415bf146c_60227afedfeef33e0944dc08f97e16d415bf146c/report/index.html


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [improvement](cooldown) do not cooldown tablet without cold data [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29690:
URL: https://github.com/apache/doris/pull/29690#issuecomment-1883350275

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 60227afedfeef33e0944dc08f97e16d415bf146c with default session variables
    stream load json:         20 seconds loaded 2358488459 Bytes, about 112 MB/s
    stream load orc:          58 seconds loaded 1101869774 Bytes, about 18 MB/s
    stream load parquet:      32 seconds loaded 861443392 Bytes, about 25 MB/s
    insert into select:       17.9 seconds inserted 10000000 Rows, about 558K ops/s
   ```
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [improvement](cooldown) do not cooldown tablet without cold data [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29690:
URL: https://github.com/apache/doris/pull/29690#issuecomment-1881326971

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 38659 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit cc3bd9020339363cbfe25709fd73861057cb3912, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17682	4969	5011	4969
   q2	2013	158	147	147
   q3	10713	1144	1104	1104
   q4	10376	791	767	767
   q5	7859	2978	2923	2923
   q6	207	125	127	125
   q7	921	528	509	509
   q8	9283	2006	2021	2006
   q9	6484	6507	6384	6384
   q10	8295	3029	3071	3029
   q11	442	235	224	224
   q12	401	234	232	232
   q13	17997	3375	3415	3375
   q14	244	209	206	206
   q15	548	521	502	502
   q16	497	403	423	403
   q17	973	710	516	516
   q18	7225	6667	6688	6667
   q19	1560	1548	1536	1536
   q20	714	300	310	300
   q21	2784	2439	2435	2435
   q22	355	300	305	300
   Total cold run time: 107573 ms
   Total hot run time: 38659 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4955	5009	4959	4959
   q2	344	238	247	238
   q3	3305	3289	3296	3289
   q4	2133	2055	2022	2022
   q5	5784	5774	5758	5758
   q6	206	118	118	118
   q7	2339	1932	1913	1913
   q8	3437	3474	3494	3474
   q9	8838	8782	8806	8782
   q10	3822	3864	3870	3864
   q11	554	465	454	454
   q12	792	627	673	627
   q13	4909	3239	3194	3194
   q14	306	282	262	262
   q15	548	515	503	503
   q16	548	511	494	494
   q17	1899	1876	1876	1876
   q18	8632	8250	8333	8250
   q19	1615	1638	1640	1638
   q20	2203	1961	1974	1961
   q21	5658	5332	5293	5293
   q22	521	451	470	451
   Total cold run time: 63348 ms
   Total hot run time: 59420 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [improvement](cooldown) do not cooldown tablet without cold data [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29690:
URL: https://github.com/apache/doris/pull/29690#issuecomment-1884688695

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


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org