On 3.4.5 Server & MariaDB 10.2
Zabbix housekeeper processes more than 75% busy
Hangins sql's in sending data state
Zabbix housekeeper processes more than 75% busy
Hangins sql's in sending data state
Code:
select
min(clock)
from
events
where
events.source = 3 and events.object = 0
and not exists( select
null
from
problem
where
events.eventid = problem.eventid
or events.eventid = problem.r_eventid);
select
min(clock)
from
events
where
events.source = 0 and events.object = 0
and not exists( select
null
from
problem
where
events.eventid = problem.eventid
or events.eventid = problem.r_eventid)
Comment