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 2024/01/27 15:53:08 UTC
[PR] [fix](audit) add workload_group to audit log table [doris]
morningman opened a new pull request, #30470:
URL: https://github.com/apache/doris/pull/30470
## Proposed changes
1. Missing workload_group column in audit table
2. Extract the definition of internal schema's tables into a new class
## 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] [fix](audit) add workload_group to audit log table [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman merged PR #30470:
URL: https://github.com/apache/doris/pull/30470
--
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] [fix](audit) add workload_group to audit log table [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30470:
URL: https://github.com/apache/doris/pull/30470#issuecomment-1913260467
<details>
<summary>TPC-DS: <b>Total hot run time: 173420 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 27a99d9c1d8575eb6376f5e97d0e997dcfa948f2, data reload: false
query1 958 331 321 321
query2 6554 2121 2023 2023
query3 6693 202 193 193
query4 32565 22042 22018 22018
query5 4458 341 346 341
query6 249 153 168 153
query7 4613 265 255 255
query8 254 172 173 172
query9 8583 2245 2230 2230
query10 403 200 191 191
query11 17973 15224 15329 15224
query12 124 69 62 62
query13 1689 364 380 364
query14 9028 6431 6320 6320
query15 205 169 175 169
query16 5698 246 249 246
query17 960 473 475 473
query18 1817 264 253 253
query19 183 133 132 132
query20 71 73 64 64
query21 207 137 131 131
query22 4933 4975 4823 4823
query23 31014 30128 30302 30128
query24 11430 2786 2804 2786
query25 551 304 299 299
query26 893 136 138 136
query27 3029 283 283 283
query28 6535 1835 1824 1824
query29 945 612 617 612
query30 279 136 135 135
query31 907 706 731 706
query32 75 50 51 50
query33 630 203 209 203
query34 995 447 462 447
query35 860 765 763 763
query36 1347 1212 1187 1187
query37 94 55 61 55
query38 3365 3186 3164 3164
query39 1289 1242 1237 1237
query40 190 89 77 77
query41 37 38 34 34
query42 81 80 79 79
query43 508 479 494 479
query44 1094 671 678 671
query45 190 174 179 174
query46 1050 663 645 645
query47 1599 1511 1507 1507
query48 394 316 307 307
query49 1096 279 283 279
query50 689 315 306 306
query51 5300 5145 5177 5145
query52 86 79 72 72
query53 314 263 247 247
query54 263 180 185 180
query55 77 71 73 71
query56 169 165 173 165
query57 970 914 914 914
query58 186 157 157 157
query59 2830 2648 2587 2587
query60 209 177 177 177
query61 86 86 85 85
query62 646 350 335 335
query63 275 270 257 257
query64 4292 1760 1715 1715
query65 3269 3222 3170 3170
query66 1174 316 315 315
query67 14690 14655 14695 14655
query68 3792 487 484 484
query69 432 288 290 288
query70 1501 1509 1483 1483
query71 248 216 204 204
query72 3799 2827 2875 2827
query73 685 313 317 313
query74 6680 6287 6296 6287
query75 2849 2302 2293 2293
query76 2702 992 993 992
query77 358 231 225 225
query78 9056 8852 8664 8664
query79 2252 482 485 482
query80 1247 322 320 320
query81 525 199 202 199
query82 1041 81 75 75
query83 229 112 116 112
query84 279 72 72 72
query85 1349 344 343 343
query86 435 379 392 379
query87 3455 3338 3308 3308
query88 3328 2157 2150 2150
query89 411 356 334 334
query90 1948 184 182 182
query91 172 121 122 121
query92 52 44 44 44
query93 1677 407 422 407
query94 1303 157 157 157
query95 516 457 440 440
query96 604 307 307 307
query97 4239 4109 4114 4109
query98 203 186 192 186
query99 1193 669 655 655
Total cold run time: 272780 ms
Total hot run time: 173420 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] [fix](audit) add workload_group to audit log table [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30470:
URL: https://github.com/apache/doris/pull/30470#issuecomment-1916251728
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] [fix](audit) add workload_group to audit log table [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30470:
URL: https://github.com/apache/doris/pull/30470#issuecomment-1913263114
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 27a99d9c1d8575eb6376f5e97d0e997dcfa948f2 with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 13.2 seconds inserted 10000000 Rows, about 757K 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] [fix](audit) add workload_group to audit log table [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman commented on PR #30470:
URL: https://github.com/apache/doris/pull/30470#issuecomment-1913250581
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] [fix](audit) add workload_group to audit log table [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30470:
URL: https://github.com/apache/doris/pull/30470#issuecomment-1914970852
<details>
<summary>TPC-DS: <b>Total hot run time: 172765 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 a282f0c9702692471529606f1823e588468f1e92, data reload: false
query1 925 331 318 318
query2 6571 1866 1889 1866
query3 6700 205 192 192
query4 33113 22031 22014 22014
query5 4450 356 411 356
query6 247 166 169 166
query7 4599 263 255 255
query8 242 179 192 179
query9 8515 2287 2254 2254
query10 412 207 211 207
query11 17806 15343 15383 15343
query12 119 70 65 65
query13 1679 377 372 372
query14 9160 6452 6516 6452
query15 204 182 180 180
query16 5709 255 253 253
query17 949 467 456 456
query18 1802 253 254 253
query19 179 132 130 130
query20 76 72 71 71
query21 199 134 129 129
query22 4905 4446 4660 4446
query23 31232 30390 30391 30390
query24 12460 2780 2750 2750
query25 589 313 311 311
query26 1978 148 139 139
query27 3172 281 284 281
query28 7645 1838 1816 1816
query29 2246 626 602 602
query30 295 134 140 134
query31 884 703 709 703
query32 74 47 47 47
query33 706 214 213 213
query34 1189 454 444 444
query35 856 735 770 735
query36 1253 1214 1230 1214
query37 172 57 56 56
query38 3281 3157 3175 3157
query39 1321 1231 1246 1231
query40 337 80 81 80
query41 37 36 35 35
query42 90 81 80 80
query43 532 487 472 472
query44 1107 702 700 700
query45 188 178 174 174
query46 1044 632 642 632
query47 1559 1501 1522 1501
query48 395 305 299 299
query49 1226 286 280 280
query50 690 318 305 305
query51 5309 5157 5069 5069
query52 85 79 75 75
query53 319 262 257 257
query54 248 183 179 179
query55 78 72 75 72
query56 177 157 172 157
query57 1018 926 916 916
query58 178 153 159 153
query59 2796 2576 2511 2511
query60 202 184 177 177
query61 80 82 87 82
query62 594 362 366 362
query63 296 277 269 269
query64 5993 1749 1698 1698
query65 3291 3253 3216 3216
query66 1488 315 303 303
query67 14416 14217 14185 14185
query68 3832 489 489 489
query69 422 307 300 300
query70 1501 1490 1535 1490
query71 288 213 208 208
query72 3712 2819 2852 2819
query73 691 316 314 314
query74 6588 6234 6308 6234
query75 2795 2271 2248 2248
query76 2627 1003 1027 1003
query77 430 230 225 225
query78 8968 8678 8665 8665
query79 2454 477 488 477
query80 1369 317 319 317
query81 503 195 199 195
query82 720 85 76 76
query83 213 113 114 113
query84 272 72 76 72
query85 1786 320 332 320
query86 530 394 392 392
query87 3388 3236 3267 3236
query88 4014 2162 2144 2144
query89 420 367 355 355
query90 2092 184 184 184
query91 144 145 124 124
query92 50 45 44 44
query93 1872 446 423 423
query94 1425 162 163 162
query95 501 465 456 456
query96 603 312 313 312
query97 4219 4143 4120 4120
query98 210 200 182 182
query99 1060 681 647 647
Total cold run time: 281386 ms
Total hot run time: 172765 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] [fix](audit) add workload_group to audit log table [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30470:
URL: https://github.com/apache/doris/pull/30470#issuecomment-1914982149
<details>
<summary>ClickBench: <b>Total hot run time: 31.33 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 a282f0c9702692471529606f1823e588468f1e92, data reload: false
query1 0.03 0.03 0.03
query2 0.06 0.02 0.02
query3 0.23 0.05 0.06
query4 1.69 0.09 0.10
query5 0.53 0.51 0.52
query6 1.19 0.64 0.65
query7 0.02 0.02 0.01
query8 0.03 0.02 0.02
query9 0.52 0.49 0.50
query10 0.56 0.54 0.54
query11 0.12 0.08 0.09
query12 0.11 0.08 0.09
query13 0.60 0.60 0.61
query14 0.78 0.80 0.78
query15 0.81 0.79 0.77
query16 0.39 0.39 0.38
query17 1.03 1.03 0.96
query18 0.23 0.25 0.26
query19 1.77 1.74 1.82
query20 0.02 0.01 0.01
query21 15.41 0.58 0.57
query22 2.52 2.41 2.19
query23 17.10 0.79 0.74
query24 2.47 1.01 0.97
query25 0.36 0.24 0.22
query26 0.39 0.14 0.14
query27 0.06 0.05 0.04
query28 11.66 0.86 0.84
query29 12.53 3.25 3.20
query30 0.57 0.54 0.57
query31 2.79 0.35 0.36
query32 3.37 0.48 0.48
query33 3.24 3.25 3.20
query34 15.82 4.32 4.24
query35 4.34 4.27 4.32
query36 1.11 1.04 1.07
query37 0.06 0.05 0.05
query38 0.04 0.02 0.03
query39 0.02 0.02 0.01
query40 0.18 0.13 0.13
query41 0.06 0.01 0.02
query42 0.02 0.02 0.01
query43 0.02 0.02 0.02
Total cold run time: 104.86 s
Total hot run time: 31.33 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] [fix](audit) add workload_group to audit log table [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30470:
URL: https://github.com/apache/doris/pull/30470#issuecomment-1916251669
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] [fix](audit) add workload_group to audit log table [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman commented on PR #30470:
URL: https://github.com/apache/doris/pull/30470#issuecomment-1914896379
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] [fix](audit) add workload_group to audit log table [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30470:
URL: https://github.com/apache/doris/pull/30470#issuecomment-1913255500
<details>
<summary>TPC-H: <b>Total hot run time: 37410 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 27a99d9c1d8575eb6376f5e97d0e997dcfa948f2, data reload: false
------ Round 1 ----------------------------------
q1 17598 4740 5125 4740
q2 2073 135 133 133
q3 10714 919 914 914
q4 4706 737 771 737
q5 7679 2827 2811 2811
q6 184 120 120 120
q7 1129 729 711 711
q8 9432 2017 2028 2017
q9 7209 6377 6359 6359
q10 8147 2448 2406 2406
q11 419 191 198 191
q12 787 270 276 270
q13 18034 3290 3279 3279
q14 280 254 245 245
q15 529 493 485 485
q16 488 416 395 395
q17 942 526 480 480
q18 6949 6261 6132 6132
q19 1588 1375 1291 1291
q20 576 349 308 308
q21 7021 3088 3098 3088
q22 790 316 298 298
Total cold run time: 107274 ms
Total hot run time: 37410 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5043 5040 5095 5040
q2 348 234 240 234
q3 3016 2799 2739 2739
q4 1857 1588 1573 1573
q5 5210 5242 5270 5242
q6 200 113 113 113
q7 2112 1832 1845 1832
q8 3089 3195 3208 3195
q9 8720 8613 12305 8613
q10 5585 3448 3477 3448
q11 551 456 481 456
q12 794 585 609 585
q13 16926 3076 3061 3061
q14 278 253 259 253
q15 538 487 494 487
q16 507 485 457 457
q17 2011 1668 1786 1668
q18 9187 9421 8385 8385
q19 23915 1565 1525 1525
q20 4608 1917 1891 1891
q21 15573 4977 4891 4891
q22 1048 450 461 450
Total cold run time: 111116 ms
Total hot run time: 56138 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] [fix](audit) add workload_group to audit log table [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30470:
URL: https://github.com/apache/doris/pull/30470#issuecomment-1913261966
<details>
<summary>ClickBench: <b>Total hot run time: 30.23 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 27a99d9c1d8575eb6376f5e97d0e997dcfa948f2, data reload: false
query1 0.04 0.03 0.03
query2 0.07 0.03 0.03
query3 0.23 0.06 0.06
query4 1.66 0.10 0.10
query5 0.52 0.51 0.52
query6 1.23 0.61 0.62
query7 0.02 0.02 0.01
query8 0.04 0.03 0.02
query9 0.55 0.48 0.50
query10 0.57 0.53 0.54
query11 0.12 0.08 0.09
query12 0.11 0.09 0.10
query13 0.61 0.62 0.60
query14 0.79 0.79 0.79
query15 0.78 0.78 0.76
query16 0.39 0.38 0.38
query17 0.97 1.00 1.00
query18 0.24 0.25 0.23
query19 1.87 1.79 1.75
query20 0.02 0.01 0.01
query21 15.43 0.57 0.56
query22 2.74 2.68 1.51
query23 17.36 0.88 0.80
query24 2.53 1.46 0.46
query25 0.29 0.21 0.22
query26 0.52 0.14 0.13
query27 0.05 0.06 0.05
query28 11.43 0.83 0.89
query29 12.52 3.17 3.09
query30 0.62 0.54 0.54
query31 2.79 0.34 0.34
query32 3.34 0.48 0.48
query33 3.22 3.20 3.22
query34 15.85 4.33 4.30
query35 4.37 4.38 4.36
query36 1.11 1.05 1.05
query37 0.07 0.04 0.04
query38 0.04 0.03 0.03
query39 0.02 0.01 0.01
query40 0.16 0.13 0.14
query41 0.07 0.02 0.01
query42 0.02 0.02 0.01
query43 0.03 0.02 0.02
Total cold run time: 105.41 s
Total hot run time: 30.23 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] [fix](audit) add workload_group to audit log table [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30470:
URL: https://github.com/apache/doris/pull/30470#issuecomment-1914945265
<details>
<summary>TPC-H: <b>Total hot run time: 38079 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 a282f0c9702692471529606f1823e588468f1e92, data reload: false
------ Round 1 ----------------------------------
q1 17998 5073 5419 5073
q2 2502 148 140 140
q3 11169 965 952 952
q4 5058 764 824 764
q5 7750 2916 2880 2880
q6 188 122 121 121
q7 1158 732 711 711
q8 9326 2002 2007 2002
q9 7217 6344 6323 6323
q10 8112 2439 2387 2387
q11 408 213 199 199
q12 718 288 280 280
q13 18017 3328 3349 3328
q14 270 242 255 242
q15 530 491 492 491
q16 477 396 426 396
q17 936 544 482 482
q18 6991 6561 6157 6157
q19 1546 1445 1375 1375
q20 617 356 337 337
q21 6655 3159 3171 3159
q22 800 307 280 280
Total cold run time: 108443 ms
Total hot run time: 38079 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5157 5011 4780 4780
q2 338 243 239 239
q3 3078 2764 2692 2692
q4 1765 1617 1593 1593
q5 5422 5191 5169 5169
q6 205 115 115 115
q7 2203 1872 1759 1759
q8 3108 3140 3227 3140
q9 8576 8543 13794 8543
q10 5454 3503 3476 3476
q11 582 468 462 462
q12 756 606 628 606
q13 16926 3111 3083 3083
q14 293 248 268 248
q15 540 487 492 487
q16 519 477 465 465
q17 1877 1738 1729 1729
q18 8813 12912 8886 8886
q19 25615 1587 1582 1582
q20 4595 1918 1913 1913
q21 16781 5030 4901 4901
q22 1454 494 509 494
Total cold run time: 114057 ms
Total hot run time: 56362 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] [fix](audit) add workload_group to audit log table [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman commented on PR #30470:
URL: https://github.com/apache/doris/pull/30470#issuecomment-1914504324
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] [fix](audit) add workload_group to audit log table [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30470:
URL: https://github.com/apache/doris/pull/30470#issuecomment-1914567529
<details>
<summary>ClickBench: <b>Total hot run time: 30.68 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 bc9ca8ea5623e1759427637037008277c68d38c0, data reload: false
query1 0.04 0.03 0.03
query2 0.06 0.03 0.02
query3 0.22 0.06 0.05
query4 1.67 0.10 0.10
query5 0.52 0.52 0.50
query6 1.18 0.62 0.64
query7 0.02 0.01 0.01
query8 0.04 0.03 0.03
query9 0.54 0.50 0.49
query10 0.55 0.52 0.56
query11 0.12 0.08 0.09
query12 0.11 0.09 0.10
query13 0.60 0.62 0.61
query14 0.78 0.82 0.79
query15 0.79 0.79 0.78
query16 0.37 0.39 0.40
query17 1.00 1.00 0.97
query18 0.23 0.27 0.24
query19 1.84 1.81 1.80
query20 0.02 0.01 0.01
query21 15.40 0.56 0.54
query22 2.37 2.83 2.18
query23 17.21 1.08 0.69
query24 2.65 1.44 0.23
query25 0.31 0.15 0.12
query26 0.61 0.14 0.14
query27 0.04 0.04 0.05
query28 12.28 0.87 0.83
query29 12.53 3.24 3.25
query30 0.64 0.57 0.62
query31 2.78 0.34 0.35
query32 3.37 0.49 0.48
query33 3.23 3.31 3.27
query34 15.92 4.28 4.26
query35 4.29 4.31 4.30
query36 1.12 1.06 1.08
query37 0.06 0.05 0.05
query38 0.05 0.03 0.02
query39 0.02 0.02 0.02
query40 0.16 0.13 0.12
query41 0.07 0.02 0.02
query42 0.03 0.01 0.02
query43 0.03 0.02 0.02
Total cold run time: 105.87 s
Total hot run time: 30.68 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] [fix](audit) add workload_group to audit log table [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30470:
URL: https://github.com/apache/doris/pull/30470#issuecomment-1914572387
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit bc9ca8ea5623e1759427637037008277c68d38c0 with default session variables
Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 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: 14.3 seconds inserted 10000000 Rows, about 699K 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] [fix](audit) add workload_group to audit log table [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30470:
URL: https://github.com/apache/doris/pull/30470#issuecomment-1914558411
<details>
<summary>TPC-DS: <b>Total hot run time: 173295 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 bc9ca8ea5623e1759427637037008277c68d38c0, data reload: false
query1 935 335 326 326
query2 6580 1927 2086 1927
query3 6705 202 194 194
query4 34022 22125 22128 22125
query5 4443 343 360 343
query6 247 163 175 163
query7 4595 260 253 253
query8 262 167 173 167
query9 8456 2256 2236 2236
query10 417 204 206 204
query11 17632 15377 15218 15218
query12 127 70 66 66
query13 1669 374 372 372
query14 9170 6348 6552 6348
query15 208 189 184 184
query16 5825 259 250 250
query17 1570 479 461 461
query18 2336 260 247 247
query19 174 130 136 130
query20 73 72 74 72
query21 200 131 138 131
query22 5007 5126 4955 4955
query23 31141 30451 30484 30451
query24 7697 2745 2767 2745
query25 544 329 304 304
query26 895 134 141 134
query27 2802 284 283 283
query28 3986 1834 1821 1821
query29 902 601 610 601
query30 278 139 135 135
query31 896 708 718 708
query32 68 49 47 47
query33 419 210 207 207
query34 819 458 469 458
query35 843 776 757 757
query36 1289 1180 1200 1180
query37 95 60 58 58
query38 3320 3131 3185 3131
query39 1316 1266 1239 1239
query40 202 90 78 78
query41 37 35 34 34
query42 97 79 85 79
query43 512 480 487 480
query44 1026 693 701 693
query45 190 175 174 174
query46 1040 650 630 630
query47 1601 1549 1541 1541
query48 370 301 300 300
query49 1086 277 283 277
query50 675 308 312 308
query51 5305 5155 5257 5155
query52 96 76 82 76
query53 317 250 251 250
query54 229 196 174 174
query55 81 73 75 73
query56 177 151 163 151
query57 978 879 917 879
query58 180 159 151 151
query59 2647 2683 2660 2660
query60 187 177 180 177
query61 83 84 84 84
query62 610 359 354 354
query63 270 257 261 257
query64 3774 1759 1746 1746
query65 3299 3241 3200 3200
query66 1175 327 312 312
query67 14223 14258 14204 14204
query68 3707 488 476 476
query69 425 298 291 291
query70 1467 1434 1421 1421
query71 264 208 199 199
query72 3668 2804 2831 2804
query73 689 315 318 315
query74 6575 6322 6267 6267
query75 2747 2303 2265 2265
query76 2678 1020 1032 1020
query77 339 227 222 222
query78 8974 8937 8494 8494
query79 2138 481 473 473
query80 1342 319 306 306
query81 512 193 198 193
query82 689 83 79 79
query83 223 112 114 112
query84 278 70 69 69
query85 1711 353 338 338
query86 509 414 399 399
query87 3482 3282 3299 3282
query88 3721 2179 2174 2174
query89 426 373 339 339
query90 1917 183 179 179
query91 162 117 115 115
query92 52 42 44 42
query93 2433 443 435 435
query94 1218 159 154 154
query95 494 445 449 445
query96 613 311 309 309
query97 4201 4092 4097 4092
query98 200 192 180 180
query99 1070 679 678 678
Total cold run time: 267354 ms
Total hot run time: 173295 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] [fix](audit) add workload_group to audit log table [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman commented on PR #30470:
URL: https://github.com/apache/doris/pull/30470#issuecomment-1913207527
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] [fix](audit) add workload_group to audit log table [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30470:
URL: https://github.com/apache/doris/pull/30470#issuecomment-1913243632
<details>
<summary>TPC-H: <b>Total hot run time: 37506 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 a04aae7fbed73b5c8ab894cc47a3c61b796096b6, data reload: false
------ Round 1 ----------------------------------
q1 17663 4791 5044 4791
q2 2045 139 131 131
q3 10715 910 905 905
q4 4764 682 719 682
q5 7661 2883 2794 2794
q6 187 120 119 119
q7 1129 721 713 713
q8 9360 1997 2010 1997
q9 7253 6354 6375 6354
q10 8135 2395 2424 2395
q11 416 205 207 205
q12 770 295 289 289
q13 18010 3277 3277 3277
q14 269 250 245 245
q15 517 512 490 490
q16 447 398 411 398
q17 920 537 516 516
q18 6863 6135 6211 6135
q19 1564 1406 1352 1352
q20 584 335 336 335
q21 7053 3100 3167 3100
q22 813 287 283 283
Total cold run time: 107138 ms
Total hot run time: 37506 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5210 4784 4869 4784
q2 354 246 232 232
q3 3004 2749 2721 2721
q4 1833 1597 1573 1573
q5 5343 5205 5264 5205
q6 201 115 117 115
q7 2146 1787 1782 1782
q8 3106 3185 3203 3185
q9 8713 8640 10973 8640
q10 5418 3496 3450 3450
q11 556 473 473 473
q12 808 565 633 565
q13 16957 3117 3047 3047
q14 290 247 257 247
q15 529 487 481 481
q16 537 469 490 469
q17 2050 1612 1742 1612
q18 8873 10521 8933 8933
q19 23911 1583 1511 1511
q20 4584 1895 1887 1887
q21 15084 4935 5082 4935
q22 1009 479 484 479
Total cold run time: 110516 ms
Total hot run time: 56326 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] [fix](audit) add workload_group to audit log table [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30470:
URL: https://github.com/apache/doris/pull/30470#issuecomment-1914991236
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit a282f0c9702692471529606f1823e588468f1e92 with default session variables
Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 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: 13.6 seconds inserted 10000000 Rows, about 735K 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