matrixorigin / matrixone

Hyperconverged cloud-edge native database
https://docs.matrixorigin.cn/en
Apache License 2.0
1.79k stars 276 forks source link

[Bug]: [date 6.26]tke regression: tpch1T 4cn some querys performance down about one time #17185

Closed heni02 closed 4 months ago

heni02 commented 5 months ago

Is there an existing issue for the same bug?

Branch Name

main

Commit ID

e975b6dc9

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

job:https://github.com/matrixorigin/mo-nightly-regression/actions/runs/9681659361/job/26739599474 Q1超过60s未返回

企业微信截图_6387efdd-c7fa-4e97-8fae-f8c1c05e48f5

Q3,Q9,Q10基本慢了一倍

企业微信截图_c9ed0ede-ec86-4c7c-b1f5-ac13676d86d2 企业微信截图_0aa90d44-55b5-42ce-9d63-86f5a1e5cdf7 企业微信截图_a6989536-8f43-4804-a863-2d3127b792a2

其他query也有小幅性能下降,具体见: http://grafana.matrixorigin.cn:31080/d/tBWw-hxIz/tpch_1000_4cn?orgId=1

mo log: https://grafana.ci.matrixorigin.cn/explore?panes=%7B%22hhC%22:%7B%22datasource%22:%22loki%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bnamespace%3D%5C%22mo-main-nightly-e975b6dc9-20240626%5C%22%7D%20%7C%3D%20%60%60%22,%22queryType%22:%22range%22,%22datasource%22:%7B%22type%22:%22loki%22,%22uid%22:%22loki%22%7D,%22editorMode%22:%22builder%22%7D%5D,%22range%22:%7B%22from%22:%221719427657743%22,%22to%22:%221719470857743%22%7D%7D%7D&schemaVersion=1&orgId=1

Expected Behavior

No response

Steps to Reproduce

tke 4cn 1T

Additional information

No response

badboynt1 commented 4 months ago

最新的daily已经没有问题了

heni02 commented 4 months ago

confirm,closed main commit:7befc6460

企业微信截图_f8f96c3a-3fe3-4c02-8cf1-5809e20bbc3f

http://grafana.matrixorigin.cn:31080/d/tBWw-hxIz/tpch_1000_4cn?orgId=1