+1.

The problem isn't just the database query, but also the size of the result (over 2mb).

With kind regards, Patrick Uiterwijk Fedora Infra

----- Original Message -----

Right now we have nagios checking "https://bodhi.fedoraproject.org/updates/"

which requires a db query to get all the updates.

I'd like to change it to just "https://bodhi.fedoraproject.org/" which shouldn't require as much db load.

+1s?

kevin

diff --git a/roles/nagios_server/files/nagios-external/services/websites.cfg b/roles/nagios_server/files/nagios-external/services/websites.cfg index 24e5051..d3906ec 100644 --- a/roles/nagios_server/files/nagios-external/services/websites.cfg +++ b/roles/nagios_server/files/nagios-external/services/websites.cfg @@ -16,7 +16,7 @@ define service { host_name 209.132.181.16-phx2, 85.236.55.6-internetx, proxy03.fedoraproject.org, 152.19.134.142-ibiblio, proxy06.fedoraproject.org, 213.175.193.206-bodhost, 67.203.2.67-coloamerica service_description bodhi max_check_attempts 8

• check_command

check_website_ssl!bodhi.fedoraproject.org!/updates/!Fedora

• check_command check_website_ssl!bodhi.fedoraproject.org!/!Fedora use websitetemplate

}

diff --git a/roles/nagios_server/files/nagios/services/websites.cfg b/roles/nagios_server/files/nagios/services/websites.cfg index 02490ef..3248f38 100644 --- a/roles/nagios_server/files/nagios/services/websites.cfg +++ b/roles/nagios_server/files/nagios/services/websites.cfg @@ -74,7 +74,7 @@ define service { define service { host_name proxy01-wildcard, proxy02-wildcard, proxy03-fpo, proxy04-fpo, proxy06-fpo, proxy07-wildcard, proxy08-wildcard, proxy05-fpo, proxy10-fpo, proxy11-fpo service_description bodhi

• check_command

check_website_ssl!bodhi.fedoraproject.org!/updates/!Fedora

• check_command check_website_ssl!bodhi.fedoraproject.org!/!Fedora max_check_attempts 8 use websitetemplate

} @@ -82,7 +82,7 @@ define service { define service { host_name bodhi03,bodhi04 service_description bodhi-internal

• check_command check_website!localhost!/updates/!Fedora

• check_command check_website!localhost!/!Fedora max_check_attempts 8 use internalwebsitetemplate

}

---

infrastructure mailing list infrastructure@lists.fedoraproject.org http://lists.fedoraproject.org/postorius/infrastructure@lists.fedoraproject....

_______________________________________________ infrastructure mailing list infrastructure@lists.fedoraproject.org http://lists.fedoraproject.org/postorius/infrastructure@lists.fedoraproject....

On Mon, Sep 14, 2015 at 11:43:59AM -0600, Kevin Fenzi wrote:

Right now we have nagios checking "https://bodhi.fedoraproject.org/updates/"

which requires a db query to get all the updates.

I'd like to change it to just "https://bodhi.fedoraproject.org/" which shouldn't require as much db load.

+1s?

kevin

diff --git a/roles/nagios_server/files/nagios-external/services/websites.cfg b/roles/nagios_server/files/nagios-external/services/websites.cfg index 24e5051..d3906ec 100644 --- a/roles/nagios_server/files/nagios-external/services/websites.cfg +++ b/roles/nagios_server/files/nagios-external/services/websites.cfg @@ -16,7 +16,7 @@ define service { host_name 209.132.181.16-phx2, 85.236.55.6-internetx, proxy03.fedoraproject.org, 152.19.134.142-ibiblio, proxy06.fedoraproject.org, 213.175.193.206-bodhost, 67.203.2.67-coloamerica service_description bodhi max_check_attempts 8

• check_command check_website_ssl!bodhi.fedoraproject.org!/updates/!Fedora

• check_command check_website_ssl!bodhi.fedoraproject.org!/!Fedora use websitetemplate

}

diff --git a/roles/nagios_server/files/nagios/services/websites.cfg b/roles/nagios_server/files/nagios/services/websites.cfg index 02490ef..3248f38 100644 --- a/roles/nagios_server/files/nagios/services/websites.cfg +++ b/roles/nagios_server/files/nagios/services/websites.cfg @@ -74,7 +74,7 @@ define service { define service { host_name proxy01-wildcard, proxy02-wildcard, proxy03-fpo, proxy04-fpo, proxy06-fpo, proxy07-wildcard, proxy08-wildcard, proxy05-fpo, proxy10-fpo, proxy11-fpo service_description bodhi

• check_command check_website_ssl!bodhi.fedoraproject.org!/updates/!Fedora

• check_command check_website_ssl!bodhi.fedoraproject.org!/!Fedora max_check_attempts 8 use websitetemplate

} @@ -82,7 +82,7 @@ define service { define service { host_name bodhi03,bodhi04 service_description bodhi-internal

• check_command check_website!localhost!/updates/!Fedora

• check_command check_website!localhost!/!Fedora max_check_attempts 8 use internalwebsitetemplate

}

+1 here.

_______________________________________________ infrastructure mailing list infrastructure@lists.fedoraproject.org http://lists.fedoraproject.org/postorius/infrastructure@lists.fedoraproject....