You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "morningman (via GitHub)" <gi...@apache.org> on 2025/05/28 05:26:56 UTC

[PR] [opt](audit) add new variable audit_plugin_max_insert_stmt_length to … [doris]

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

   …limit the length of insert stmt
   
   ### What problem does this PR solve?
   
   Issue Number: close #xxx
   
   Related PR: #xxx
   
   Problem Summary:
   
   ### Release note
   
   None
   
   ### Check List (For Author)
   
   - Test <!-- At least one of them must be included. -->
       - [ ] Regression test
       - [ ] Unit Test
       - [ ] Manual test (add detailed scripts or steps below)
       - [ ] No need to test or manual test. Explain why:
           - [ ] This is a refactor/code format and no logic has been changed.
           - [ ] Previous test can cover this change.
           - [ ] No code files have been changed.
           - [ ] Other reason <!-- Add your reason?  -->
   
   - Behavior changed:
       - [ ] No.
       - [ ] Yes. <!-- Explain the behavior change -->
   
   - Does this need documentation?
       - [ ] No.
       - [ ] Yes. <!-- Add document PR link here. eg: https://github.com/apache/doris-website/pull/1214 -->
   
   ### Check List (For Reviewer who merge this PR)
   
   - [ ] Confirm the release note
   - [ ] Confirm test cases
   - [ ] Confirm document
   - [ ] Add branch pick label <!-- Add branch pick label that this PR should merge into -->
   
   


-- 
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] [opt](audit) add new variable audit_plugin_max_insert_stmt_length to limit the length of insert stmt [doris]

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

   
   Thank you for your contribution to Apache Doris.
   Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/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?
       


-- 
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] [opt](audit) add new variable audit_plugin_max_insert_stmt_length to limit the length of insert stmt [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 29.13 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 8b279633240262dbc8598c75bf9ab0ce49968d59, data reload: false
   
   query1	0.04	0.05	0.03
   query2	0.13	0.10	0.11
   query3	0.25	0.19	0.19
   query4	1.59	0.20	0.20
   query5	0.45	0.45	0.45
   query6	1.15	0.66	0.66
   query7	0.02	0.01	0.02
   query8	0.05	0.03	0.04
   query9	0.59	0.52	0.52
   query10	0.58	0.57	0.57
   query11	0.15	0.11	0.11
   query12	0.14	0.12	0.11
   query13	0.62	0.60	0.61
   query14	0.80	0.80	0.81
   query15	0.87	0.84	0.86
   query16	0.39	0.38	0.38
   query17	1.02	1.03	1.01
   query18	0.22	0.20	0.21
   query19	1.94	1.88	1.84
   query20	0.01	0.01	0.01
   query21	15.39	0.90	0.53
   query22	0.75	1.26	0.76
   query23	14.76	1.42	0.68
   query24	7.27	0.71	1.40
   query25	0.51	0.21	0.09
   query26	0.50	0.16	0.14
   query27	0.05	0.05	0.04
   query28	9.49	0.91	0.44
   query29	12.60	3.94	3.29
   query30	0.28	0.10	0.06
   query31	2.80	0.57	0.39
   query32	3.23	0.54	0.47
   query33	3.02	3.11	3.12
   query34	15.80	5.10	4.49
   query35	4.49	4.51	4.46
   query36	0.65	0.49	0.48
   query37	0.09	0.07	0.06
   query38	0.05	0.05	0.04
   query39	0.04	0.03	0.02
   query40	0.17	0.15	0.13
   query41	0.09	0.03	0.03
   query42	0.03	0.03	0.02
   query43	0.04	0.03	0.03
   Total cold run time: 103.11 s
   Total hot run time: 29.13 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] [opt](audit) add new variable audit_plugin_max_insert_stmt_length to limit the length of insert stmt [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 192728 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 34637514e21360ae1a6eb3a39721f4e3fe17a2d2, data reload: false
   
   query1	1406	1088	1048	1048
   query2	6384	1813	1811	1811
   query3	10996	4590	4469	4469
   query4	53977	25629	23133	23133
   query5	5000	514	466	466
   query6	368	209	205	205
   query7	4942	533	295	295
   query8	298	243	229	229
   query9	5853	2681	2672	2672
   query10	446	343	277	277
   query11	15005	15423	14797	14797
   query12	160	108	105	105
   query13	1064	539	421	421
   query14	10150	6333	6527	6333
   query15	193	224	197	197
   query16	7081	640	519	519
   query17	1129	715	564	564
   query18	1534	407	313	313
   query19	207	225	164	164
   query20	129	125	124	124
   query21	199	122	103	103
   query22	4431	4335	4331	4331
   query23	34264	33697	33625	33625
   query24	6705	2470	2442	2442
   query25	486	492	418	418
   query26	735	272	156	156
   query27	2416	510	341	341
   query28	3049	2201	2187	2187
   query29	591	571	433	433
   query30	271	218	189	189
   query31	872	861	784	784
   query32	72	68	61	61
   query33	464	365	311	311
   query34	794	872	539	539
   query35	822	835	792	792
   query36	950	992	917	917
   query37	113	100	91	91
   query38	4341	4380	4210	4210
   query39	1528	1447	1435	1435
   query40	217	142	117	117
   query41	63	56	57	56
   query42	135	118	117	117
   query43	506	518	484	484
   query44	1372	856	872	856
   query45	179	172	169	169
   query46	855	1037	652	652
   query47	1829	1896	1779	1779
   query48	397	441	346	346
   query49	683	493	416	416
   query50	659	697	420	420
   query51	4252	4289	4259	4259
   query52	117	110	105	105
   query53	239	262	186	186
   query54	584	588	532	532
   query55	86	88	89	88
   query56	300	300	307	300
   query57	1204	1239	1097	1097
   query58	274	268	257	257
   query59	2681	2805	2643	2643
   query60	327	320	313	313
   query61	130	132	157	132
   query62	737	744	650	650
   query63	246	185	184	184
   query64	1809	1058	702	702
   query65	4220	4176	4176	4176
   query66	729	393	305	305
   query67	16037	15705	15257	15257
   query68	7148	902	538	538
   query69	545	320	263	263
   query70	1214	1112	1117	1112
   query71	489	318	307	307
   query72	5995	4839	5089	4839
   query73	1401	714	357	357
   query74	8999	9112	8647	8647
   query75	3863	3197	2707	2707
   query76	4302	1200	784	784
   query77	635	378	298	298
   query78	9934	10115	9367	9367
   query79	2338	837	598	598
   query80	621	521	528	521
   query81	498	252	221	221
   query82	421	128	97	97
   query83	346	246	235	235
   query84	290	113	93	93
   query85	810	366	328	328
   query86	380	302	280	280
   query87	4390	4430	4342	4342
   query88	3454	2345	2318	2318
   query89	412	311	282	282
   query90	1949	216	216	216
   query91	144	150	121	121
   query92	79	64	61	61
   query93	1660	977	590	590
   query94	668	397	320	320
   query95	375	295	293	293
   query96	514	581	285	285
   query97	2771	2757	2670	2670
   query98	239	213	207	207
   query99	1432	1414	1326	1326
   Total cold run time: 298608 ms
   Total hot run time: 192728 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] [opt](audit) add new variable audit_plugin_max_insert_stmt_length to limit the length of insert stmt [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 193095 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 8b279633240262dbc8598c75bf9ab0ce49968d59, data reload: false
   
   query1	1427	1098	1070	1070
   query2	6415	1856	1869	1856
   query3	11034	4589	4451	4451
   query4	52389	26211	23434	23434
   query5	4968	629	493	493
   query6	329	219	220	219
   query7	4866	531	295	295
   query8	305	262	232	232
   query9	5642	2676	2669	2669
   query10	458	330	292	292
   query11	15082	15123	14824	14824
   query12	161	109	109	109
   query13	1039	517	412	412
   query14	10240	6343	6378	6343
   query15	214	203	190	190
   query16	7129	687	494	494
   query17	1116	756	622	622
   query18	1592	416	322	322
   query19	212	195	185	185
   query20	132	135	121	121
   query21	206	125	111	111
   query22	4403	4488	4183	4183
   query23	34397	33669	33981	33669
   query24	6560	2432	2483	2432
   query25	483	479	404	404
   query26	713	268	164	164
   query27	2307	523	373	373
   query28	3040	2202	2168	2168
   query29	592	575	447	447
   query30	274	222	191	191
   query31	888	859	771	771
   query32	74	66	65	65
   query33	475	394	298	298
   query34	788	884	559	559
   query35	782	818	755	755
   query36	968	1009	882	882
   query37	114	108	84	84
   query38	4311	4286	4242	4242
   query39	1527	1456	1481	1456
   query40	205	124	110	110
   query41	63	60	57	57
   query42	133	107	109	107
   query43	548	537	476	476
   query44	1397	866	852	852
   query45	179	181	170	170
   query46	887	1049	692	692
   query47	1838	1869	1802	1802
   query48	415	439	325	325
   query49	687	484	414	414
   query50	661	704	411	411
   query51	4280	4225	4286	4225
   query52	116	115	98	98
   query53	228	268	199	199
   query54	565	585	516	516
   query55	92	89	80	80
   query56	345	297	291	291
   query57	1188	1230	1160	1160
   query58	271	270	264	264
   query59	2629	2798	2620	2620
   query60	321	334	318	318
   query61	123	120	120	120
   query62	792	720	666	666
   query63	225	185	190	185
   query64	1775	1028	678	678
   query65	4237	4159	4182	4159
   query66	714	408	308	308
   query67	15938	15684	15474	15474
   query68	6967	905	537	537
   query69	548	307	267	267
   query70	1223	1077	1106	1077
   query71	514	340	296	296
   query72	5752	4958	4655	4655
   query73	1446	610	357	357
   query74	9308	9216	8669	8669
   query75	4156	3200	2702	2702
   query76	4297	1220	809	809
   query77	768	384	298	298
   query78	10289	10124	9468	9468
   query79	2349	827	575	575
   query80	584	514	473	473
   query81	472	260	221	221
   query82	422	119	93	93
   query83	284	253	228	228
   query84	297	114	93	93
   query85	775	351	318	318
   query86	360	308	287	287
   query87	4391	4480	4355	4355
   query88	3455	2336	2293	2293
   query89	405	319	285	285
   query90	2001	209	214	209
   query91	141	134	116	116
   query92	70	65	57	57
   query93	1646	955	579	579
   query94	662	402	308	308
   query95	369	284	291	284
   query96	502	569	286	286
   query97	2770	2800	2738	2738
   query98	227	227	212	212
   query99	1457	1416	1286	1286
   Total cold run time: 297411 ms
   Total hot run time: 193095 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] [opt](audit) add new variable audit_plugin_max_insert_stmt_length to limit the length of insert stmt [doris]

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


