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

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

Closed
Anbingsong opened this issue Jan 17, 2025 · 2 comments
Closed

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

Anbingsong opened this issue Jan 17, 2025 · 2 comments
Assignees
@yu285
Labels
performance Performance-related questions

Comments

@Anbingsong
Copy link

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

为什么同时插入数据，会导致磁盘占用变大很多呢？
@Anbingsong Anbingsong added the performance Performance-related questions label Jan 17, 2025
@yu285
Copy link
Contributor

yu285 commented Jan 20, 2025

是哪个目录的大小，以及写入的具体逻辑，都需要具体描述

@yu285 yu285 self-assigned this Jan 20, 2025
@yu285 yu285 closed this as completed Feb 19, 2025
@Anbingsong
Copy link
Author

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@yu285 yu285

Labels
performance Performance-related questions
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@Anbingsong @yu285