<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Arial; font-size: 12pt; color: #000000'>Thanks. We'll try this.<br><br>----- Original Message -----<br>From: "Raymond DeRoo" <rderoo@deroo.net><br>To: "CLUE's mailing list" <clue@cluedenver.org><br>Sent: Monday, May 23, 2011 1:48:22 PM<br>Subject: Re: [clue] [TECH] CLUE website is back up , goes fast , then goes slow<br><br>Folks--<br><br>> It sounds like there is a memory leak somewhere. After a restart or the DB is restarted the website is very fast. A few hours later it will start to crawl. Eventually the server is unresponsive and the site is down. There have been reports of the OOM killer taking down the mysqld before. It sounds like someone needs to look at it who is familiar with database tuning. <br><br>I do that for a living...<br><br>sudo /etc/init.d/mysql restart <br>mysqladmin -u user -pPASSWD -i 60 -c 360 -r extended-status > mysql_report.txt &<br>iostat -kxt 30 720 > mysql_iostat.txt &<br>vmstat 30 720 > mysql_vmstat.txt &<br><br>Send me the output of those along with a copy of the my.cnf file and let's see where leads us.<br><br>.r<br>_______________________________________________<br>clue mailing list<br>clue@cluedenver.org<br>http://cluedenver.org/mailman/listinfo/clue<br></div></body></html>