From owner-freebsd-questions@FreeBSD.ORG Sun Aug 1 03:52:23 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 06C0E16A4CF for ; Sun, 1 Aug 2004 03:52:23 +0000 (GMT) Received: from ns1.tiadon.com (SMTP.tiadon.com [69.27.132.161]) by mx1.FreeBSD.org (Postfix) with ESMTP id AF17E43D45 for ; Sun, 1 Aug 2004 03:52:22 +0000 (GMT) (envelope-from kdk@daleco.biz) Received: from [69.27.131.0] ([69.27.131.0]) by ns1.tiadon.com with Microsoft SMTPSVC(6.0.3790.0); Sat, 31 Jul 2004 22:55:44 -0500 Message-ID: <410C68E7.1060002@daleco.biz> Date: Sat, 31 Jul 2004 22:52:07 -0500 From: "Kevin D. Kinsey, DaleCo, S.P." User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.7) Gecko/20040712 X-Accept-Language: en-us, en MIME-Version: 1.0 To: adp References: <00dd01c47775$0087df40$0200a8c0@THEBOX> In-Reply-To: <00dd01c47775$0087df40$0200a8c0@THEBOX> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 01 Aug 2004 03:55:45.0104 (UTC) FILETIME=[6C125500:01C4777B] cc: questions@freebsd.org Subject: Re: FreeBSD and MySQL - mysqld eats CPU alive X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 01 Aug 2004 03:52:23 -0000 Before the rest of the message ... I think it'd be best not to "shotgun" your mails like this... adp wrote: >I recently posted the following message to MySQL discussion list. The >response there, and the one I keep finding on Google, is that this is a >long-standing issue betweeen FreeBSD and MySQL. For me this has been >happening since FreeBSD 4.4. > >I have one site where we are going to have to move to Linux. I would much >prefer keeping us on FreeBSD, but we just can't afford the downtime anymore. >Another site is looking at moving to PostgreSQL on FreeBSD. > >Any help on this? Googling shows a long history of people having these >problems but no solutions. Please don't give me a URL to a Google showing >others having this problem--I've seen that and more. I want to know if there >is a solution. Any help is appreciated! > >... > >I have several MySQL and FreeBSD installs across a few different sites, and >I consistently have problems with mysqld. It will begin to eat up all of the >CPU and eventually become unresponsive (or the machine will just burn). I >can't seem to manually reproduce this, but given enough time a FreeBSD box >with mysqld will go down. > >Our servers are generally heavily loaded. > >I would say that I'm doing something wrong (although what I could be doing >wrong I'm not sure), but I recently began working with another company that >has the EXACT SAME PROBLEM. They are even thinking of moving to PostgreSQL, >but we are trying to fix mysqld instead for now. > >This behavior has been seen on: > >FreeBSD 4.4, 4.7, 4.9, 4.10 >MySQL 3.x and 4.x >Typical load: 50 qps >With and without replication enabled. >Some sites are SELECT heavy, some are INSERT heavy. > >For one site I think we will be moving from FreeBSD to Linux for the MySQL >servers since MySQL seems to run like a champ on Linux. We will continue to >use FreeBSD for everything else. > >Anyone experienced this problem? Is it mysqld or FreeBSD? I can't pinpoint >the exact issue. > > It's certain combinations of the two, best I can tell. Looks like you can stay with FBSD if you want to do the tweaking --- be sure and read the second article if your are going to read the first .... "FreeBSD or Linux for your MySQL Server?" http://jeremy.zawodny.com/blog/archives/000203.html "Revisiting FreeBSD vs. Linux for MySQL" http://jeremy.zawodny.com/blog/archives/000697.html HTH, Kevin Kinsey DaleCo, S.P.