Re: HELP I'm in crisis
Collalti, Fernando wrote:
>
> Hello,
>
> System: HP HP9000 E35, 132MB RAM, Online 7.12.UC3
> These are my NEW Shared Memory Parameters:
> LOCKS 2000 # Maximum number of locks
> BUFFERS 30000(old=5000) # 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 6 # Maximum number of logical log files
> CLEANERS 6 # Number of buffer cleaner processes
> SHMBASE 0x0 # Shared memory base address
> SHMVIRTSIZE 60000(old=8000) # initial virtual shared memory segment size
> SHMADD 8192 # Size of new shared memory segments
> (Kbytes)
> SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
> CKPTINTVL 300 # Check point interval (in sec)
> LRUS 12 # Number of LRU queues
> LRU_MAX_DIRTY 70 # LRU percent dirty begin cleaning limit
> LRU_MIN_DIRTY 60 # LRU percent dirty end cleaning limit
> LTXHWM 50 # Long transaction high water mark> percentage
> LTXEHWM 60 # Long transaction high water mark
> (exclusive)
> TXTIMEOUT 0x12c # Transaction timeout (in sec)
> STACKSIZE 32 # Stack size (Kbytes)>
> I've migrated from Informix-SE 5.04 to Informix-OnLine 7.12.UC3
>
> With SE, the system was slow, but I never had problems. Now
> After 20-30 users are using the system(with the same client/server
> application) OnLine adds new shared memory segment (size 8388608)
> continuosly!!!
>
> After some hours, the system "sits" down and I need to take OnLine
> OFF Line. I'm taking the OnLine 7.12 "on-line"with the NEW above values.
> I've change BUFFERS from 5000 to 30000 and SHMVISTSIZE from 8000
> to 60000. It seems that the application that was running OK on
> SE, now does not release memory until it doesn't disconnetcs
> from the Database engine....Why???? Are my new parameters ok?
> I've got 30 users complaining !!!!! HELP!!!!
>
> Please help. I'm doing this installation away from my office.
>
> fernando.collalti@orbit.net
I haven't got my manuals with me at home so I can't help much. But when
modifying your BUFFERS you should have taken the opportunity to
dramatically reduce your LRU_MAX_DIRTY and LRU_MIN_DIRTY values. If
you're concerened to limit the number of segments added, cap the total
available with the SHMTOTAL parameter.
Why does the system "sit"? Any clues from onstat -u, onstat -k etc?
Neil Truby
Chase Bank
Bournemouth, UK