Hello,
I have 18 Aqara temperature sensors and two power plugs in a system running for slightly more than a year. Values gotten from those entitys are stored in an Influx database. Now I’ve created a backup of the system and the size of the backup file already exceeds 0.5GB, which was surprising to me. Even if I’m getting 18 x ~5 numbers every 5 minutes, I did not expect the file size rising that quickly, especially not in a database I was assuming it would be made for storing time series in an optimized way. But somewhere I guess I was wrong.
Now I’m afraid that if the system and the data keep on growing, the available space will not be sufficient and at one point in time I will need to reset everything and lose all temperature statistics I’ve gathered so far.
To just postpone this event to the farest point possible, I would like to ask two questions:
- Is there a (convenient) way to get the system configured to only store certain values or to skip e.g. the voltage of those sensors and to completely skip values of the power plugs?
- Is there a way to remove already stored values from one entity completely from the DB, like all stored voltage values?
Thank you