[CentOS] disk I/O problems and Solutions

Fri Oct 9 17:55:35 UTC 2009
Alan McKay <alan.mckay at gmail.com>

> Since you stated that your system is only having trouble at writes,
> doing batch inserts, I would look at how you are doing these batch
> inserts and see if you can optimize this by using techniques to delay
> key writes or adjust locking mechanisms on the insert. Some databases
> have special insert from file or bulk insert operations that are much
> faster than running many single row inserts - be sure you are taking
> advantage of these methods.

Yeah, our DB geeks have already said a few weeks ago that they think
we are doing these bulk updates in a pretty inefficient manner, so
that's something else we plan to optimize.



-- 
“Don't eat anything you've ever seen advertised on TV”
         - Michael Pollan, author of "In Defense of Food"