From owner-freebsd-hackers@FreeBSD.ORG Sun Aug 1 18:24:04 2004 Return-Path: Delivered-To: freebsd-hackers@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 381E316A4CE for ; Sun, 1 Aug 2004 18:24:04 +0000 (GMT) Received: from priv-edtnes28.telusplanet.net (outbound04.telus.net [199.185.220.223]) by mx1.FreeBSD.org (Postfix) with ESMTP id C7D8943D39 for ; Sun, 1 Aug 2004 18:24:03 +0000 (GMT) (envelope-from pfak@telus.net) Received: from hartkiem2nnl7x ([206.116.24.146]) by priv-edtnes28.telusplanet.netSMTP <20040801182403.FZBY19943.priv-edtnes28.telusplanet.net@hartkiem2nnl7x>; Sun, 1 Aug 2004 12:24:03 -0600 Message-ID: <001201c477f4$bb6f84f0$bb01a8c0@hartkiem2nnl7x> From: "Peter Kieser" To: "adp" References: <00dd01c47775$0087df40$0200a8c0@THEBOX> Date: Sun, 1 Aug 2004 11:24:07 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 cc: freebsd-hackers@freebsd.org Subject: Re: FreeBSD and MySQL - mysqld eats CPU alive X-BeenThere: freebsd-hackers@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Technical Discussions relating to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 01 Aug 2004 18:24:04 -0000 Hello, I've experienced this exact problem, all the way from 4.4-STABLE as well. The time period where the issue starts happening is very erradic, but I'm having the exact issue on one of my servers at this very moment. I thought it was just an issue with my box, and not anyone elses. mysql 237 93.9 3.4 59336 17460 con- R 21Jul04 2797:08.26 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --use r=mysql --pid-file= The box isn't exactly heavily loaded, with may 10 QPS; so I don't think it has to do anything with load. Currently I'm running mysql-server-4.0.17 on FreeBSD 4.10-STABLE. FreeBSD x.x 4.10-STABLE FreeBSD 4.10-STABLE #2: Wed Jul 21 18:31:49 PDT 2004 peter@x.x:/usr/src/sys/compile/PSYCHO i386 --Peter ----- Original Message ----- From: "adp" To: Cc: ; Sent: Saturday, July 31, 2004 8:08 PM Subject: FreeBSD and MySQL - mysqld eats CPU alive > > Anyone experienced this problem? Is it mysqld or FreeBSD? I can't pinpoint > the exact issue. >