Hello
I’m running centreon version 2.8.26 and 2 poller running version 18.10
I know my version is old but was working.
Recently cpu load increase every day from 20h to 11h.
Top indicate cpu usage came from mysqld
From mysql show full processlist I can see following sql queries during high CPU load
This queries seems to proceed in loop
Do you what feature or configuration can cause this kind of SQL query that look very complicated
| 407559 | centreon | localhost | centreon_storage | Query | 16 | Sending data | SELECT
h.host_id,
h.name,
h.address,
s.checked as has_been_checked,
s.description as service_description,
s.display_name,
s.display_name as alias,
s.notes,
s.check_command,
s.perfdata,
s.output,
s.state as current_state,
s.last_check,
s.next_check,
s.state_type,
s.check_attempt as current_check_attempt,
s.max_check_attempts,
s.last_state_change,
s.last_hard_state,
s.last_hard_state_change,
s.acknowledged as problem_has_been_acknowledged,
d.start_time as downtime_start,
d.end_time as downtime_end,
d.author as downtime_author,
d.comment_data as downtime_data
FROM services s
LEFT JOIN hosts h
ON s.host_id=h.host_id
LEFT JOIN downtimes d
ON (d.host_id = h.host_id AND d.service_id=s.service_id AND d.start_time < UNIX_TIMESTAMP() AND d.end_time > UNIX_TIMESTAMP() AND d.deletion_time IS NULL)
WHERE (d.downtime_id IS NULL OR d.downtime_id IN (
SELECT MAX(d.downtime_id) as downtime_id
FROM downtimes d where d.host_id = h.host_id AND d.service_id = s.service_id AND d.start_time < UNIX_TIMESTAMP() AND d.end_time > UNIX_TIMESTAMP() AND d.deletion_time IS NULL
)
)
AND s.host_id = h.host_id AND s.enabled = 1 AND h.enabled = 1
Best answer by gaarby
View original