interruption on zabbix server

[alucard95]

Hi all,

Just for conclude about the problem of gap in graph.
I did not yet use database partitions (I work on it ) but I resolv my problem which was that table history_uint was too high and any works on it overload the database server, there were approximatively 12 000 000 records (because I put the housekeeper frequency at 24, not a good idea , but even with a frequency at 1, there were slowdowns and gap each hour).

So, to resolv:

- Stop zabbix server

- Erase table history_uint (truncate table history_uint) because it was really too high and I don't need to keep it (this time )

- Change value of field history in each Items (I put 2). I increase this field only when it is absolutely necessary

- Start Zabbix

Thanks for your help

[rodrigo.root.rj]

I understand

then this problem is due to the bank being overwhelmed. if i remove the internal bank and a bank put the sternum problem can be solved?
because i have the same problem and the sternum is my bank, i believe it should already be rolling in an overload of zabbix foreign bank which i believe can improve this problem is to make a cluster of database





pt-original {Então este problema é devido ao banco estar sobrecarregado.
Se eu retirar o banco interno e colocar um banco esterno o problema tende a ser resolvido?Porque eu tenho o mesmo problema e o meu banco é esterno, acredito que ja deve estar rolando uma sobrecarga do zabbix neste banco externo o que acredito que possa melhorar este problema é fazer um cluster deste banco}