[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