Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

branch-3.0: [debug](move-memtable) add debug logs for skip_two_backends injection cases #46826 #46849

Open
wants to merge 1 commit into
base: branch-3.0
Choose a base branch
from

Conversation

github-actions[bot]
Copy link
Contributor

Cherry-picked from #46826

@Thearas
Copy link
Contributor

Thearas commented Jan 12, 2025

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

Please clearly describe your PR:

  1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
  2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
  3. What features were added. Why was this function added?
  4. Which code was refactored and why was this part of the code refactored?
  5. Which functions were optimized and what is the difference before and after the optimization?

@dataroaring dataroaring reopened this Jan 12, 2025
@Thearas
Copy link
Contributor

Thearas commented Jan 12, 2025

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17571	7403	7298	7298
q2	2061	180	165	165
q3	10601	1091	1195	1091
q4	10566	756	748	748
q5	7735	2832	2690	2690
q6	238	147	143	143
q7	973	611	602	602
q8	9343	1997	2037	1997
q9	6600	6444	6492	6444
q10	7068	2298	2321	2298
q11	468	268	267	267
q12	396	221	217	217
q13	18339	3062	3128	3062
q14	257	209	213	209
q15	580	530	509	509
q16	704	621	636	621
q17	1007	570	604	570
q18	7364	6648	6550	6550
q19	1413	1011	983	983
q20	460	199	196	196
q21	4003	3170	3216	3170
q22	1086	995	988	988
Total cold run time: 108833 ms
Total hot run time: 40818 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7276	7240	7286	7240
q2	324	235	231	231
q3	2950	2959	2974	2959
q4	2051	1797	1771	1771
q5	5736	5766	5752	5752
q6	223	146	140	140
q7	2247	1846	1822	1822
q8	3403	3554	3458	3458
q9	8893	8863	8820	8820
q10	3569	3554	3565	3554
q11	594	489	497	489
q12	810	602	623	602
q13	9547	3085	3187	3085
q14	312	269	282	269
q15	580	535	529	529
q16	718	672	651	651
q17	1834	1607	1617	1607
q18	8154	7676	7718	7676
q19	1646	1573	1538	1538
q20	2104	1892	1900	1892
q21	5581	5281	5269	5269
q22	1159	1031	1014	1014
Total cold run time: 69711 ms
Total hot run time: 60368 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 198866 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 1847aab93f550732ec5d9b20344d7396f736bfa0, data reload: false

query1	1294	934	928	928
query2	6212	2023	2054	2023
query3	10823	4244	4427	4244
query4	66202	29223	23760	23760
query5	4954	455	455	455
query6	396	184	183	183
query7	5546	312	313	312
query8	295	219	219	219
query9	8944	2670	2677	2670
query10	453	262	247	247
query11	17308	15334	15941	15334
query12	148	102	102	102
query13	1521	446	429	429
query14	9742	7745	7524	7524
query15	205	173	190	173
query16	7168	553	495	495
query17	1121	589	588	588
query18	1913	311	311	311
query19	213	169	155	155
query20	119	109	109	109
query21	211	103	102	102
query22	4859	4616	4515	4515
query23	34692	34307	34411	34307
query24	6082	2902	2959	2902
query25	507	396	393	393
query26	689	163	168	163
query27	1956	345	357	345
query28	4119	2462	2478	2462
query29	697	461	456	456
query30	237	162	164	162
query31	980	797	848	797
query32	77	57	57	57
query33	441	289	290	289
query34	924	516	538	516
query35	848	768	725	725
query36	1082	975	967	967
query37	120	76	76	76
query38	4065	3923	3968	3923
query39	1533	1650	1460	1460
query40	212	108	101	101
query41	53	51	51	51
query42	117	103	106	103
query43	527	489	483	483
query44	1163	807	839	807
query45	187	177	177	177
query46	1170	752	742	742
query47	2025	1939	1954	1939
query48	503	407	405	405
query49	764	408	411	408
query50	852	422	431	422
query51	7442	7281	7312	7281
query52	102	89	90	89
query53	266	183	183	183
query54	559	447	458	447
query55	77	81	79	79
query56	291	262	254	254
query57	1233	1123	1140	1123
query58	221	207	221	207
query59	3181	2993	2977	2977
query60	296	256	267	256
query61	190	108	110	108
query62	765	704	659	659
query63	211	197	198	197
query64	1370	674	640	640
query65	3270	3217	3202	3202
query66	703	298	294	294
query67	15816	15681	15571	15571
query68	3979	566	572	566
query69	426	263	265	263
query70	1215	1125	1089	1089
query71	350	248	254	248
query72	6374	4116	4000	4000
query73	755	358	361	358
query74	10281	9215	9287	9215
query75	3362	2630	2691	2630
query76	1986	1108	1105	1105
query77	507	263	264	263
query78	10537	9709	9582	9582
query79	1939	589	604	589
query80	1257	417	417	417
query81	541	244	243	243
query82	521	147	118	118
query83	173	138	149	138
query84	282	82	83	82
query85	990	312	296	296
query86	414	300	299	299
query87	4375	4356	4238	4238
query88	4134	2377	2353	2353
query89	420	297	292	292
query90	1988	188	184	184
query91	181	152	151	151
query92	71	48	52	48
query93	2601	548	542	542
query94	910	311	290	290
query95	351	240	251	240
query96	623	278	280	278
query97	3359	3181	3190	3181
query98	217	208	197	197
query99	1638	1340	1288	1288
Total cold run time: 319019 ms
Total hot run time: 198866 ms

@doris-robot
Copy link

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

query1	0.04	0.03	0.03
query2	0.06	0.03	0.03
query3	0.23	0.07	0.06
query4	1.63	0.10	0.11
query5	0.52	0.51	0.51
query6	1.13	0.72	0.72
query7	0.02	0.01	0.01
query8	0.04	0.05	0.03
query9	0.56	0.52	0.50
query10	0.55	0.55	0.55
query11	0.13	0.10	0.10
query12	0.14	0.11	0.11
query13	0.62	0.59	0.59
query14	3.00	2.90	3.00
query15	0.91	0.83	0.83
query16	0.38	0.38	0.38
query17	1.02	1.04	1.08
query18	0.24	0.22	0.22
query19	1.93	1.89	1.99
query20	0.01	0.01	0.02
query21	15.36	0.58	0.57
query22	2.81	1.95	2.56
query23	16.92	0.99	1.01
query24	3.33	1.21	1.15
query25	0.11	0.14	0.09
query26	0.64	0.13	0.13
query27	0.04	0.04	0.04
query28	10.06	1.12	1.07
query29	12.58	3.22	3.21
query30	0.24	0.06	0.06
query31	2.87	0.38	0.38
query32	3.24	0.48	0.47
query33	2.99	3.04	2.99
query34	16.60	4.48	4.46
query35	4.50	4.51	4.49
query36	0.68	0.49	0.50
query37	0.09	0.07	0.06
query38	0.04	0.03	0.03
query39	0.03	0.02	0.03
query40	0.16	0.12	0.12
query41	0.08	0.03	0.02
query42	0.03	0.02	0.02
query43	0.04	0.03	0.03
Total cold run time: 106.6 s
Total hot run time: 33.45 s

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

4 participants