From owner-freebsd-questions Thu Aug 24 13:39:36 2000 Delivered-To: freebsd-questions@freebsd.org Received: from Astrovan.cstone.net (astrovan.cstone.net [209.145.64.80]) by hub.freebsd.org (Postfix) with ESMTP id 9B01537B423 for ; Thu, 24 Aug 2000 13:39:32 -0700 (PDT) Received: from cstone.net ([209.145.93.143]) by Astrovan.cstone.net (Post.Office MTA v3.5.3 release 223 ID# 0-59789U13500L1350S0V35) with ESMTP id net for ; Thu, 24 Aug 2000 16:31:28 -0400 Message-ID: <39A587FD.62A92098@cstone.net> Date: Thu, 24 Aug 2000 16:39:25 -0400 From: Sean Michael Whipkey X-Mailer: Mozilla 4.75 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: questions@freebsd.org Subject: FreeBSD 3.4, Apache, and MySQL Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG I'm running FreeBSD 3.4 on a dual Pentium 550 box with 512 MB RAM that is colocated at my ISP. We're running Apache 1.3.12 with mod_perl and a slew of options plus MySQL 3.22.27. Our main web page is a perl script that draws info from the MySQL database. Occasionally, mysqld skyrockets in CPU usage until it's at 97%+. The server stops responding and the only way to get it to stop is to log in as mysqladmin, shut it down, then restart safe_mysql. None of the logs (FreeBSD, Apache, MySQL) show any errors at that time. It only seems to happen during business hours. Any ideas of what it could be, and more importantly, how to stop it? Thanks, SeanMike -- SeanMike Whipkey - Damnit. Where's my witty repartee? "Ow! Ow! Ow! I had to go after mutants, didn't I? I couldn't just attack Napster, nooooo. I had to attack freaks that know kung fu." - http://ter.air0day.com/xmen.html To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message