Hi all,
We are in the process of transitioning to using database partitioning, as opposed to Zabbix's Housekeeper for our History and Trends tables as the database is growing at an alarming rate (expected) and thus is becoming a bottleneck.
Having read through the documentation (https://zabbix.org/wiki/Docs/howto/mysql_partition), I have got to the point of setting the days to keep, hourly interval and number of future intervals to create.
When creating items in Zabbix, we typically go by 30 days of history, and 365 days of trend data to keep.
We have come up with the following:-
* Days to keep = 30 for history, and 365 for trend
* Hourly interval = 672 ( 4 weeks in hours )
* Number of intervals to create = 3
Looking through the docs, it seems to suggest that, you can shrink the partitioning down so that the hourly interval or days to keep is less, however you cannot do the reverse (extend). As a starting point, we decided to go for partitioning every 4 weeks (with the option to shrink this at a later date), days to keep would be 30 days for history, and 365 for trend, and number of intervals to create as 3 (as you don't ever want to run out of partitions!!!).
What I am struggling to understand, is the Zabbix Housekeeper runs every hour. So should I be setting the hourly interval to 1, go mimic this?
Any help would be greatly appreciated, as our database is growing rather rapidly!!!
Thanks in advance.
We are in the process of transitioning to using database partitioning, as opposed to Zabbix's Housekeeper for our History and Trends tables as the database is growing at an alarming rate (expected) and thus is becoming a bottleneck.
Having read through the documentation (https://zabbix.org/wiki/Docs/howto/mysql_partition), I have got to the point of setting the days to keep, hourly interval and number of future intervals to create.
When creating items in Zabbix, we typically go by 30 days of history, and 365 days of trend data to keep.
We have come up with the following:-
* Days to keep = 30 for history, and 365 for trend
* Hourly interval = 672 ( 4 weeks in hours )
* Number of intervals to create = 3
Looking through the docs, it seems to suggest that, you can shrink the partitioning down so that the hourly interval or days to keep is less, however you cannot do the reverse (extend). As a starting point, we decided to go for partitioning every 4 weeks (with the option to shrink this at a later date), days to keep would be 30 days for history, and 365 for trend, and number of intervals to create as 3 (as you don't ever want to run out of partitions!!!).
What I am struggling to understand, is the Zabbix Housekeeper runs every hour. So should I be setting the hourly interval to 1, go mimic this?
Any help would be greatly appreciated, as our database is growing rather rapidly!!!
Thanks in advance.