Zabbix database overwhelmed by queries from Zabbix web server, site down.

[jobrien]

I setup a brand new deployment and the Zabbix web nodes are constantly making updates to my database server:

| 0.000 || 35359 | zabbix | mywebnode01:48655 | zabbix | Query | 357948 | Update | INSERT INTO sessions (sessionid,userid,lastaccess,status) VALUES ('value1','2','value2','0')

That INSERT INTO sessions statement repeats so often and so frequently that my database is sitting at 190% CPU usage. My web console is gone and the only way to "fix" this is to kill my mariadb instance. I cannot stop and restart it.

I have stopped the Web servers and the database node is still sitting at 190% CPU. Does anyone have an idea where I should start to troubleshoot this? I've already looked at the my.cnf file and it matches a working node.

[jaydee]

Hello,

Although it was not the same situation, I have experienced a request and a Zabbix database overload due to automatic discovery rules.

Check the used templates for your hosts whether they have loads of items, that may have been created by such a discovery rule.

Regards, Jay