Zabbix database partitioning

  • by

A huge benfit to database performance improvements.
Instead of Zabbix server going throigh all the database to clean it out for out of date records which are cleaned every 60 days (depedning on your settings). We can set the database to cut out and delete these chunks of old data without any extra effort from Zabbix. That can be a massive amount of data when managing hundreds of items of data of 1 second to 1 hourly chunks of received information.

refs:
https://bestmonitoringtools.com/zabbix-partitioning-tables-on-mysql-database/
https://blog.zabbix.com/partitioning-a-zabbix-mysql-database-with-perl-or-stored-procedures/13531/

Leave a Reply

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