Re: Performance Slow from 7.24 to 9.3

You need to use colons to separate the tmpdbspace names so they will be used. The initialization process forces you to use commas, but the engine won't recognize them till ya edit the onconfig to use colons. I have seen way too many Informix databases not using tmpdbspaces because of this. Humm, interesting > DBSPACETEMP tempdbs, tempdbs2, tempdbs3 # Default temp dbspaces and yet > 13 /dev/rlv5_temp1 1 1 0 0.0 > 14 /dev/rlv5_temp2 1 1 0 0.0 Not using your temp dbspaces?? Three mentioned, where are they on disk, 'cos this looks odd. Kevin R. Belanger OCP-CVB San Antonio, TX (210) 301-6435 |---------+----------------------------> | | "The Big Potatoe"| | | <MashItUp@nothere| | | .co.uk> | | | Sent by: | | | owner-informix-li| | | st@iiug.org | | | | | | | | | 09/25/2002 03:10 | | | PM | | | Please respond to| | | "The Big Potatoe"| | | | |---------+----------------------------> >------------------------------------------------------------------------------------------------------------------------------| | | | To: informix-list@iiug.org | | cc: | | Subject: Re: Performance Slow from 7.24 to 9.3 | >------------------------------------------------------------------------------------------------------------------------------| Humm ... If you have the memory, make it RESIDENT 1 > RESIDENT 0 # Forced residency flag (Yes = 1, No = 0) All looks like KAIO, shut NUMAIOVPS down to 2 > NUMAIOVPS 6 # Number of IO vps Logbuff could go bigger - 64k and monitor > Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io > L-2 0 8 431206 4048 556 106.5 7.3 > LOGBUFF 32 # Logical log buffer size (Kbytes) Could have a few more LRUs if mainly OLTP - say 64 > LRUS 32 # Number of LRU queues Try using the following - oh yes,mash it up Harry RA_PAGES 64 # Number of pages to attempt to read ahead RA_THRESHOLD 16 # Number of pages left before next group> # Read Ahead Variables > RA_PAGES 16 # Number of pages to attempt to readahead > RA_THRESHOLD 8 # Number of pages left before next group Humm, interesting > DBSPACETEMP tempdbs, tempdbs2, tempdbs3 # Default temp dbspaces and yet > 13 /dev/rlv5_temp1 1 1 0 0.0 > 14 /dev/rlv5_temp2 1 1 0 0.0 Not using your temp dbspaces?? Three mentioned, where are they on disk, 'cos this looks odd. Majority of your I/O is on /dev/rlv5_raw4 > AIO global files: > gfd pathname totalops dskread dskwrite io/s > 3 /dev/rlv5_raw1 1111 1009 102 0.1 > 4 /dev/rlv5_raw2 15658 2962 12696 1.1 > 5 /dev/rlv5_raw3 39828 39724 104 2.7 > 6 /dev/rlv5_raw4 122798 122798 0 8.4 > 7 /dev/rlv5_raw5 6508 2744 3764 0.4 > 8 /dev/rlv5_raw6 8478 3 8475 0.6 > 9 /dev/rlv5_phylog 2141 1 2140 0.1 > 10 /dev/rlv5_llog 810 257 553 0.1 > 11 /dev/rlv5_eq1 600 600 0 0.0 > 12 /dev/rlv5_eq2 0 0 0 0.0 > 13 /dev/rlv5_temp1 1 1 0 0.0 > 14 /dev/rlv5_temp2 1 1 0 0.0 sending to informix-list