Différence between Delete and Drop

InfluxDB 2 Tasks
1

Hi
My InfluxDB data base is coming from home assistant and is bigger and bigger .
I add more and more filters in order to reduce the size increase and I try to delete all the datas that I don’t need.
I use the Delete command and I could delete a lot but this does not seem to reduce the size of the data base.
Do I need to use the Drop command instead ?
Regards
Philippe

2

Deleting data does not reduce the amount of disk space being used.

This is a common aspect of nearly all databases - the files are disk are
designed for performance, not for efficiency of space used.

“Once a delete request completes successfully, the deleted data is no longer
queryable, but will remain on disk until the compaction service runs.”

See also:

I hope that helps,

Antony.

3

Hi

Thank you very Much for your very detailed and documented answer.

This was my fear and explain why I deleted so much without size reduction.

So is there any solution to reduce the database ? My disk is 240Gb and I have already nearly 60 % used while I estimate that I have deleted the equivalent of 30 to 40 % of this size

Thank you by advance

Regards

Philippe

4

Hi
Thank you very Much for your very detailed and documented answer.
This was my fear and explain why I deleted so much without size reduction.
So is there any solution to reduce the database ? My disk is 240Gb and I have already nearly 60 % used while I estimate that I have deleted the equivalent of 30 to 40 % of this size
Thank you by advance
Regards
Philippe

Envoyé de mon iPad

5

Hi any help about that ?
Thanks
Philippe

6

Sorry to insist but is there any solution to reduce the database size ?
Thanks
Philippe

7

I think you have to copy all data into a new database. then the only needed space is used. maybe you have to copy data twice, from original-name to temp-name and then back to original-name (after you dropped the original database).

8

Hi
This seems to be a good proposal . Do you have any recommendation for copying one base to another one ?
Thanks
Philippe

9

maybe this helps Copy measurment to another DB with new measurment name - #10 by vinc