Bruno Blanes BrunoBlanes

🧩

Constantly learning

Electrical Engineer student learning something new everyday.

BrunoBlanes / zabbix_partitioning.sql

Created July 16, 2022 21:56

MySQL v8 script for partitioning the Zabbix database while also deleting old partitions

	DELIMITER $$
	USE zabbix$$

	DROP PROCEDURE IF EXISTS manage_partitions$$
	CREATE PROCEDURE manage_partitions()
	BEGIN
	-- Change these according to your settings
	DECLARE zabbix_db_name VARCHAR(64) DEFAULT 'zabbix';
	DECLARE trends_storage_period INT DEFAULT UNIX_TIMESTAMP(DATE(NOW() - INTERVAL 5 YEAR));
	DECLARE history_storage_period INT DEFAULT UNIX_TIMESTAMP(DATE(NOW() - INTERVAL 1 YEAR));