Zabbbix Database is Down

Quick one for notes…when i get a consistent Zabbix Database is down error this gets it back up and running for me –

# mysqlq -p

(login with root password)

mysql> show databases; (just lists the databases on the server)

mysql> use zabbix; (if zabbix is your live db)
mysql> TRUNCATE TABLE history;
mysql> TRUNCATE TABLE history_str;
mysql> TRUNCATE TABLE history_uint;
mysql> TRUNCATE TABLE history_log;
mysql> TRUNCATE TABLE history_text;

Then quit the mysql command and run the following :

mysqlcheck -u root -p --auto-repair --check --all-databases


The issue seems to be around the history_uint table becoming too big or corrupt.

1 thought on “Zabbbix Database is Down

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.