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

多进程同时插数据导致磁盘占用异常 #30315

Open
Anbingsong opened this issue Mar 21, 2025 · 0 comments
Open

多进程同时插数据导致磁盘占用异常 #30315

Anbingsong opened this issue Mar 21, 2025 · 0 comments
Labels
bug Something isn't working

Comments

@Anbingsong
Copy link

同一个电脑,开tdengine服务端,在该电脑通过127.0.0.1 taos.h 向tdengine数据库插入数据。
一个进程插入2000w条数据后为70M磁盘占用。
同时开两个该进程(除了数据时间戳不一样,其他均一样),向tdengine插数据,磁盘占用为500M。
两个进程,一个一个执行,磁盘占用为140M。
提示:每个进程里不断执行最大sql语句字符的语句,100w个字符组成的sql语句来插数据。

为什么同时插入数据,会导致磁盘占用变大很多呢?

就是用df -h实时监控磁盘占用控件,然后具体逻辑就是执行最简单的insert into sql语句

@Anbingsong Anbingsong added the bug Something isn't working label Mar 21, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant