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.

Sign up for GitHub

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

Jump to bottom

一次批量导入逐渐变慢的问题 #6178

Open
luoxiaofeng1029 opened this issue May 18, 2024 · 4 comments
Open

一次批量导入逐渐变慢的问题 #6178

luoxiaofeng1029 opened this issue May 18, 2024 · 4 comments

Comments

@luoxiaofeng1029
Copy link

当前使用版本
3.5.4
当前环境信息
例如: Java17 + Mysql5.7

描述bug现象
image
I}KPXP1LIA3X}5 R0HJ68R6
image
8A 0{KP)HMKLMOLW7I57TJM
image
~`E@FVZ9AQK0 R KC95D($O
image
image
image
DM1NN(9WS%}%(9@0BXPMF$L
image
SIY$F F3PMVEXYSX$TTU _R
image
image
image
image
image
image
image
image
image
JOXVN2($%WTTQB6~ _ @TV4
image
image

如上这次问题的全过程,然后现在就想知道底层的原因是什么?
目前自己临时解决方法就是多线程批量导入了.
@nieqiurong
Copy link
Contributor

生成的语句，提高性能的方式你可以自定插入语句，而不是动态insert语句

@luoxiaofeng1029
Copy link
Author

生成的语句，提高性能的方式你可以自定插入语句，而不是动态insert语句

我的主要问题是为什么速度后面会在每K条增加.字段规格里有符号的换成普通中文后速度就正常了.你看我所有的内容了吗

@nieqiurong
Copy link
Contributor

没做任何处理，检查驱动底层.

@smartisane
Copy link

找到原因了吗，我也想知道

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@nieqiurong @luoxiaofeng1029 @smartisane