[CentOS] Good value for /proc/sys/vm/min_free_kbytes
Morten Torstensen
morten at mortent.org
Thu Dec 7 23:18:10 UTC 2006
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.
More information about the CentOS
mailing list