<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"> <META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7036.0"> <TITLE>Slow performance with Nagios 1.1 and MYSQL</TITLE> </HEAD> <BODY>  First off, let me say I love nagios keep up the great work. I upgraded 1.0 to 1.1 yesterday, and as part of that upgrade I setup db support via mysql. Since the upgrade, generating any graph or report is god awful slow. I’ve seen a couple of post regarding the subject but most people do supply any details so here I go. Example: When I run the “Most Recent Alerts” report (<A HREF="http://">http://</A>server.remove.com /nagios/cgi-bin/summary.cgi) and I select “25 Most Recent Hard Alerts”. It will take 2 mins to generate. I’m only monitoring 4 hosts with this box and a total of 29 services. Here is a TOP from the box while the script is running: last pid: 34215; load averages: 0.49, 0.17, 0.09 up 3+15:09:57 12:34:08 63 processes: 2 running, 61 sleeping CPU states: 80.5% user, 0.0% nice, 15.4% system, 1.8% interrupt, 2.3% idle Mem: 47M Active, 121M Inact, 60M Wired, 13M Cache, 35M Buf, 652K Free Swap: 489M Total, 32M Used, 457M Free, 6% Inuse PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND 34203 www 114 0 1728K 1076K RUN 0:31 88.62% 72.46% summary.cgi Here is a TOP after its running: last pid: 34517; load averages: 0.24, 0.22, 0.12 up 3+15:11:50 12:36:01 66 processes: 1 running, 65 sleeping CPU states: 0.0% user, 0.0% nice, 9.1% system, 0.0% interrupt, 90.9% idle Mem: 47M Active, 125M Inact, 60M Wired, 11M Cache, 35M Buf, 656K Free Swap: 489M Total, 32M Used, 457M Free, 6% Inuse PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND 94559 www 4 0 8844K 5220K sbwait 0:09 1.46% 1.46% httpd Here are the configure options I used when I compiled nagios: CPPFLAGS="-I/usr/include -I/usr/local/include/mysql" LDFLAGS="-L/usr/lib -L/usr/local/lib/mysql -L/lib" ./configure --prefix=/usr/local \ --with-mysql-comments \ --with-mysql-downtime \ --with-mysql-retention \ --with-mysql-status \ --with-mysql-inc=/usr/local/include/ \ --with-mysql-lib=/usr/local/lib/mysql \ --with-command-user=nagios \ --with-command-grp=www \ --with-nagios-user=nagios \ --with-nagios-grp=nagios \ --with-template-objects \ --with-template-extinfo \ --with-init-dir=/usr/local/etc/rc.d \ --sbindir=/usr/local/share/nagios/cgi-bin \ --libexecdir=/usr/local/libexec/nagios \ --datadir=/usr/local/share/nagios \ --sysconfdir=/usr/local/etc/nagios \ --localstatedir=/usr/local/var/nagios \ --with-gd-lib=/usr/local/lib \ --with-gd-inc=/usr/local/include/gd Thanks for any help in advance: Regards Joe </BODY> </HTML>