MySQL Performance

[Steve Rieger]

are you logging
if so how large are your log files



--
Steve Rieger
AIM chozrim
ICQ 53956607
Cell 646 335 8915
steve.rieger at 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 at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-isp
> To unsubscribe, send any mail to "freebsd-isp-unsubscribe at 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 at 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.