Check what is writing so many times to dB

[poudenes]

Hi All,

Is there a way to check what device is writing so many data to dB?
I checked the recorder, history part but cant find it.

The led of SSD is blinking all the time…

Cheers,

[VDRainer]

Take a look here:

MariaDB growing too big... Can't get it smaller

Fire up a MySQL/MariaDB client and try something like select entity_id,count(*) cnt from states group by entity_id order by cnt desc limit 20; to see what entities are generating lots of events.