High consumption Mysql database (version 5.7)

[jvsousa]

After a few months of updating to version 5.0.2, we started to have high processing consumption in the database. Where we identified that many sessions (for example 700 simultaneous sessions) with an execution time above 100s each cause this high consumption. The origin of these executions is from the application server.


select p.eventid,p.objectid,p.r_eventid,t.tag,t.value from problem p left join problem_tag t on p.eventid=t.eventid where p.source=0 and p.object=0 and mod(p.eventid,500)=487 order by p.eventid;


The difference between the executions is that the number "487" changes.

And with this high consumption the application is slow and has a yellow stripe with the message "The Zabbix server is not running: the information presented may not be current."

Would anyone know what this query would be and how can we solve this high consumption?


Thanks

[tim.mooney]

I think you should update to zabbix-server 5.0.7 or 5.0.8 or whatever is latest in the 5.0 LTS series. There were others that experienced DB performance issues with the early 5.0 releases. I believe a fix was made for some of the performance issues one of the point releases.