You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "SWJTU-ZhangLei (via GitHub)" <gi...@apache.org> on 2024/01/22 13:18:58 UTC
[PR] [fix](fe) Upgrade mariadb client version from 3.0.4 to 3.0.9 [doris]
SWJTU-ZhangLei opened a new pull request, #30242:
URL: https://github.com/apache/doris/pull/30242
mariadb-java-client 3.0.4 has two serious problems:
* https://jira.mariadb.org/browse/CONJ-972
* https://jira.mariadb.org/browse/CONJ-973
## 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] [fix](fe) Upgrade mariadb client version from 3.0.4 to 3.0.9 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30242:
URL: https://github.com/apache/doris/pull/30242#issuecomment-1904091196
<details>
<summary>TPC-DS: <b>Total hot run time: 176739 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 dc399bfe92ef41203f39e0c7714426841dc4ce3c, data reload: false
query1 950 337 326 326
query2 6553 2032 1908 1908
query3 6742 203 200 200
query4 31369 22381 22328 22328
query5 4449 369 427 369
query6 246 151 153 151
query7 4604 263 273 263
query8 232 174 174 174
query9 8383 2563 2542 2542
query10 416 234 244 234
query11 16661 15566 15438 15438
query12 123 66 64 64
query13 1683 381 375 375
query14 10610 6890 6946 6890
query15 209 176 191 176
query16 5785 254 249 249
query17 955 473 464 464
query18 1794 261 255 255
query19 174 125 133 125
query20 73 75 72 72
query21 186 130 136 130
query22 4959 4717 4680 4680
query23 31680 30795 30855 30795
query24 11469 2818 2815 2815
query25 572 307 303 303
query26 1638 149 144 144
query27 3209 294 289 289
query28 7173 1840 1841 1840
query29 1701 626 608 608
query30 274 139 137 137
query31 918 747 755 747
query32 78 51 48 48
query33 703 208 211 208
query34 1141 451 468 451
query35 908 766 762 762
query36 1303 1277 1153 1153
query37 97 59 60 59
query38 3374 3226 3208 3208
query39 1310 1273 1248 1248
query40 347 91 81 81
query41 39 36 34 34
query42 90 79 86 79
query43 504 489 471 471
query44 1103 692 697 692
query45 200 178 179 178
query46 1077 647 666 647
query47 1700 1547 1551 1547
query48 396 312 316 312
query49 1219 283 289 283
query50 692 315 317 315
query51 5341 5210 5150 5150
query52 96 76 78 76
query53 335 259 254 254
query54 240 175 194 175
query55 85 76 73 73
query56 176 168 168 168
query57 1020 958 934 934
query58 197 162 167 162
query59 2951 2804 2614 2614
query60 214 187 182 182
query61 81 83 83 83
query62 628 372 380 372
query63 287 271 261 261
query64 5942 1792 1750 1750
query65 3335 3240 3234 3234
query66 1256 334 321 321
query67 15521 15215 15072 15072
query68 11958 514 535 514
query69 585 307 299 299
query70 1717 1611 1561 1561
query71 480 204 208 204
query72 4823 2841 2828 2828
query73 2300 327 319 319
query74 7009 6443 6438 6438
query75 4586 2359 2299 2299
query76 6334 1032 982 982
query77 675 232 234 232
query78 9029 8773 8800 8773
query79 1002 502 501 501
query80 606 318 312 312
query81 440 210 204 204
query82 210 83 81 81
query83 142 121 118 118
query84 272 71 68 68
query85 1064 358 339 339
query86 399 376 367 367
query87 3508 3312 3311 3311
query88 3078 2190 2188 2188
query89 451 354 352 352
query90 1969 191 187 187
query91 155 123 129 123
query92 51 48 43 43
query93 2186 435 449 435
query94 1282 160 157 157
query95 495 465 446 446
query96 619 326 317 317
query97 4246 4105 4139 4105
query98 210 197 184 184
query99 1015 727 704 704
Total cold run time: 292672 ms
Total hot run time: 176739 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](fe) Upgrade mariadb client version from 3.0.4 to 3.0.9 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30242:
URL: https://github.com/apache/doris/pull/30242#issuecomment-1904101790
<details>
<summary>ClickBench: <b>Total hot run time: 30.92 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 dc399bfe92ef41203f39e0c7714426841dc4ce3c, data reload: false
query1 0.03 0.03 0.03
query2 0.05 0.02 0.02
query3 0.23 0.05 0.05
query4 1.69 0.07 0.07
query5 0.53 0.52 0.51
query6 1.28 0.62 0.65
query7 0.02 0.01 0.01
query8 0.04 0.03 0.03
query9 0.55 0.50 0.49
query10 0.55 0.54 0.55
query11 0.12 0.10 0.09
query12 0.11 0.10 0.09
query13 0.61 0.60 0.61
query14 0.80 0.80 0.79
query15 0.80 0.78 0.77
query16 0.38 0.36 0.37
query17 0.99 1.02 1.02
query18 0.24 0.25 0.26
query19 1.81 1.76 1.83
query20 0.01 0.01 0.01
query21 15.40 0.55 0.56
query22 2.78 2.56 2.15
query23 17.37 0.82 0.78
query24 2.79 0.92 0.80
query25 0.42 0.18 0.16
query26 0.41 0.13 0.13
query27 0.06 0.04 0.06
query28 11.32 0.77 0.79
query29 12.53 3.15 3.09
query30 0.56 0.47 0.45
query31 2.78 0.34 0.35
query32 3.36 0.48 0.47
query33 3.23 3.23 3.26
query34 15.78 4.29 4.27
query35 4.37 4.25 4.32
query36 1.10 1.08 1.07
query37 0.07 0.05 0.05
query38 0.03 0.03 0.03
query39 0.03 0.01 0.01
query40 0.16 0.12 0.13
query41 0.07 0.02 0.02
query42 0.02 0.01 0.02
query43 0.02 0.02 0.02
Total cold run time: 105.5 s
Total hot run time: 30.92 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](fe) Upgrade mariadb client version from 3.0.4 to 3.0.9 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30242:
URL: https://github.com/apache/doris/pull/30242#issuecomment-1904069020
<details>
<summary>TPC-H: <b>Total hot run time: 39186 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 dc399bfe92ef41203f39e0c7714426841dc4ce3c, data reload: false
------ Round 1 ----------------------------------
q1 17642 5387 5389 5387
q2 2043 143 133 133
q3 10810 1165 1153 1153
q4 10445 773 809 773
q5 7772 3167 3174 3167
q6 201 122 122 122
q7 872 497 485 485
q8 9232 1928 1970 1928
q9 7253 6352 6354 6352
q10 8226 3081 3059 3059
q11 416 222 201 201
q12 358 200 197 197
q13 17987 3392 3357 3357
q14 257 215 207 207
q15 543 509 500 500
q16 449 393 383 383
q17 944 507 540 507
q18 7555 7035 6894 6894
q19 1582 1342 1361 1342
q20 586 315 322 315
q21 2795 2424 2447 2424
q22 371 322 300 300
Total cold run time: 108339 ms
Total hot run time: 39186 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5488 5204 5304 5204
q2 332 218 207 207
q3 3324 3226 3249 3226
q4 2108 2079 2073 2073
q5 5873 5772 5966 5772
q6 196 120 120 120
q7 2237 1886 1913 1886
q8 3215 3380 3371 3371
q9 8937 9102 12005 9102
q10 3864 3851 3842 3842
q11 548 455 452 452
q12 803 602 645 602
q13 16941 3195 3161 3161
q14 282 244 257 244
q15 551 514 506 506
q16 510 468 484 468
q17 1872 1863 1851 1851
q18 9621 17410 9634 9634
q19 26605 1536 1504 1504
q20 4595 1946 1941 1941
q21 14463 5474 5472 5472
q22 1003 572 552 552
Total cold run time: 113368 ms
Total hot run time: 61190 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](fe) Upgrade mariadb client version from 3.0.4 to 3.0.9 [doris]
Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei merged PR #30242:
URL: https://github.com/apache/doris/pull/30242
--
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](fe) Upgrade mariadb client version from 3.0.4 to 3.0.9 [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30242:
URL: https://github.com/apache/doris/pull/30242#issuecomment-1903997696
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](fe) Upgrade mariadb client version from 3.0.4 to 3.0.9 [doris]
Posted by "SWJTU-ZhangLei (via GitHub)" <gi...@apache.org>.
SWJTU-ZhangLei commented on PR #30242:
URL: https://github.com/apache/doris/pull/30242#issuecomment-1903993455
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](fe) Upgrade mariadb client version from 3.0.4 to 3.0.9 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30242:
URL: https://github.com/apache/doris/pull/30242#issuecomment-1904108194
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit dc399bfe92ef41203f39e0c7714426841dc4ce3c 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: 32 seconds loaded 861443392 Bytes, about 25 MB/s
Insert into select: 14.8 seconds inserted 10000000 Rows, about 675K 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](fe) Upgrade mariadb client version from 3.0.4 to 3.0.9 [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30242:
URL: https://github.com/apache/doris/pull/30242#issuecomment-1904099084
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