BigMonitor
06-12-2008, 12:42 AM
I am running this on a nagios server with 1000+ services. The main page takes a long time to load because of a slow mysql query.
I am looking into this and will either add indexes or rewrite this query:
SELECT nagios_services.host_object_id, nagios_hoststatus.current_state FROM nagios_servicestatus, nagios_hoststatus, nagios_services, nagios_objects WHERE nagios_servicestatus.service_object_id = nagios_services.service_object_id AND nagios_services.host_object_id = nagios_hoststatus.host_object_id AND nagios_objects.is_active = 1 GROUP BY nagios_services.host_object_id;
I am looking into this and will either add indexes or rewrite this query:
SELECT nagios_services.host_object_id, nagios_hoststatus.current_state FROM nagios_servicestatus, nagios_hoststatus, nagios_services, nagios_objects WHERE nagios_servicestatus.service_object_id = nagios_services.service_object_id AND nagios_services.host_object_id = nagios_hoststatus.host_object_id AND nagios_objects.is_active = 1 GROUP BY nagios_services.host_object_id;