Akce
Požadavek #439
uzavřenýPožadavek #379: Optimalizace
Optimalizace updatu monitoringu
Začátek:
2012-12-20
Uzavřít do:
% Hotovo:
100%
Odhadovaná doba:
1:00hod
Popis
Optimalizace updatu monitoringu (SQL dotazu) příklad nového dotazu:
UPDATE monitor_hosts mh SET state = 1, state_changed = IF(state <> 1, 1, 0), state_changed_date = IF(state <> 1, NOW(), state_changed_date), last_attempt_date = NOW(), latency_current = '1.37\n', latency_min = IF('1.37\n' IS NOT NULL AND (latency_min IS NULL OR latency_min > '1.37\n'), '1.37\n', latency_min), latency_max = IF('1.37\n' IS NOT NULL AND (latency_max IS NULL OR latency_max < '1.37\n'), '1.37\n', latency_max), latency_avg = (IFNULL(latency_avg,0) * (polls_total - polls_failed) + '1.37\n')/(polls_total + 1 - polls_failed - 0), polls_total = polls_total + 1, polls_failed = polls_failed + 0, availability = ROUND((polls_total + 1 - polls_failed - 0)/(polls_total + 1)*100, 2) WHERE mh.device_id IN ( SELECT i.device_id FROM ip_addresses ip JOIN ifaces i ON ip.iface_id = i.id WHERE ip_address = '10.143.0.242' );
Změnit ve všech větvích.
Akce