FreenetIS

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.