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[…]
Few posts on the internet about this but quickest way i found of deleting old data below. Save the below code as .sql and run from the server with… #mysql zabbix -p ./deleteolddata.sql SQL CODE – — intervals in days SET @history_interval = 7; SET @trends_interval = 90; DELETE FROM alerts WHERE (UNIX_TIMESTAMP(NOW()) – clock) Read more about Zabbix Database Cleanup – Delete Old Data[…]
Step 1 – Stop Apache # Stop Apache Web Server in SysVinit Systeme # # service zabbix-server stop # Stop Apache Web Server in Systemd Systeme # # systemctl stop zabbix-server Step 2 – Backup SQL # mysqldump -u root -p zabbix > zabbix.sql Step 3 – Back up configuration files, PHP files and Zabbix Read more about Zabbix Upgrade/Update Process – Step by Step[…]
How i fixed it… Im running my zabbix server on ubuntu – Open your sysctl.conf and assign an amount of shared memory #vi /etc/sysctl.conf: My setting below – 1 kernel.shmmax=2834217728 This gives you 2.6gb of shared space To apply changes in the /etc/sysctl.conf immediately, execute: 1 2 # sysctl -p kernel.shmmax = 2834217728 Now edit Read more about Zabbix: Less than 25% free in the configuration cache[…]
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[…]