matrixone
matrixone copied to clipboard
Published
20 hours ago •
matrixorigin
matrixorigin
[Bug]: Resource consumption decreases for the same SQL as CN scales out
Is there an existing issue for the same bug?
- [X] I have checked the existing issues.
Branch Name
1.1-dev
Commit ID
e82e8634e
Other Environment Information
- Hardware parameters:
- OS type:
- Others:
Actual Behavior
Run TPCH Q1 continuously and CN scales out, however, as the SQL runs, the resource consumption decreases for each SQL:
MySQL [mo_cloud]> select statement_id,request_at,stats,duration from system.statement_info where request_at >= '2024-01-16 09:20:00' and statement_id = '9fbcb619-b451-11ee-ab0d-5a793b855f27';
+--------------------------------------+----------------------------+-------------------------------------------+------------+
| statement_id | request_at | stats | duration |
+--------------------------------------+----------------------------+-------------------------------------------+------------+
| 9fbcb619-b451-11ee-ab0d-5a793b855f27 | 2024-01-16 09:28:36.035840 | [3,29257374651,9793388020.000,0,0,1215,2] | 3742379779 |
+--------------------------------------+----------------------------+-------------------------------------------+------------+
1 row in set (0.01 sec)
MySQL [mo_cloud]> select statement_id,request_at,stats,duration from system.statement_info where request_at >= '2024-01-16 09:20:00' and statement_id = 'dde96a1d-b452-11ee-ab0d-5a793b855f27';
+--------------------------------------+----------------------------+-------------------------------------------+-----------+
| statement_id | request_at | stats | duration |
+--------------------------------------+----------------------------+-------------------------------------------+-----------+
| dde96a1d-b452-11ee-ab0d-5a793b855f27 | 2024-01-16 09:37:29.844278 | [3,21447305605,9793388020.000,0,0,1215,2] | 620723372 |
+--------------------------------------+----------------------------+-------------------------------------------+-----------+
1 row in set (0.02 sec)
Expected Behavior
Resource consumption is stable or increases a little bit
Steps to Reproduce
See detail in `Actual Behavior`
Additional information
Refer to https://github.com/matrixorigin/MO-Cloud/issues/2337
