You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "doris-robot (via GitHub)" <gi...@apache.org> on 2024/01/02 13:17:54 UTC

Re: [PR] [improvement](compaction) start 1 cumu compaction thread and 1 base compaction thread each disk [doris]

doris-robot commented on PR #29430:
URL: https://github.com/apache/doris/pull/29430#issuecomment-1874015530

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
   ```
   Tpch sf100 test result on commit e471199b8845e6f37f3cf8bf013796b49f3b3396, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	18661	5465	5158	5158
   q2	2044	161	150	150
   q3	10611	1065	1119	1065
   q4	10248	792	834	792
   q5	7802	2990	2925	2925
   q6	214	138	135	135
   q7	908	515	552	515
   q8	9301	2018	2028	2018
   q9	6837	6400	6345	6345
   q10	8262	3047	2980	2980
   q11	425	220	216	216
   q12	392	243	239	239
   q13	18013	3624	3630	3624
   q14	249	215	210	210
   q15	599	545	541	541
   q16	456	399	420	399
   q17	962	492	549	492
   q18	7530	6748	6723	6723
   q19	1575	1399	1307	1307
   q20	727	347	315	315
   q21	2814	2392	2420	2392
   q22	378	319	360	319
   Total cold run time: 109008 ms
   Total hot run time: 38860 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5150	5064	5084	5064
   q2	339	235	228	228
   q3	3344	3308	3275	3275
   q4	2227	1995	1977	1977
   q5	5806	5756	5803	5756
   q6	217	128	125	125
   q7	2350	1927	1881	1881
   q8	3360	3427	3464	3427
   q9	8904	8851	8883	8851
   q10	3829	3854	3873	3854
   q11	585	482	518	482
   q12	805	639	689	639
   q13	8256	3157	3192	3157
   q14	289	266	272	266
   q15	589	537	530	530
   q16	553	539	506	506
   q17	1935	1749	1755	1749
   q18	8733	8489	8324	8324
   q19	1620	1594	1584	1584
   q20	2210	1971	1969	1969
   q21	5590	5227	5305	5227
   q22	557	518	500	500
   Total cold run time: 67248 ms
   Total hot run time: 59371 ms
   ```
   


-- 
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