Recently i ran into the issue of purging the 20GB database created by HA using mariaDB which caused the system running on Raspi 4, 8GB to completely freeze until a power loop is done.
I managed to manually delete the tables using PHPmyAdmin add-on and start fresh.
I also added exclude command in the configuration file leaving only the sensors that i am interested in to keep their records.
The issue: I noticed that some sensors are being recorded multiple times under the same timestamp, which means the database will grow fast for no reason.
Anyone can tell me what cause duplication of records?
and how to stop it from happening.
Image included!
