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

when we insert data in batches , TDengine got stuck every single period of time #25266

Closed
ffxin opened this issue Apr 3, 2024 · 3 comments
Closed
Labels
performance Performance-related questions

Comments

@ffxin
Copy link

ffxin commented Apr 3, 2024

1、数据库环境

  • docker环境,宿主机配置内存:125G,cpu:24核心
  • TDengine版本 3.0.4.2

2、问题描述

在springboot,通过线程池每隔1秒向数据库插入3000条数据(共10组,每一组有300条数据),在运行8~10分钟左右的时间,会出现卡顿现象,在经过10s~30s左右的时间,继续执行,循环如此。。。调整过参数:numOfCommitThreads 改为8、以及48,任然会出现这种情况。。

@ffxin ffxin added the performance Performance-related questions label Apr 3, 2024
@ffxin ffxin changed the title java定时批量插入数据每隔一段时间出现卡顿现象 3.0.4.2版本-java定时批量插入数据每隔一段时间出现卡顿现象 Apr 3, 2024
@yu285
Copy link
Contributor

yu285 commented Apr 7, 2024

3.0.4.2 版本比较久了,麻烦更新一下到3.2.3.0 吧。

@yu285
Copy link
Contributor

yu285 commented Apr 7, 2024

另外也需要确认咱们的具体数据库环境,可以加微信a15652223354 做具体排查

@yu285 yu285 changed the title 3.0.4.2版本-java定时批量插入数据每隔一段时间出现卡顿现象 inserts data in batches with stuck every single period of time Apr 7, 2024
@yu285 yu285 changed the title inserts data in batches with stuck every single period of time when we insert data in batches , TDengine got stuck every single period of time Apr 7, 2024
@ffxin
Copy link
Author

ffxin commented Apr 7, 2024

3.0.4.2 版本比较久了,麻烦更新一下到3.2.3.0 吧。

好的,我这边升级下,试试。

@yu285 yu285 closed this as completed May 17, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
performance Performance-related questions
Projects
None yet
Development

No branches or pull requests

2 participants