Mysql persistence: maintenance scripts

[JensH]

Just took the Quest and added Tutorial for deletion of tables from unused items after some time of Inactivity. Same Thread:

"Garbage Collection" on MySQL persistence: deleting old Item states

Intro If you’re using OpenHAB2’s persistence for some reason or another, you will sooner or later come to one question: why do I save all those old states, which I don’t Need for. My OH2 was running for nearly a year now and I persist nearly all items and the size of the DB growing by the day. So I wrote basically a stored procedure in MySQL to come up with a garbage collection. Why directly in the database? I don’t use other persistences and I don’t want to mess around with connections, the ri…