Koozali.org: home of the SME Server

5.5 Slowing down (mysql + apache + php)

Brendon

5.5 Slowing down (mysql + apache + php)
« on: October 30, 2002, 01:21:30 PM »
Hi, I'm having a problem where the sme server's website serving is gradually slowing down to the point where serving something like SquirrelMail becomes to slow to be of any use. The computer is a Celeron 500 with 64 MB Ram so it should be able to handle the very light traffic that we have (3 users max at a time). The only anomoly i can see is that it has a 1.2GB hard drive as this was taken from the old server and not upgraded. Otherwise the rest of the equipment is relatively new.

I get the following on a ps -A. There are alot of mysqld processes running and i'm wondering if perhaps they're not terminating properly after use and causing the machine to gradually slow down in this way.

If anyone could give me some pointers on how i could further investigate this problem i would be greatly apreciative.

Here is the ps output:

PID TTY STAT TIME COMMAND
1 ? S 0:05 init [7]
2 ? SW 0:00 [kflushd]
3 ? SW 0:00 [kupdate]
4 ? SW 0:50 [kswapd]
5 ? SW 0:00 [keventd]
6 ? SW< 0:00 [mdrecoveryd]
75 ? SW 0:00 [khubd]
310 ? S 0:00 /usr/local/bin/svscan /service
329 ? S 0:00 \_ supervise qmail
1096 ? S 0:00 | \_ qmail-send
1098 ? SW 0:00 | \_ [qmail-lspawn]
1099 ? S 0:00 | \_ qmail-rspawn
1100 ? S 0:00 | \_ qmail-clean
330 ? S 0:00 \_ supervise log
334 ? S 0:00 | \_ /usr/local/bin/multilog t s5000000 /var/log/qmail
331 ? S 0:00 \_ supervise smtpfront-qmail
1165 ? S 0:00 | \_ /usr/local/bin/tcpserver -U -R -x /etc/tcprules/tcp.smtp.cdb -l 0 0 smtp /usr/local/bin/envdir ./
332 ? S 0:00 \_ supervise log
333 ? S 0:00 \_ /usr/local/bin/multilog t s5000000 /var/log/smtpfront-qmail
353 ? S 0:01 syslogd -m 0 -a /home/dns/dev/log
358 ? SW 0:00 [klogd]
901 ? S 0:00 crond
935 ? S 0:00 xinetd -stayalive -reuse -pidfile /var/run/xinetd.pid
972 ? SL 0:00 ntpd -U ntp
1020 ? SW 0:00 [lpd]
1064 ? S 0:00 [slapd]
1068 ? S 0:00 \_ [slapd]
1069 ? S 0:00 \_ [slapd]
1126 ? S 0:00 httpd
1129 ? S 0:18 \_ httpd
1130 ? S 0:18 \_ httpd
1131 ? S 0:16 \_ httpd
1132 ? S 0:12 \_ httpd
1133 ? S 0:14 \_ httpd
1134 ? S 0:17 \_ httpd
1135 ? S 0:13 \_ httpd
1136 ? S 0:17 \_ httpd
1137 ? S 0:12 \_ httpd
1138 ? S 0:05 \_ httpd
1635 ? S 0:07 \_ httpd
1636 ? S 0:18 \_ httpd
1637 ? S 0:09 \_ httpd
1638 ? S 0:16 \_ httpd
1639 ? S 0:13 \_ httpd
1640 ? S 0:18 \_ httpd
1641 ? S 0:08 \_ httpd
1642 ? S 0:18 \_ httpd
1643 ? S 0:09 \_ httpd
1644 ? S 0:07 \_ httpd
1191 ? S 0:00 /usr/sbin/sshd
2523 ? S 0:00 \_ /usr/sbin/sshd
2524 pts/0 S 0:00 \_ -bash
2576 pts/0 R 0:00 \_ ps -A f w
1334 ? S 0:00 /usr/sbin/httpd-admin -f /etc/httpd/admin-conf/httpd.conf -D HAVE_PERL -D HAVE_PHP4 -D HAVE_PROXY -D HAVE
1337 ? SW 0:00 \_ [httpd-admin]
1359 ? SW 0:00 [safe_mysqld]
1424 ? S 0:00 \_ [mysqld]
1467 ? S 0:00 \_ [mysqld]
1468 ? S 0:00 \_ [mysqld]
1501 ? S 0:00 \_ [mysqld]
1732 ? S 0:00 \_ [mysqld]
1951 ? S 0:00 \_ [mysqld]
2027 ? S 0:00 \_ [mysqld]
2035 ? S 0:00 \_ [mysqld]
2036 ? S 0:00 \_ [mysqld]
2042 ? S 0:00 \_ [mysqld]
2044 ? S 0:00 \_ [mysqld]
2045 ? S 0:00 \_ [mysqld]
2047 ? S 0:00 \_ [mysqld]
2095 ? S 0:00 \_ [mysqld]
2101 ? S 0:00 \_ [mysqld]
2109 ? S 0:00 \_ [mysqld]
2116 ? S 0:00 \_ [mysqld]
2131 ? S 0:00 \_ [mysqld]
2133 ? S 0:00 \_ [mysqld]
2425 ? S 0:00 \_ [mysqld]
2426 ? S 0:00 \_ [mysqld]
2429 ? S 0:00 \_ [mysqld]
2430 ? S 0:00 \_ [mysqld]
2432 ? S 0:00 \_ [mysqld]
1432 ? SW 0:00 [squid]
1436 ? S 0:26 \_ (squid) -D
1466 ? S 0:00 \_ (unlinkd)
1460 ? S 0:00 atalkd
1461 ? S 0:00 smbd -D
1469 ? S 0:00 nmbd -D
1472 ? SW 0:00 \_ [nmbd]
1537 ? S 0:00 [named]
1542 ? S 0:00 \_ [named]
1543 ? S 0:03 \_ [named]
1544 ? S 0:00 \_ [named]
1545 ? S 0:00 \_ [named]
1538 ? SW 0:00 [pptpd]
1539 tty1 SW 0:00 [mingetty]
1540 tty2 SW 0:00 [mingetty]
1541 tty3 SW 0:00 [mingetty]
1560 ? SW 0:00 [papd]
1565 ? SW 0:00 [afpd]


Cheers,

Brendon

Brendon

Re: 5.5 Slowing down (mysql + apache + php)
« Reply #1 on: October 30, 2002, 11:48:46 PM »
Further to this information:

If i run:

/etc/init.d/httpd-e-smith restart
/etc/init.d/mysqld restart
/etd/init.d/mysql.init restart

then the problem clears up until it gradually starts to slow down again after a few days.

Cheers,

Brendon

Carl Milloshewski

Re: 5.5 Slowing down (mysql + apache + php)
« Reply #2 on: November 11, 2002, 10:48:18 PM »
I also am having this problem, I restarted the modules stated above and it looks like it cleared up the slowness problem.

I'd be greatfull for any assistance.