Zabbix Database Cleanup – Delete Old Data

Few posts on the internet about this but quickest way i found of deleting old data below. Save the below code as .sql and run from the server with… #mysql zabbix -p ./deleteolddata.sql SQL CODE – — intervals in days SET @history_interval = 7; SET @trends_interval = 90; DELETE FROM alerts WHERE (UNIX_TIMESTAMP(NOW()) – clock) Read more about Zabbix Database Cleanup – Delete Old Data[…]