From owner-freebsd-hackers@FreeBSD.ORG Wed Aug 4 22:12:28 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 D3B1816A4CE for ; Wed, 4 Aug 2004 22:12:28 +0000 (GMT) Received: from mxfep02.bredband.com (mxfep02.bredband.com [195.54.107.73]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9522843D5E for ; Wed, 4 Aug 2004 22:12:27 +0000 (GMT) (envelope-from peter.schuller@infidyne.com) Received: from scode.mine.nu ([83.226.138.222] [83.226.138.222]) by mxfep02.bredband.com with ESMTP id <20040804221226.OUAI23867.mxfep02.bredband.com@scode.mine.nu>; Thu, 5 Aug 2004 00:12:26 +0200 Received: from localhost (localhost [127.0.0.1]) by scode.mine.nu (Postfix) with ESMTP id 47CBD5DF66; Thu, 5 Aug 2004 00:21:52 +0200 (CEST) From: Peter Schuller To: freebsd-hackers@freebsd.org Date: Thu, 5 Aug 2004 00:21:48 +0200 User-Agent: KMail/1.6.2 References: <00dd01c47775$0087df40$0200a8c0@THEBOX> <001201c477f4$bb6f84f0$bb01a8c0@hartkiem2nnl7x> In-Reply-To: <001201c477f4$bb6f84f0$bb01a8c0@hartkiem2nnl7x> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200408050021.48595.peter.schuller@infidyne.com> cc: Peter Kieser cc: adp 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: Wed, 04 Aug 2004 22:12:28 -0000 > 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. I've seen this on two machines (both 5.2). When I built mysql with linuxthreads the problem went away. Alternatively I've seen talk of name resolution causing problems due to a non-thread-safe implementation of gethostbyname() - this too manifested itself as abnormal CPU usage. In my case --skip-name-resolve didn't help, but perhaps it might for you guys. -- / Peter Schuller, InfiDyne Technologies HB PGP userID: 0xE9758B7D or 'Peter Schuller ' Key retrieval: Send an E-Mail to getpgpkey@scode.org E-Mail: peter.schuller@infidyne.com Web: http://www.scode.org