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

[JensH]

Version for openhab3.jdbc.persistence in new thread under tutorials and examples with updated syntax in DSL rules:

Database Maintenance openhab3.jdbc.mysql / Garbage Collection

Part One: Deleting Old Values after time If you want to cleanup Old Item-Data all code can be send directly in SQL-Database. For jdbc-mysql-persistence all Commands have to be send in SQL (for example in SQL Window in phpmyadmin). has to be changed to your exact table name, you can see in phpmyadmin. Changes needed with Update from Version 2.5 :NONE Following Examples are tested with openhab 3.0.1 Release Build 1.1) Alter Table for Items to set maximal history of data as last column ALTER …