-- 
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] [opt](audit) add new variable audit_plugin_max_insert_stmt_length to limit the length of insert stmt [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 33634 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 34637514e21360ae1a6eb3a39721f4e3fe17a2d2, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	26229	4936	5026	4936
   q2	1954	276	185	185
   q3	10291	1231	666	666
   q4	10234	1008	525	525
   q5	7554	2391	2302	2302
   q6	182	161	132	132
   q7	911	719	613	613
   q8	9300	1263	1123	1123
   q9	6779	5066	5112	5066
   q10	6899	2329	1890	1890
   q11	486	288	280	280
   q12	359	346	216	216
   q13	17772	3697	3068	3068
   q14	237	244	215	215
   q15	565	502	490	490
   q16	432	439	370	370
   q17	604	848	368	368
   q18	7798	7265	7052	7052
   q19	1609	974	589	589
   q20	338	339	229	229
   q21	3757	3159	2365	2365
   q22	1018	1008	954	954
   Total cold run time: 115308 ms
   Total hot run time: 33634 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5121	5057	5052	5052
   q2	236	318	219	219
   q3	2163	2693	2313	2313
   q4	1349	1738	1299	1299
   q5	4408	4374	4425	4374
   q6	210	175	130	130
   q7	2012	1936	1781	1781
   q8	2574	2597	2514	2514
   q9	7204	7232	7003	7003
   q10	3006	3182	2736	2736
   q11	565	521	501	501
   q12	673	748	591	591
   q13	3490	3961	3297	3297
   q14	276	309	279	279
   q15	532	491	479	479
   q16	448	484	459	459
   q17	1160	1542	1406	1406
   q18	7794	7610	7509	7509
   q19	821	802	830	802
   q20	2007	2002	1837	1837
   q21	4909	4569	4393	4393
   q22	1078	1027	990	990
   Total cold run time: 52036 ms
   Total hot run time: 49964 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] [opt](audit) add new variable audit_plugin_max_insert_stmt_length to limit the length of insert stmt [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 29.18 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 34637514e21360ae1a6eb3a39721f4e3fe17a2d2, data reload: false
   
   query1	0.04	0.03	0.03
   query2	0.13	0.10	0.11
   query3	0.25	0.19	0.19
   query4	1.59	0.20	0.12
   query5	0.46	0.41	0.43
   query6	1.19	0.66	0.67
   query7	0.02	0.02	0.02
   query8	0.05	0.03	0.04
   query9	0.59	0.53	0.52
   query10	0.58	0.58	0.57
   query11	0.16	0.11	0.11
   query12	0.14	0.12	0.12
   query13	0.62	0.61	0.61
   query14	0.77	0.80	0.80
   query15	0.88	0.87	0.87
   query16	0.37	0.39	0.40
   query17	1.05	1.05	1.08
   query18	0.23	0.21	0.21
   query19	1.93	1.86	1.81
   query20	0.01	0.01	0.02
   query21	15.40	0.87	0.53
   query22	0.76	1.11	0.70
   query23	15.07	1.37	0.64
   query24	7.09	1.05	0.84
   query25	0.44	0.22	0.14
   query26	0.64	0.15	0.14
   query27	0.06	0.06	0.05
   query28	9.24	0.89	0.46
   query29	12.54	3.95	3.23
   query30	0.26	0.09	0.07
   query31	2.82	0.62	0.38
   query32	3.23	0.57	0.47
   query33	3.16	3.05	3.13
   query34	15.61	5.12	4.54
   query35	4.48	4.51	4.50
   query36	0.67	0.54	0.49
   query37	0.09	0.07	0.07
   query38	0.05	0.04	0.03
   query39	0.04	0.03	0.02
   query40	0.18	0.14	0.13
   query41	0.09	0.03	0.02
   query42	0.03	0.02	0.02
   query43	0.03	0.03	0.03
   Total cold run time: 103.04 s
   Total hot run time: 29.18 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] [opt](audit) add new variable audit_plugin_max_insert_stmt_length to limit the length of insert stmt [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 191814 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 bf39e149ef47be74ba3a19a389f5d3ef54627ebf, data reload: false
   
   query1	1402	1092	1049	1049
   query2	6262	1819	1770	1770
   query3	10987	4312	4504	4312
   query4	54455	25851	23062	23062
   query5	5079	507	454	454
   query6	370	222	199	199
   query7	4948	503	291	291
   query8	347	259	248	248
   query9	6010	2606	2614	2606
   query10	454	339	279	279
   query11	14995	14997	14797	14797
   query12	163	118	110	110
   query13	1079	525	410	410
   query14	10011	6230	6283	6230
   query15	215	200	181	181
   query16	7044	639	468	468
   query17	1107	740	603	603
   query18	1516	400	310	310
   query19	206	183	165	165
   query20	137	124	122	122
   query21	202	127	111	111
   query22	4363	4391	4237	4237
   query23	34662	33665	33400	33400
   query24	6567	2446	2435	2435
   query25	474	481	410	410
   query26	675	267	161	161
   query27	2254	520	345	345
   query28	3160	2172	2174	2172
   query29	568	566	437	437
   query30	273	226	195	195
   query31	896	839	792	792
   query32	80	69	66	66
   query33	460	372	333	333
   query34	788	873	537	537
   query35	834	847	766	766
   query36	942	987	885	885
   query37	118	102	75	75
   query38	4307	4240	4186	4186
   query39	1522	1461	1481	1461
   query40	214	121	111	111
   query41	61	68	59	59
   query42	164	119	110	110
   query43	500	504	488	488
   query44	1326	855	840	840
   query45	178	176	173	173
   query46	834	1031	638	638
   query47	1813	1850	1819	1819
   query48	395	429	333	333
   query49	682	525	442	442
   query50	646	703	405	405
   query51	4277	4312	4247	4247
   query52	114	106	102	102
   query53	229	265	192	192
   query54	580	580	525	525
   query55	86	89	88	88
   query56	312	309	305	305
   query57	1186	1200	1113	1113
   query58	273	259	267	259
   query59	2639	2770	2555	2555
   query60	361	353	319	319
   query61	160	163	158	158
   query62	744	739	701	701
   query63	229	199	199	199
   query64	1601	1127	703	703
   query65	4293	4240	4254	4240
   query66	745	395	314	314
   query67	16252	15704	15447	15447
   query68	7390	874	519	519
   query69	537	307	260	260
   query70	1160	1077	1069	1069
   query71	512	324	303	303
   query72	5512	4840	4783	4783
   query73	1344	634	362	362
   query74	9224	9101	8733	8733
   query75	3820	3202	2723	2723
   query76	4324	1189	755	755
   query77	621	374	280	280
   query78	10122	10379	9328	9328
   query79	1210	821	575	575
   query80	791	513	470	470
   query81	488	252	220	220
   query82	310	134	96	96
   query83	376	259	233	233
   query84	281	110	91	91
   query85	744	359	333	333
   query86	334	278	283	278
   query87	4361	4458	4392	4392
   query88	2943	2262	2247	2247
   query89	451	313	291	291
   query90	2027	208	206	206
   query91	140	140	115	115
   query92	77	62	55	55
   query93	1157	935	573	573
   query94	713	412	311	311
   query95	366	294	286	286
   query96	490	575	280	280
   query97	2676	2759	2646	2646
   query98	234	223	196	196
   query99	1430	1385	1250	1250
   Total cold run time: 296991 ms
   Total hot run time: 191814 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] [opt](audit) add new variable audit_plugin_max_insert_stmt_length to limit the length of insert stmt [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 33432 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 476729b952afbd78542da984ab621977acff238f, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	25567	5018	5000	5000
   q2	1970	266	169	169
   q3	10522	1208	670	670
   q4	10259	998	546	546
   q5	7659	2316	2360	2316
   q6	177	158	130	130
   q7	918	707	602	602
   q8	9308	1256	998	998
   q9	6686	5122	5073	5073
   q10	6788	2310	1862	1862
   q11	490	287	261	261
   q12	347	358	209	209
   q13	17768	3681	3044	3044
   q14	232	220	216	216
   q15	566	492	482	482
   q16	411	420	368	368
   q17	582	820	350	350
   q18	7464	7135	7141	7135
   q19	1641	938	536	536
   q20	321	330	215	215
   q21	3695	3206	2311	2311
   q22	1048	987	939	939
   Total cold run time: 114419 ms
   Total hot run time: 33432 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5133	5045	5084	5045
   q2	233	319	221	221
   q3	2169	2639	2280	2280
   q4	1323	1792	1353	1353
   q5	4400	4315	4371	4315
   q6	212	170	127	127
   q7	1989	1891	1768	1768
   q8	2548	2542	2465	2465
   q9	7060	7154	7021	7021
   q10	2927	3263	2756	2756
   q11	602	497	493	493
   q12	683	758	612	612
   q13	3489	3874	3266	3266
   q14	273	305	271	271
   q15	546	483	486	483
   q16	449	484	468	468
   q17	1132	1483	1389	1389
   q18	7739	7518	7348	7348
   q19	790	792	823	792
   q20	1991	2043	1889	1889
   q21	4754	4390	4353	4353
   q22	1079	1031	1006	1006
   Total cold run time: 51521 ms
   Total hot run time: 49721 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] [opt](audit) add new variable audit_plugin_max_insert_stmt_length to limit the length of insert stmt [doris]

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

   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] [opt](audit) add new variable audit_plugin_max_insert_stmt_length to limit the length of insert stmt [doris]

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

   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


