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.