Question on PHYSFILE size and buffers ...
Posted in 2017
My current buffers are totaled for 53000 while according to the guideline
found inside the onconfig file, my PHYSFILE is sized good for roughly up to
272000 total buffers? (299000/1.1), am I reading this correctly?Thanks in
advance for any inputs.Kern --
###################################################################
# Physical Log Configuration Parameters
###################################################################
# PHYSFILE - The size, in KB, of the physical log on disk.
# If RTO_SERVER_RESTART is enabled, the
# suggested formula for the size of PHSYFILE
# (up to about 1 GB) is:
# PHYSFILE = Size of BUFFERS * 1.1
PHYSFILE 299000
BUFFERPOOL size=2K,buffers=50000,lrus=8,lru_min_dirty=0.30,lru_max_dirty=2.00
BUFFERPOOL size=16K,buffers=1000,lrus=4,lru_min_dirty=50.00,lru_max_dirty=60.00
BUFFERPOOL size=4K,buffers=1000,lrus=4,lru_min_dirty=50.00,lru_max_dirty=60.00
BUFFERPOOL size=10K,buffers=1000,lrus=4,lru_min_dirty=50.00,lru_max_dirty=60.00
Let's go GreenThis email contains 100% recycled electrons.