[Eug-lug] is mySQL CPU expensive?

Ralph Zeller ralph at zellercpa.com
Tue Aug 15 17:51:38 PDT 2006


Are you running PhpMyAdmin?  It has a nice display of the MySQL status
Select "Show MySQL runtime information".  It shows possible problem
areas in red.

On 08/15/06 11am, Matthew Jarvis wrote:
> Yesterday I was doing some followup work on a box and fired up mySQL to 
> look over some data. I didn't complete my work so left it there overnight...
> 
> This morning I noticed CPU loads on average much higher than I am used 
> to seeing...
> 
> After shaking the rubber chicken, restarting Cold Fusion (our usual 
> first attempt) then apache (our second), I quit our of mySQL and things 
> mellowed out quickly to much more normal (and usable) levels...
> 
> I just went in to do some more mySQL stuff, nothing fancy, just 
> describing such-and-such tables, noticed the CPU load ramping up... quit 
> out of mySQL and it levels back off...
> 
> I never would have guessed mySQL was so demanding...
> 
> Anyone else experience this?
> 
> -- 
> Matthew S. Jarvis
> IT Manager
> Bike Friday - "Performance that Packs."
> www.bikefriday.com
> 541/687-0487 x140
> mattj at bikefriday.com


More information about the EUGLUG mailing list