From owner-freebsd-isp@FreeBSD.ORG Tue Aug 2 14:37:25 2005 Return-Path: X-Original-To: freebsd-isp@freebsd.org Delivered-To: freebsd-isp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 133D416A41F for ; Tue, 2 Aug 2005 14:37:25 +0000 (GMT) (envelope-from steve.rieger@tbwachiat.com) Received: from mail83-red-R.bigfish.com (mail-red.bigfish.com [216.148.222.61]) by mx1.FreeBSD.org (Postfix) with ESMTP id ACEFB43D4C for ; Tue, 2 Aug 2005 14:37:24 +0000 (GMT) (envelope-from steve.rieger@tbwachiat.com) Received: from mail83-red.bigfish.com (localhost.localdomain [127.0.0.1]) by mail83-red-R.bigfish.com (Postfix) with ESMTP id 7AD8F3C47E8 for ; Tue, 2 Aug 2005 14:37:24 +0000 (UTC) X-BigFish: VP Received: by mail83-red.bigfish.com (MessageSwitch) id 1122993443987058_26364; Tue, 2 Aug 2005 14:37:23 +0000 (UCT) Received: from tbwachiat.com (unknown [208.244.203.7]) (using TLSv1 with cipher EDH-RSA-DES-CBC3-SHA (168/168 bits)) (No client certificate requested) by mail83-red.bigfish.com (Postfix) with ESMTP id BB48F3C450E for ; Tue, 2 Aug 2005 14:37:23 +0000 (UTC) Received: from [10.20.4.247] steve_rieger [10.20.4.247] by tbwachiat.com with NetMail SMTP Agent $Revision: 3.22.1.16 $ on Novell NetWare via secured & encrypted transport (TLS); Tue, 02 Aug 2005 10:37:22 -0400 In-Reply-To: <42EF8206.5000505@psknet.com> References: <42EF8206.5000505@psknet.com> Mime-Version: 1.0 (Apple Message framework v733) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Content-Transfer-Encoding: 7bit From: Steve Rieger Date: Tue, 2 Aug 2005 10:37:23 -0400 To: Troy Settle X-Mailer: Apple Mail (2.733) Cc: freebsd-isp@freebsd.org, Steve Rieger Subject: Re: MySQL Performance X-BeenThere: freebsd-isp@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 02 Aug 2005 14:37:25 -0000 are you logging if so how large are your log files -- Steve Rieger AIM chozrim ICQ 53956607 Cell 646 335 8915 steve.rieger@tbwachiat.com On Aug 2, 2005, at 10:24 AM, Troy Settle wrote: > > I've a 4-STABLE box on a Dual Xeon w/4GB and U320 RAID: > > 4.11-STABLE FreeBSD 4.11-STABLE #7: Fri Mar 11 20:24:25 EST 2005 > 10:05AM up 55 days, 14:38, 3 users, load averages: 1.07, 1.10, 1.13 > > Running on this box, is MySQL 4.0.23a (a little outdated, I know). > This MySQL server seems to run fine as long as I watch it, but as > soon as I turn my head for a moment, it jumps up to ~97% CPU usage: > > 508 mysql 63 0 99M 51660K CPU0 0 306.9H 97.46% 97.46% > mysqld > > It doesn't appear to be an IO issue, 300 samples from iostat show a > max of 0.31 MB/s. > > It also doesn't appear to be a memory issue: > > 867M Active, 2354M Inact, 320M Wired, 192M Cache, 199M Buf, 40M Free > Swap: 4096M Total, 16K Used, 4096M Free > > Through a number of samples from sockstat(1), I see ~20 connections > to mysql at any given time. 5 for Courier's authdaemon, 3 for > Exim, and ~12 for Apache/PHP. There are intermitant connections > from Windows clients using MyODBC, but none are persistant. > Restarting any/all of these processes does not cause mysql to ease > up on the CPU. Only restarting MySQL will buy releif, but after a > few weeks, it's right back to 97% CPU usage. > > The machine itself is completely responsive, mysql is completely > responsive. The tables in question are flat, with only a few > thousand entries in the largest. Queries range from simple to semi- > complex. > > I can't identify the source of the load. Can anyone help? What > should I be looking at? > > Thanks, > > -- > Troy Settle > Pulaski Networks > http://www.psknet.com > 866.477.5638 > _______________________________________________ > freebsd-isp@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-isp > To unsubscribe, send any mail to "freebsd-isp-unsubscribe@freebsd.org" > > > This e-mail is intended only for the named person or entity to which it is addressed and contains valuable business information that is privileged, confidential and/or otherwise protected from disclosure. Dissemination, distribution or copying of this e-mail or the information herein by anyone other than the intended recipient, or an employee or agent responsible for delivering the message to the intended recipient, is strictly prohibited. All contents are the copyright property of TBWA\Chiat\Day, its agencies or a client of such agencies. If you are not the intended recipient, you are nevertheless bound to respect the worldwide legal rights of TBWA\Chiat\Day, its agencies and its clients. We require that unintended recipients delete the e-mail and destroy all electronic copies in their system, retaining no copies in any media. If you have received this e-mail in error, please immediately notify us via e-mail to disclaimer@tbwachiat.com. We appreciate your cooperation. We make no warranties as to the accuracy or completeness of this e-mail and accept no liability for its content or use. Any opinions expressed in this e-mail are those of the author and do not necessarily reflect the opinions of TBWA\Chiat\Day or any of its agencies or affiliates.