Re: [PR] [opt](audit) add new variable audit_plugin_max_insert_stmt_length to limit the length of insert stmt [doris]

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

   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] [opt](audit) add new variable audit_plugin_max_insert_stmt_length to limit the length of insert stmt [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 28.97 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 bf39e149ef47be74ba3a19a389f5d3ef54627ebf, data reload: false
   
   query1	0.04	0.04	0.03
   query2	0.13	0.10	0.11
   query3	0.25	0.20	0.19
   query4	1.60	0.20	0.11
   query5	0.43	0.41	0.42
   query6	1.19	0.67	0.66
   query7	0.02	0.01	0.01
   query8	0.04	0.04	0.04
   query9	0.57	0.52	0.51
   query10	0.57	0.58	0.57
   query11	0.15	0.11	0.11
   query12	0.14	0.11	0.11
   query13	0.62	0.61	0.59
   query14	0.78	0.81	0.80
   query15	0.88	0.86	0.88
   query16	0.38	0.38	0.39
   query17	1.06	1.05	1.06
   query18	0.23	0.21	0.21
   query19	1.96	1.81	1.81
   query20	0.01	0.01	0.01
   query21	15.41	0.92	0.54
   query22	0.76	1.33	0.98
   query23	14.71	1.36	0.67
   query24	7.09	1.63	0.34
   query25	0.44	0.15	0.12
   query26	0.64	0.17	0.15
   query27	0.06	0.04	0.04
   query28	9.77	0.91	0.44
   query29	12.53	4.01	3.28
   query30	0.25	0.10	0.07
   query31	2.82	0.61	0.39
   query32	3.23	0.57	0.47
   query33	2.96	3.16	3.09
   query34	15.75	5.09	4.53
   query35	4.59	4.51	4.48
   query36	0.67	0.50	0.49
   query37	0.09	0.07	0.06
   query38	0.04	0.04	0.04
   query39	0.04	0.02	0.03
   query40	0.17	0.14	0.13
   query41	0.08	0.03	0.03
   query42	0.03	0.02	0.03
   query43	0.04	0.03	0.03
   Total cold run time: 103.22 s
   Total hot run time: 28.97 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] [opt](audit) add new variable audit_plugin_max_insert_stmt_length to limit the length of insert stmt [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 192034 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 476729b952afbd78542da984ab621977acff238f, data reload: false
   
   query1	1399	1067	1075	1067
   query2	6285	1792	1808	1792
   query3	11287	4407	4508	4407
   query4	54636	25586	22861	22861
   query5	5009	562	465	465
   query6	349	224	196	196
   query7	4891	521	291	291
   query8	279	244	224	224
   query9	5390	2621	2623	2621
   query10	451	327	264	264
   query11	14991	15006	14811	14811
   query12	156	111	111	111
   query13	1024	519	410	410
   query14	10121	6136	6192	6136
   query15	203	196	187	187
   query16	7094	646	474	474
   query17	1086	750	614	614
   query18	1556	421	312	312
   query19	195	190	172	172
   query20	132	121	119	119
   query21	209	121	105	105
   query22	4305	4562	4378	4378
   query23	34241	33644	33443	33443
   query24	6673	2400	2432	2400
   query25	465	454	403	403
   query26	703	276	153	153
   query27	2256	537	355	355
   query28	3025	2173	2163	2163
   query29	578	585	468	468
   query30	271	216	190	190
   query31	852	861	795	795
   query32	73	67	64	64
   query33	452	354	321	321
   query34	780	862	533	533
   query35	795	858	756	756
   query36	917	993	911	911
   query37	105	103	82	82
   query38	4169	4406	4321	4321
   query39	1506	1456	1469	1456
   query40	204	124	109	109
   query41	65	62	53	53
   query42	140	108	109	108
   query43	495	475	487	475
   query44	1335	844	857	844
   query45	193	176	169	169
   query46	860	1025	671	671
   query47	1851	1868	1845	1845
   query48	404	428	314	314
   query49	647	465	427	427
   query50	651	688	404	404
   query51	4308	4221	4270	4221
   query52	117	114	99	99
   query53	234	260	189	189
   query54	577	588	521	521
   query55	83	83	82	82
   query56	296	308	293	293
   query57	1185	1184	1153	1153
   query58	282	278	267	267
   query59	2691	2800	2657	2657
   query60	364	328	312	312
   query61	128	128	127	127
   query62	751	758	684	684
   query63	226	188	190	188
   query64	1697	1033	688	688
   query65	4206	4168	4101	4101
   query66	745	407	298	298
   query67	16036	15639	15567	15567
   query68	6958	883	525	525
   query69	531	317	267	267
   query70	1207	1102	1077	1077
   query71	514	314	322	314
   query72	5686	4791	4722	4722
   query73	1478	598	356	356
   query74	8841	8879	8903	8879
   query75	3941	3174	2722	2722
   query76	4102	1184	747	747
   query77	667	368	284	284
   query78	10071	10174	9432	9432
   query79	2001	805	576	576
   query80	585	513	441	441
   query81	472	252	221	221
   query82	417	126	94	94
   query83	255	253	333	253
   query84	284	112	93	93
   query85	789	354	307	307
   query86	354	290	265	265
   query87	4366	4454	4270	4270
   query88	3606	2276	2290	2276
   query89	397	330	280	280
   query90	1900	207	204	204
   query91	147	141	114	114
   query92	71	62	56	56
   query93	1358	930	586	586
   query94	665	406	301	301
   query95	370	288	280	280
   query96	493	567	284	284
   query97	2757	2756	2654	2654
   query98	231	211	197	197
   query99	1499	1415	1260	1260
   Total cold run time: 296693 ms
   Total hot run time: 192034 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] [opt](audit) add new variable audit_plugin_max_insert_stmt_length to limit the length of insert stmt [doris]

