MariaDB tables of zabbix and is it safe to truncate them

[kaloyan.s]

Hi all,

I am using zabbix server with a lot of proxies which generates a lot of data.
I have found a solution for now to truncate the biggest MariaDB tables which are - history and history_uint

I didn't face any issues doing this. However i see there are some other tables which are growing as well - history_log.ibd trends_uint.ibd history_text.ibd
My question is if there are any dependencies between all these tables (history.ibd, history_uint.ibd, history_log.ibd, trends_uint.ibd, history_text.ibd) and if it safe to truncate these as well - history_log.ibd trends_uint.ibd history_text.ibd.

Thanks
Regards,
Kaloyan

[kloczek]

If you don't need monitoring data why you are collection those data?
Read sticky topic on "troubleshooting and problems".

https://www.zabbix.com/forum/zabbix-troubleshooting-and-problems/10176-mysql-database-grow-how-optimize-parameters

[kaloyan.s]

Hello kloczek ,

Thank you for your reply. I need monitoring data. I am keeping it until there is performance degradation of the zabbix server. From another topic i found there is a way to truncate the history and history_uint tables and for an year already i am doing so. However i am wondering about the other 3 tables as well. If there are any dependencies between all 5 tables or they can be truncated all without any issues.
I will check the link you provided.

Regards,
Kaloyan