RE: RE: Buffwaits Ratio and Buffer Turnovers

Hi again Art, Our BTR has nearly trebled and BTF is a third of what it was on Monday. Should I be concerned ?? What else should I be looking at ?? Any other ideas ??? Oh and as I mentioned we are on Version 7.22.UC4X1 of Online on AIX 4.3.3 and as such are at the limit of memory the engine can address. I've included an onstat -g seg (the second virtual segment is normally freed after level 0 backup at 64000 blocks) and output of stats program for reference as well as our onconfig.live settings. -----onstat -g seg------ INFORMIX-OnLine Version 7.22.UC4X1 -- On-Line -- Up 03:58:31 -- 2272608 Kbytes Segment Summary: (resident segments are not locked) id key addr size ovhd class blkused blkfree 11403266 1381451777 30000000 1610350592 25388 R 196575 1 1048579 1381451778 90000000 512000000 8408 V 28823 33677 1048580 1381451779 b0000000 573440 604 M 67 3 4718608 1381451780 c0000000 204800000 3720 V 2057 22943 Total: - - -1967243264 - - 227522 56624 -----stats program------ 0 Days, 3 Hours, 38 Minutes, 33 Seconds dskreads=15275776 pagreads=45438952 bufreads= 641610603 %read cached=97.62 dskwrits=1065669 pagwrits=2996624 bufwrits=17245629 %writ cached=93.82 bufwaits=2386420 BR=3.81 BTR=46.05 BTF mins=1.30 0 Days, 3 Hours, 39 Minutes, 33 Seconds dskreads=15291907 pagreads=45456252 bufreads= 642691256 %read cached=97.62 dskwrits=1066793 pagwrits=2999667 bufwrits=17293961 %writ cached=93.83 bufwaits=2391522 BR=3.81 BTR=45.89 BTF mins=1.30 0 Days, 3 Hours, 40 Minutes, 33 Seconds dskreads=15310915 pagreads=45476613 bufreads= 644623633 %read cached=97.62 dskwrits=1068171 pagwrits=3002934 bufwrits=17313831 %writ cached=93.83 bufwaits=2397228 BR=3.82 BTR=45.71 BTF mins=1.31 0 Days, 3 Hours, 41 Minutes, 33 Seconds dskreads=15337342 pagreads=45624198 bufreads= 646543440 %read cached=97.63 dskwrits=1068721 pagwrits=3005039 bufwrits=17385732 %writ cached=93.85 bufwaits=2401869 BR=3.81 BTR=45.66 BTF mins=1.31 0 Days, 3 Hours, 42 Minutes, 33 Seconds dskreads=15371087 pagreads=45923812 bufreads= 648881187 %read cached=97.63 dskwrits=1073470 pagwrits=3027990 bufwrits=17480441 %writ cached=93.86 bufwaits=2405912 BR=3.79 BTR=45.74 BTF mins=1.31 -----onconfig.live----- #************************************************************************** # # INFORMIX SOFTWARE, INC. # # Title: onconfig.live # Description: INFORMIX-OnLine Configuration Parameters # #************************************************************************** # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace name # # ** To be changed **ROOTPATH /usr/online/chunk1 # Path for device containing root dbspace ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 200000 # Size of root dbspace (Kbytes) # Disk Mirroring Configuration Parameters MIRROR 0 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH MIRROROFFSET 0 # Offset into mirrored device (Kbytes) # Physical Log Configuration PHYSDBS physdbs # Location (dbspace) of physical log PHYSFILE 2000000 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 12 # Number of logical log files LOGSIZE 5000 # Logical log size (Kbytes) # Diagnostics MSGPATH /usr/informix/online.log # System message log file path CONSOLE /usr/informix/console.log # System console message path ALARMPROGRAM /usr/informix/etc/no_log.sh # Alarm program path # System Archive Tape Device TAPEDEV /dev/rmt2 # Tape device path#TAPEDEV /dev/null # Tape device path TAPEBLK 64000 # Tape block size (Kbytes) TAPESIZE 140000000 # Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device LTAPEDEV /dev/null # Log tape device path LTAPEBLK 16 # Log tape block size (Kbytes) LTAPESIZE 10240 # Max amount of data to put on log tape (Kbytes) # Optical STAGEBLOB ,1 # INFORMIX-OnLine/Optical staging area # System Configuration SERVERNUM 1 # Unique id corresponding to a OnLineinstance DBSERVERNAME online_4u # default database server DBSERVERALIASES online_4u_sh # List of alternate dbservernames DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env. RESIDENT 0 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 1 # 0 for single-processor, 1 formulti-processor NUMCPUVPS 5 # 3 Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps toone NOAGE 1 # Process aging AFF_SPROC 1 # 0 Affinity start processor AFF_NPROCS 0 # Affinity number of processors # Shared Memory Parameters LOCKS 20000 # Maximum number of locks 20000 BUFFERS 373712 # Maximum number of shared buffers 50000 NUMAIOVPS 1 # 2 Number of IO vps 1 ## *** Need to verify by looking at tbstat -l output and confirming that the # pages/io figure for the physical log is less than 75% of the buffer size, # if not then increase the physical log buffer size. PHYSBUFF 1000 # Physical log buffer size (Kbytes) LOGBUFF 1000 # Logical log buffer size (Kbytes)LOGSMAX 60 # Maximum number of logical log files CLEANERS 127 # Number of buffer cleaner processes # # **** To be checked *** SHMBASE 0x30000000 # Shared memory base address ## *** Use onstat -g seg to check the number of virtual segments allocated # and increase this value accordingly. # SHMVIRTSIZE 138000 initial virtual shared memory segment size SHMVIRTSIZE 500000 # initial virtual shared memory segment size SHMADD 200000 # Size of new shared memory segments (Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL 43200 # Check point interval (in sec) LRUS 127 # 20 Number of LRU queues LRU_MAX_DIRTY 2 # LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 1 # 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

In article <93k6c0$68e$1@news.xmission.com>, Earle Long <Earle.Long@sing lepointsolutions.co.uk> writes > >Hi again Art, > >Our BTR has nearly trebled and BTF is a third of what it was on Monday. >Should I be concerned ?? What else should I be looking at ?? Any other ideas >??? Oh and as I mentioned we are on Version 7.22.UC4X1 of Online on AIX >4.3.3 and as such are at the limit of memory the engine can address. I've Move to 7.31.FC4 - the 64-bit 7.31 version? PS 7.31.UD1 is out1 -- David Williams

We're going to be testing it next week David ..... watch this space <smile> Yours ---- Earle A Long (Senior Informix DBA) SINGLEPOINT LIMITED Earle http://home.btclick.com/earle/ The Duke UK ICQ#8604080 "David Williams" <djw@smooth1.demon.co.uk> wrote in message news:kux45XAlqlX6Ew$M@smooth1.demon.co.uk... > In article <93k6c0$68e$1@news.xmission.com>, Earle Long <Earle.Long@sing > lepointsolutions.co.uk> writes > > > >Hi again Art, > > > >Our BTR has nearly trebled and BTF is a third of what it was on Monday. > >Should I be concerned ?? What else should I be looking at ?? Any other ideas > >??? Oh and as I mentioned we are on Version 7.22.UC4X1 of Online on AIX > > >4.3.3 and as such are at the limit of memory the engine can address. I've > > Move to 7.31.FC4 - the 64-bit 7.31 version? > > > PS 7.31.UD1 is out1 > > -- > David Williams >