Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

mysql sink allocate a huge number of memory when build multi statement sql. #9935

Closed
3AceShowHand opened this issue Oct 20, 2023 · 1 comment · Fixed by #9936
Closed

mysql sink allocate a huge number of memory when build multi statement sql. #9935

3AceShowHand opened this issue Oct 20, 2023 · 1 comment · Fixed by #9936
Assignees
Labels
affects-6.5 affects-7.1 affects-7.5 area/ticdc Issues or PRs related to TiCDC. component/mysql needs-cherry-pick-release-6.5 Should cherry pick this PR to release-6.5 branch. needs-cherry-pick-release-7.1 Should cherry pick this PR to release-7.1 branch. needs-cherry-pick-release-7.5 Should cherry pick this PR to release-7.5 branch. type/enhancement The issue or PR belongs to an enhancement.

Comments

@3AceShowHand
Copy link
Contributor

Screenshot 2023-10-20 at 15 21 58

From the above image, we can see that the MySQL sink allocates a huge number of memory when trying to build the multi-statement SQL, this can be reduced by using a more efficient string concatenation method.

@nongfushanquan
Copy link
Contributor

/label affects-6.5
/label affects-7.1
/label affects-7.5

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-6.5 affects-7.1 affects-7.5 area/ticdc Issues or PRs related to TiCDC. component/mysql needs-cherry-pick-release-6.5 Should cherry pick this PR to release-6.5 branch. needs-cherry-pick-release-7.1 Should cherry pick this PR to release-7.1 branch. needs-cherry-pick-release-7.5 Should cherry pick this PR to release-7.5 branch. type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants