Zabbix MySQL Queries going stale in the DB
We are monitoring some of our cloud applications with a few zabbix-proxy's connecting to one zabbix-server. For every 7 to 10 days mysql queries on the database goes stale or just hangs until a DB restart happens followed by a zabbix-server and apache2 restart.
Both zabbix-server and zabbix-DB machines are pretty huge. Physical, 130G memory and 48 cores. Most of the DB stuff has been verified.
Other thing we have noticed during every outage is that we see more than 1500 connections in the database running
" SELECT dv.mandatory,dv.optional FROM dbversion dv" sql.
Normally, we have around 300 connections in mysql database out most of them are in sleep mode but during the issue we huge counts of that query leading to an outage.
Can you please shed some light on the sql and if that is something causing the issue ?
Zabbix Version: 2.4.6
Zabbix Proxy: 2.4.6
Zabbix Proxy DB: MySQL db 5.6
Zabbix Server DB Version: MySQL 5.5
Thanks in Advance !!
Both zabbix-server and zabbix-DB machines are pretty huge. Physical, 130G memory and 48 cores. Most of the DB stuff has been verified.
Other thing we have noticed during every outage is that we see more than 1500 connections in the database running
" SELECT dv.mandatory,dv.optional FROM dbversion dv" sql.
Normally, we have around 300 connections in mysql database out most of them are in sleep mode but during the issue we huge counts of that query leading to an outage.
Can you please shed some light on the sql and if that is something causing the issue ?
Zabbix Version: 2.4.6
Zabbix Proxy: 2.4.6
Zabbix Proxy DB: MySQL db 5.6
Zabbix Server DB Version: MySQL 5.5
Thanks in Advance !!