[Eug-lug] is mySQL CPU expensive?

[larry price]

What is MySQL doing? Can you tell from the logs (you should be able to
turn on query logging if it's not on already)

Some versions of the mysql client do auto completion of table and
column names, and that can eat a lot of resources, but only for
interactive sessions.


On 8/15/06, Matthew Jarvis <mattj at bikefriday.com> 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
> _______________________________________________
> EUGLUG mailing list
> euglug at euglug.org
> http://www.euglug.org/mailman/listinfo/euglug
>