Posted by "gavinchou (via GitHub)" <gi...@apache.org>.
gavinchou commented on code in PR #51314:
URL: https://github.com/apache/doris/pull/51314#discussion_r2115089169


##########
fe/fe-core/src/main/java/org/apache/doris/qe/AuditLogHelper.java:
##########
@@ -122,12 +130,19 @@ public static String handleStmt(String origStmt, StatementBase parsedStmt) {
             }
         }
         if (rowCnt > 0) {
-            return origStmt + " ... /* total " + rowCnt + " rows, truncated audit_plugin_max_sql_length="
-                + GlobalVariable.auditPluginMaxSqlLength + " */";
+            // This is an insert statement.
+            int maxLen = GlobalVariable.auditPluginMaxInsertStmtLength <= 0

Review Comment:
   making `maxlen = max(0, min(insert_sql_len, max_sql_len));` seems more straightforward.
   no need to consider 0 or negative value for auditPluginMaxInsertStmtLength (default INT.MAX)



-- 
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] [opt](audit) add new variable audit_plugin_max_insert_stmt_length to limit the length of insert stmt [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 28.93 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 476729b952afbd78542da984ab621977acff238f, data reload: false
   
   query1	0.04	0.04	0.03
   query2	0.13	0.10	0.11
   query3	0.26	0.19	0.20
   query4	1.59	0.20	0.11
   query5	0.42	0.41	0.41
   query6	1.17	0.65	0.66
   query7	0.02	0.02	0.02
   query8	0.05	0.04	0.03
   query9	0.58	0.51	0.51
   query10	0.56	0.57	0.57
   query11	0.15	0.11	0.11
   query12	0.15	0.12	0.13
   query13	0.62	0.60	0.60
   query14	0.79	0.80	0.81
   query15	0.87	0.85	0.85
   query16	0.38	0.38	0.38
   query17	1.00	1.04	1.06
   query18	0.23	0.21	0.21
   query19	1.90	1.86	1.84
   query20	0.02	0.01	0.01
   query21	15.39	0.89	0.54
   query22	0.76	1.30	0.90
   query23	14.72	1.37	0.66
   query24	7.42	1.26	0.54
   query25	0.46	0.21	0.08
   query26	0.61	0.16	0.13
   query27	0.05	0.05	0.05
   query28	9.70	0.89	0.45
   query29	12.54	3.96	3.30
   query30	0.27	0.10	0.07
   query31	2.81	0.57	0.38
   query32	3.23	0.54	0.47
   query33	3.05	3.00	3.11
   query34	15.72	5.13	4.48
   query35	4.54	4.49	4.50
   query36	0.65	0.49	0.49
   query37	0.09	0.06	0.06
   query38	0.05	0.04	0.03
   query39	0.03	0.03	0.02
   query40	0.16	0.14	0.14
   query41	0.08	0.03	0.02
   query42	0.03	0.02	0.03
   query43	0.04	0.03	0.03
   Total cold run time: 103.33 s
   Total hot run time: 28.93 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] [opt](audit) add new variable audit_plugin_max_insert_stmt_length to limit the length of insert stmt [doris]

