Zabbix – Corrupt Events Table fix

I had to re create my events table then drop the old from the DB to get round an issue with mysql crashing. To do this i did the following #mysql -p use zabbix; SET FOREIGN_KEY_CHECKS=0; CREATE TABLE events_new LIKE events INSERT INTO events_new SELECT * FROM events ALTER TABLE events RENAME events_old ALTER TABLE Read more about Zabbix – Corrupt Events Table fix[…]

Cleaning up the Zabbix database

Your issues are going to come from this table history_uint, which holds the items history data. Since this is not an official procedure, use it at your own risk. Environment: Zabbix v3.0 MySql 5.1 – InnoDB with innodb_file_per_table=ON Step 1 – Stop the Zabbix server Step 2 – Open your favourite MySQL client and create a Read more about Cleaning up the Zabbix database[…]

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 Read more about Zabbbix Database is Down[…]

Monitoring MySQL with Zabbix

taken from – How To Setup MySQL Enterprise Monitoring with Zabbix 1 Reply This article is NOT about how to setup the application called MySQL Enterprise Monitor but rather how to setup MySQL monitoring in your Zabbix Enterprise Monitoring software. Zabbix is fucking nice and gives a lot of functionality that you normally have to Read more about Monitoring MySQL with Zabbix[…]