Hi, I need to decrease the size of my database that is over 300GB with 6 months of use.
I have about 500 hosts, I have already read several tutorials and documentation, I have made several changes such as increasing the checking time, I reduced the history to 7 days, the trends I left with 365 because it is the most important for me (graphics).
I have already activated housekeeping, which runs every 1 hour and set to 0 to have no limit during the exclusion (aware of the risks).
1. My question is, can I perform a truncate on the history_text or history_unit tables WITHOUT losing the data in the graphs? Or is there a way to decrease the base size without losing the information displayed via zabbix graphics? I understood that the data comes from trends, so we can keep it for a longer period, but I don't know where the data used in the graphs is collected from and the impact of executing what I'm asking.
2. Can I force the graphics generation again? I think our dba did something wrong in the zabbix database, I have 120gb of data in the history tables but less than 100mb in the trends table. My graphs don't show old values, just recent ones
When I see only the values via the zabbix web interface, the data is there but it is not displayed as graphs, only the data for this week after restoring the base, this occurs with all hosts and items, any period. My database has 6 months of data but graphs only show data for a week
I'm using Zabbix 4.4, with mariadb version 5.5.64 in Innodb, with CentOS 7 x64.
I have easy access to DBA consultants, but they don't know how Zabbix works so I need to guide them on what should be done, "how to do it" is up to them.
I have about 500 hosts, I have already read several tutorials and documentation, I have made several changes such as increasing the checking time, I reduced the history to 7 days, the trends I left with 365 because it is the most important for me (graphics).
I have already activated housekeeping, which runs every 1 hour and set to 0 to have no limit during the exclusion (aware of the risks).
1. My question is, can I perform a truncate on the history_text or history_unit tables WITHOUT losing the data in the graphs? Or is there a way to decrease the base size without losing the information displayed via zabbix graphics? I understood that the data comes from trends, so we can keep it for a longer period, but I don't know where the data used in the graphs is collected from and the impact of executing what I'm asking.
2. Can I force the graphics generation again? I think our dba did something wrong in the zabbix database, I have 120gb of data in the history tables but less than 100mb in the trends table. My graphs don't show old values, just recent ones
When I see only the values via the zabbix web interface, the data is there but it is not displayed as graphs, only the data for this week after restoring the base, this occurs with all hosts and items, any period. My database has 6 months of data but graphs only show data for a week
I'm using Zabbix 4.4, with mariadb version 5.5.64 in Innodb, with CentOS 7 x64.
I have easy access to DBA consultants, but they don't know how Zabbix works so I need to guide them on what should be done, "how to do it" is up to them.
Comment