[Eug-lug] is mySQL CPU expensive?

[Matthew Jarvis]

Ben Barrett wrote:
> Agreed, it was likely rebuilding table indexes and/or verifying data... 
> depending on the system it is running on, the disk might be held up on 
> other tasks.

Well, what it's doing in the background just sitting there at a prompt 
overnight I can't really say... maybe it's inclined to do stuff like this...


> I'm guessing you're not running on linux, since you mentioned coldfusion :)
> Sounds like the "residual" system load was higher than during normal 
> mySQL usage; if you do happen to be on linux check out vmstat.
> 

Yes - Linux (slackware). Will take a look at vmstat - thanks.


> How big is the DB?  Can it fit in memory?  (make sure you have good UPS 
> if so!)

DB isn't terribly large - I don't have the #'s handy though...

> 
> In regards, to the subject line, I also wanted to round this discussion 
> out by daying, "NO", IMO :)
> MySQL has been improving over the years in terms of its own efficiency, 
> and the bottom line is that CPU time is continually cheaper ;)

Okay...

Thanks,

Matt

Matthew S. Jarvis
IT Manager
Bike Friday - "Performance that Packs."
www.bikefriday.com
541/687-0487 x140
mattj at bikefriday.com