Re: chekcpoints, BUFFER settings, and optimization
}
} In article <881611278.1353908229@dejanews.com>,
} jneugebauer@ameritrade.com writes
[...]
David Williams writes
[...]
} ># Shared Memory Parameters
} >
} >LOCKS 100000 # Maximum number of locks BUFFERS 5000 # Maximum number
}
} BUFFERS 5000!!
} Run onstat -b and look at the last line it will end in page size
} either 2048 bytes or 4096 bytes (2 or 4K).
}
} I would up BUFFERS by 100Mb and run sar -p 1 1 / sar -q 1 1
} make sure you are not getting paging/swapping. Keep on increasing
} by 100Mb unti paging starts then set it to the highest value which
} has no paging.
}
} Run onstat -g ath. Are there kaio threads running. If so set
} NUMAIOVPS=1. Otherwise increase NUMAIOVPS to the number of disks you
} have (up to 32).
}
} Set cleaners = 6 (same as NUMCPUVPS). Page cleaner threads only queue
} i/o (pass it to kaio threads or AIO VPs) they do not actually do the
} I/O.
}
Is this a rule? To have the same number of cleaners as the number of
NUMCPUVPS.
My machine has 1 NUMCPUVPS and I've CLEANERS=8 should I change that?
Thanks
Serafim Fonseca
==========================================================================
Serafim Fonseca e-mail: sf@growela.pt
Growela Portuguesa Calcado, Lda. phone : +351 2 9866300
S. Pedro Avioso, Castelo fax : +351 2 9812212
4470 Maia - PORTUGAL