Re: IDS9.4/AIX5.2 performace degradation
Dalibor,
A piece of tuning advice that has many times hit this list, is that
you should have one CLEANER per LRU. So, having LRUS = 8 implies that
you should have CLEANERS=8 also, to keep up with the overhead.
Ben Thompson wrote:
> Dalibor Krleza wrote:
>
> I may have missed it in your long post, but I didn't see anything about
> disc layouts or number of CPUs. Also I may have missed it as well but I
> couldn't see any output from "onstat -g iof" or "onstat -g iov". I have
> commented on your onconfig anyway.
>
>
>>OK Art, I will post these lists. Hope you'll find something.
>>UPDATE STATISTICS - done. After US recreated all indexes, same thing.>>
>>Everyone else, sorry for long post! I'll try to be short as possible by kicking all remarks out of lists.
>>
>>***ONCONFIG***
>>
>>ROOTNAME rootdbs
>>ROOTPATH /dev/rlvinfx01
>>ROOTOFFSET 16
>>ROOTSIZE 30000>>MIRROR 0
>>MIRRORPATH
>>MIRROROFFSET 0>>PHYSDBS fizldbs
>>PHYSFILE 48000
>>LOGFILES 150
>>LOGSIZE 2000>
>
> Personally I think your log size is very small although others may have
> more of an idea about this than me.
>
>
>>MSGPATH /informix/online.log
>>CONSOLE /informix/console.log
>>ALARMPROGRAM /informix/etc/no_log.sh
>>TBLSPACE_STATS 1>
>
> Try setting this to 0 unless you need the stats.
>
>
>>TAPEDEV /dev/rmt1
>>TAPEBLK 256
>>TAPESIZE 209715200
>>LTAPEDEV /dev/null
>>LTAPEBLK 32
>>LTAPESIZE 8388608>>STAGEBLOB
>>SERVERNUM 0
>>DBSERVERNAME kov_dbs
>>DBSERVERALIASES
>>DEADLOCK_TIMEOUT 60
>>RESIDENT 0>
>
> Try setting to 1 or -1.
>
>
>>MULTIPROCESSOR 1
>>NUMCPUVPS 2>
>
> Comment this out and use VPCLASS - see 9.40 performance guide.
>
>
>>SINGLE_CPU_VP 0
>>NOAGE 0
>>AFF_SPROC 0
>>AFF_NPROCS 0>
>
> Comment out NOAGE, AFF_* and use VPCLASS - see 9.40 performance guide.
>
>
>>LOCKS 200000
>>BUFFERS 200000
>>NUMAIOVPS>
>
> Comment this out and use VPCLASS - see 9.40 performance guide.
>
>
>>PHYSBUFF 32
>>LOGBUFF 32
>>CLEANERS 1>
>
> How many discs are used by IDS for data? Generally speaking Ttis
> parameter should be set to the number of discs you use. Any RAID discs
> that appear as one disc to the OS count as 1. The 9.40 performance guide
> has more information.
>
>
>>SHMBASE 0x700000000000000
>>SHMVIRTSIZE 8000>
>
> You have a lot of shared memory segments. Try increasing this to more
> like 80000, rather than 8000. Check then how many segments you have with
> onstat -g seg. Ideally you want just one but shared memory should not be> bigger than it needs to be.
>
>
>>SHMADD 8192
>>SHMTOTAL 0
>>CKPTINTVL 300
>>LRUS 8>
>
> Read up on LRUS in the 9.40 performance guide.
>
>
>>LRU_MAX_DIRTY 2
>>LRU_MIN_DIRTY 1>
>
> You may get more throughput if you set these values higher as long as
> checkpoint times do not get too high.
>
>
>>TXTIMEOUT 0x12c
>>STACKSIZE 64
>>DYNAMIC_LOGS 2
>>LTXHWM 70
>>LTXEHWM 80
>>OFF_RECVRY_THREADS 10
>>ON_RECVRY_THREADS 1
>>DRINTERVAL 30
>>DRTIMEOUT 30
>>DRLOSTFOUND /usr/informix/etc/dr.lostfound
>>CDR_EVALTHREADS 1,2
>>CDR_DSLOCKWAIT 5
>>CDR_QUEUEMEM 4096
>>CDR_NIFCOMPRESS 0
>>CDR_SERIAL 0,0
>>CDR_DBSPACE
>>CDR_QHDR_DBSPACE
>>CDR_QDATA_SBSPACE
>>CDR_MAX_DYNAMIC_LOGS 0
>>BAR_ACT_LOG /usr/informix/bar_act.log
>>BAR_DEBUG_LOG /usr/informix/bar_dbug.log
>>BAR_MAX_BACKUP 0
>>BAR_RETRY 1
>>BAR_NB_XPORT_COUNT 10
>>BAR_XFER_BUF_SIZE 31
>>RESTARTABLE_RESTORE on
>>BAR_PROGRESS_FREQ 0>>ISM_DATA_POOL ISMData
>>ISM_LOG_POOL ISMLogs
>>RA_PAGES
>>RA_THRESHOLD>>DBSPACETEMP tmp1,tmp2,tmp3
>>DUMPDIR /tmp
>>DUMPSHMEM 0
>>DUMPGCORE 0
>>DUMPCORE 0
>>DUMPCNT 1
>>FILLFACTOR 90
>>USEOSTIME 0
>>MAX_PDQPRIORITY 100
>>DS_MAX_QUERIES
>>DS_TOTAL_MEMORY
>>DS_MAX_SCANS 1048576
>>DATASKIP off
>>OPTCOMPIND 2>
>
> Try 0 and see if this helps. It may or may not.
>
>
>>DIRECTIVES 1
>>ONDBSPACEDOWN 2>>OPCACHEMAX 0
>>HETERO_COMMIT 0
>>SBSPACENAME
>>SYSSBSPACENAME
>>BLOCKTIMEOUT 3600>>SYSALARMPROGRAM /informix/etc/evidence.sh
>>OPT_GOAL -1
>>ALLOW_NEWLINE 0
>>JVPJAVAHOME /usr/informix/extend/krakatoa/jre>>JVPHOME /usr/informix/extend/krakatoa
>>JVPPROPFILE /usr/informix/extend/krakatoa/.jvpprops
>>JDKVERSION 1.3
>>JVPJAVALIB /bin
>>JVPJAVAVM hpi:jvm:java:net:zip:jpeg
>>JVPCLASSPATH /usr/informix/extend/krakatoa/krakatoa.jar:/usr/informix/extend/krakatoa/jdbc.jar>
>
--
( ______
)) .-- Scott MacKenzie; Dine' College ISD --. >===<--.
C|~~| (>--- Phone/Voice Mail: 928-724-6639 ---<) | ; o |-'
| | \\--- Senior DBA/CARS Coordinator/Etc. --/ | _ |
`--' `-- E: scottm at dinecollege dot edu -' `-----'
sending to informix-list