Cleanup script for orphaned data in a Zabbix Database
This repo contains a few useful queries to cleanup old orphaned data in a Zabbix database. While Zabbix does Housekeeping, it does not clear orphaned data very well. Especially if you come from a long upgrade-line (1.x to 1.6 to 1.8 to 2.x), chances are your database is riddled with orphaned data that is consuming disk space.
These queries are safe to run, but if you have a large database please note that these can take a while (read: a few hours is normal).
[email protected]$ mysql -f zabbix < checkscript.sql
or
[email protected]$ ./checkscript.sh [email protected]$ ./checkscript.sh ./zbx_db_info.cnf
Use the queries above on your won risk. Take backups first. Once you have back-ups, go ahead and be brave.
[email protected]$ mysql -f zabbix < cleanup.sql
or
[email protected]$ ./cleanup.sh [email protected]$ ./cleanup.sh ./zbx_db_info.cnf