Please help on BUFFERS configuration
Posted in 1998
Hello,
This is the result of onstat -p:
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
55684746 62996402 402420642 86.16 585360 2321888 6684656 91.24
isamtot open start read write rewrite delete commit
rollbk
158584062 4458019 16558239 84056182 1556625 188487 54974 555003 245
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 110635.37 31806.81 2896 6134
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
22304173 728 901103647 0 0 1076 398191 419941
ixda-RA idx-RA da-RA RA-pgsused lchwaits
5934157 2186 45893147 51743251 73950
Question:
The actual BUFFERS=20000, the physical memory is 256MB RAM, I would like to
increase
the BUFFERS to 40000, because I have to many buffers waits and the "Read %
cached" is to
low (86.16).
When I change the BUFFERS parameter from 20000 to 40000, in order to take
effect, I need
to bring down the engine (initialize), will my data be safe? Is changing
this critical parameter
safe?
Other shared memory parameters:
LOCKS 8000 # Maximum number of locks
BUFFERS 20000 # Maximum number of shared buffers
NUMAIOVPS # Number of IO vps
PHYSBUFF 32 # Physical log buffer size (Kbytes)
LOGBUFF 32 # Logical log buffer size (Kbytes)LOGSMAX 10 # Maximum number of logical log files
CLEANERS 14 # Number of buffer cleaner processes
SHMBASE 0x0 # Shared memory base address
SHMVIRTSIZE 70000 # initial virtual shared memory segment size
SHMADD 8192 # Size of new shared memory segments
(Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL 100 # Check point interval (in sec)
LRUS 14 # Number of LRU queues
LRU_MAX_DIRTY 6 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 3 # LRU percent dirty end cleaning limit
LTXHWM 50 # Long transaction high water markpercentage
LTXEHWM 60 # Long transaction high water mark
(exclusive)
TXTIMEOUT 0x12c # Transaction timeout (in sec)
STACKSIZE 32 # Stack size (Kbytes)
Regards.
Fernando
--
+----------------------------------------------------------------+
Fernando Collalti mailto:fernando.collalti@orbit.net
Database Administrator http://dba.orbit.net
Orbit Communications Company http://www.orbit.net
Via Raffaele Costi, 60 Tel: +39 6 22543474
I-00155 Rome Fax: +39 6 22543810
ITALY Mob: +39 335 8373864
+----------------------------------------------------------------+