Posted by "gavinchou (via GitHub)" <gi...@apache.org>.
gavinchou commented on code in PR #51314:
URL: https://github.com/apache/doris/pull/51314#discussion_r2115089748


##########
fe/fe-core/src/main/java/org/apache/doris/qe/GlobalVariable.java:
##########
@@ -154,6 +155,14 @@ public final class GlobalVariable {
     @VariableMgr.VarAttr(name = AUDIT_PLUGIN_MAX_SQL_LENGTH, flag = VariableMgr.GLOBAL)
     public static int auditPluginMaxSqlLength = 4096;
 
+    @VariableMgr.VarAttr(name = AUDIT_PLUGIN_MAX_INSERT_STMT_LENGTH, flag = VariableMgr.GLOBAL,
+            description = {"专门用于限制 INSERT 语句的长度。设置为 <= 0,则使用 AUDIT_PLUGIN_MAX_SQL_LENGTH 的值。"
+                    + "如果 INSERT 语句超过该长度,将会被截断。",
+                    "This is specifically used to limit the length of INSERT statements. "
+                            + "Set to a <= 0 value to use the value of AUDIT_PLUGIN_MAX_SQL_LENGTH. "
+                            + "If an INSERT statement exceeds this length, it will be truncated."})
+    public static int auditPluginMaxInsertStmtLength = -1;

Review Comment:
   better to make it default to INT.MAX



-- 
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] [opt](audit) add new variable audit_plugin_max_insert_stmt_length to limit the length of insert stmt [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 33830 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 8b279633240262dbc8598c75bf9ab0ce49968d59, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	26632	5022	5126	5022
   q2	1955	271	194	194
   q3	10280	1245	687	687
   q4	10240	989	519	519
   q5	7538	2332	2385	2332
   q6	177	162	133	133
   q7	914	737	604	604
   q8	9313	1286	1127	1127
   q9	6737	5095	5155	5095
   q10	6870	2318	1909	1909
   q11	488	288	274	274
   q12	345	354	213	213
   q13	17790	3646	3170	3170
   q14	239	240	220	220
   q15	567	471	501	471
   q16	442	429	372	372
   q17	597	878	364	364
   q18	7728	7259	7051	7051
   q19	2169	1050	559	559
   q20	328	339	221	221
   q21	3607	3239	2321	2321
   q22	1043	1024	972	972
   Total cold run time: 115999 ms
   Total hot run time: 33830 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5229	4999	5072	4999
   q2	241	318	221	221
   q3	2182	2667	2284	2284
   q4	1372	1863	1466	1466
   q5	4458	4508	4397	4397
   q6	218	169	126	126
   q7	2026	1924	1758	1758
   q8	2591	2708	2587	2587
   q9	7269	7144	7205	7144
   q10	2994	3167	2763	2763
   q11	597	523	506	506
   q12	662	761	605	605
   q13	3505	3903	3347	3347
   q14	293	306	271	271
   q15	514	473	463	463
   q16	441	499	435	435
   q17	1251	1564	1407	1407
   q18	7866	7592	7425	7425
   q19	798	820	833	820
   q20	1989	2017	1850	1850
   q21	4768	4568	4551	4551
   q22	1132	1058	1026	1026
   Total cold run time: 52396 ms
   Total hot run time: 50451 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] [opt](audit) add new variable audit_plugin_max_insert_stmt_length to limit the length of insert stmt [doris]

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

   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] [opt](audit) add new variable audit_plugin_max_insert_stmt_length to limit the length of insert stmt [doris]

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

   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] [opt](audit) add new variable audit_plugin_max_insert_stmt_length to limit the length of insert stmt [doris]

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

   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] [opt](audit) add new variable audit_plugin_max_insert_stmt_length to limit the length of insert stmt [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 33803 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 bf39e149ef47be74ba3a19a389f5d3ef54627ebf, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	26174	4995	4998	4995
   q2	2069	283	203	203
   q3	10478	1263	682	682
   q4	10221	1012	504	504
   q5	7655	2350	2366	2350
   q6	179	162	132	132
   q7	904	729	602	602
   q8	9332	1265	1082	1082
   q9	6851	5125	5087	5087
   q10	6814	2304	1904	1904
   q11	498	285	271	271
   q12	343	351	210	210
   q13	17766	3705	3060	3060
   q14	232	222	208	208
   q15	534	480	497	480
   q16	413	427	378	378
   q17	611	877	385	385
   q18	7869	7234	7267	7234
   q19	1950	968	548	548
   q20	338	325	215	215
   q21	3636	3175	2338	2338
   q22	1034	1014	935	935
   Total cold run time: 115901 ms
   Total hot run time: 33803 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5142	5058	5028	5028
   q2	248	326	227	227
   q3	2147	2689	2304	2304
   q4	1351	1775	1318	1318
   q5	4509	4393	4417	4393
   q6	215	180	129	129
   q7	1975	1909	1801	1801
   q8	2590	2644	2555	2555
   q9	7291	7248	6964	6964
   q10	3067	3194	2764	2764
   q11	581	502	492	492
   q12	675	760	603	603
   q13	3559	3876	3252	3252
   q14	304	290	280	280
   q15	532	484	489	484
   q16	440	500	419	419
   q17	1124	1545	1443	1443
   q18	7754	7544	7522	7522
   q19	800	752	837	752
   q20	1989	2112	1970	1970
   q21	4749	4497	4431	4431
   q22	1123	1060	1024	1024
   Total cold run time: 52165 ms
   Total hot run time: 50155 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