[CentOS] Good value for /proc/sys/vm/min_free_kbytes

Thu Dec 7 23:18:10 UTC 2006
Morten Torstensen <morten at mortent.org>

John R Pierce wrote:
> certainly are.    The database adminstrators will spend hours pouring 
> over IO logs and database statistics in order to better optimize the 
> distribution of tables and indicies across the available tablespaces.

Didn't realise Oracle was that primitive. One should just balance all 
the tablespaces out over multiple volumes and or controllers and add 
table partitioning as needed. Transaction filesystem is a striped 
filesystem over the same raid/volumes.

Then if you need more I/O bandwidth you just add more controllers and 
disks. No need to dick around with "put that table there and that here", 
that is just counter productive.

With a proper setup you would then engange all disk arms you have 
available for the I/Os you need and you basically remove hotspot management.


//Morten Torstensen
//Email: morten at mortent.org
//IM: Cartoon at jabber.no morten.torstensen at gmail.com

And if it turns out that there is a God, I don't believe that he is evil.
The worst that can be said is that he's an underachiever.