Hello @Anaisdg ,
yes, my csv files have timestamps.
I do collect some more data from telegraph but I inject them into another (influx)database, and this db is absolutely fine. Only the CSV_DB is growing like crazy.
So I would guess the same as you said with the cache or the temporary files. I had a look to the file structure of influx, and in data/CSV_DB/autogen/number/, I can see A LOT of ‘.tmp’ folders. And this is inside each number folder similar. Here a pic:
Each .tmp folder’s size is really close to the .tsm file size (~230mb, and actually really close to the raw data).
Is this a normal structure? what about these .tmp files? should they remain like this or should tey be deleted?
fyi: I’ve got 2 separated daily csv files series, which I inject into 2 different measurements.
- ~60 fields with 1s resolution
- ~150 fields with 1s resolution
fyi2: I do a portable backup every night. Could this cause any temp/cache problems? I found this, and it looks really similar (except I’m on Linux): During backup, the tmp file is not deleted. · Issue #20732 · influxdata/influxdb · GitHub
fyi3: yesterday I stopped the automatic (nightly) injection of the CSV files. Nothing happened overnight, the database didn’t change its size. l also triggered the injection manually at 1 PM and… 4.5h later, the HD usage got 55GB more data (exactly the same behaviour as nightly). So the CSV injection is definitely related to the problem.
All the best,
Vince
