Skip to content

Instantly share code, notes, and snippets.

@lcuevastodoit

lcuevastodoit/clean-zabbix-db.txt

Created September 14, 2020 19:49
Show Gist options
  • Save lcuevastodoit/0620b11c2592ee26bca5118474ab29b8 to your computer and use it in GitHub Desktop.
Save lcuevastodoit/0620b11c2592ee26bca5118474ab29b8 to your computer and use it in GitHub Desktop.
Download ZIP
Clean Zabbix Database
Raw
clean-zabbix-db.txt
mv /etc/supervisor/conf.d/supervisord_server.conf /etc/supervisor/conf.d/supervisord_server.conf.old
#reboot zabbix container
mysql -uroot -p
use zabbix;
Database changed
mysql> TRUNCATE TABLE history_uint;
Query OK, 0 rows affected (0.66 sec)
mysql> TRUNCATE TABLE history;
Query OK, 0 rows affected (0.52 sec)
mysql> TRUNCATE TABLE history_text;
Query OK, 0 rows affected (0.17 sec)
exit
mv /etc/supervisor/conf.d/supervisord_server.conf.old /etc/supervisor/conf.d/supervisord_server.conf
#reboot zabbix container
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment