Simple zabbix mysql/mariadb housekeeping script to maintain zabbix.history and zabbix.history_uint tables
I've just finished a simple houseskeeping/maintenance script for zabbix if you use mariadb or mysql as database.
You can find it here.
It installs a systemd timer to automatically run optimize
on the two tables zabbix.history
and zabbix.history_uint
.
All you have to do is to add your username and passwort to the created file /etc/net.bazzline/zabbix/housekeeping/local_configuration.sh
.