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
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.
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
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
Hi any help about that ?
Thanks
Philippe
Sorry to insist but is there any solution to reduce the database size ?
Thanks
Philippe
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).
Hi
This seems to be a good proposal . Do you have any recommendation for copying one base to another one ?
Thanks
Philippe
