RE: Do I need more KIO's

You shared buffer pool is extremely small: 6000 pages -> 12MB (with 2k page on SUN and HP) This is why You have such a high I/O activity. How much RAM do You have in Your server? ------------------------------------------ Alexey Sonkin > -----Original Message----- > From: Tugger [mailto:t459@hotmail.com] > Sent: Thursday, April 01, 2004 10:04 AM > To: informix-list@iiug.org > Subject: Re: Do I need more KIO's > > Paul Watson wrote: > > > you've got 2 kio 'cos you've got two cpus, I suspect that NUMAIO > > is one and the rest of the aio tally across to the gfd, I'd expect > > onstat -g iof to show the path to the various chunks.> > > > I think this looks fine. > > > > Fire out your > > ONCONFIG file, > > onstat -R, > > onstat -p, > > onstat -F, > > onstat -m, > > onstat -l> > > > outputs > > OK, here goes: > > #onstat -R > > Informix Dynamic Server 2000 Version 9.21.FC2 -- On-Line -- Up 41 > days 19:41:36 -- 206848 Kbytes > > 8 buffer LRU queue pairs priority levels > # f/m pair total % of length LOW MED_LOW MED_HIGH HIGH > 0 f 750 99.7% 748 0 703 44 1 > 1 m 0.3% 2 0 2 0 0 > 2 f 750 99.7% 748 0 680 67 1 > 3 m 0.3% 2 0 2 0 0 > 4 f 750 99.9% 749 0 683 66 0 > 5 m 0.1% 1 0 1 0 0 > 6 f 749 99.9% 748 0 675 71 2 > 7 m 0.1% 1 0 1 0 0 > 8 f 750 100.0% 750 0 682 66 2 > 9 m 0.0% 0 0 0 0 0 > 10 f 750 99.9% 749 0 662 86 1 > 11 m 0.1% 1 0 1 0 0 > 12 f 750 99.9% 749 0 689 57 3 > 13 m 0.1% 1 0 1 0 0 > 14 F 748 99.7% 746 0 682 63 1 > 15 m 0.3% 2 0 2 0 0 > 10 dirty, 5997 queued, 6000 total, 8192 hash buckets, 2048 buffer size > start clean at 10% (of pair total) dirty, or 75 buffs dirty, stop at 5% > 0 priority downgrades, 0 priority upgrades > > > # onstat -p> > Informix Dynamic Server 2000 Version 9.21.FC2 -- On-Line -- Up 41 > days 19:41:40 -- 206848 Kbytes > > Profile > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 773582188 4498910 6814835840 88.65 8628020 4776297 60669442 85.78 > > isamtot open start read write rewrite delete commit > rollbk > 1213151609 112956510 115063966 306347991 7323816 7478866 5327145 > 8700484 5256 > > gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs > 0 0 0 0 0 0 0 > > ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes > 0 0 0 360423.91 15745.53 12043 24092 > > bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans > 16101291 96 8730222898 0 0 2599 1199597 898741 > > ixda-RA idx-RA da-RA RA-pgsused lchwaits > 559667 6405 769988448 770028761 1263960 > > > > # onstat -F> > Informix Dynamic Server 2000 Version 9.21.FC2 -- On-Line -- Up 41 > days 19:41:47 -- 206848 Kbytes > > > Fg Writes LRU Writes Chunk Writes > 0 559254 478152 > > address flusher state data > 1217d818 0 I 0 = 0X0 > 1217e008 1 I 0 = 0X0 > states: Exit Idle Chunk Lru > > > # onstat -m> > Informix Dynamic Server 2000 Version 9.21.FC2 -- On-Line -- Up 41 > days 19:41:52 -- 206848 Kbytes > > Message Log File: /informix/online1.log > 15:28:56 Fuzzy Checkpoint Completed: duration was 0 seconds, 57> buffers not flushed. > 15:28:56 Checkpoint loguniq 5730, logpos 0xfc204 > > 15:33:40 Logical Log 5730 Complete. > 15:33:41 Process exited with return code 142: /bin/sh /bin/sh -c> /informix/etc/log_full.sh 2 23 "Logical Log 5730 Complete." "Logical Log > 5730 Complete." > 15:33:56 Fuzzy Checkpoint Completed: duration was 0 seconds, 58> buffers not flushed. > 15:33:56 Checkpoint loguniq 5731, logpos 0x3420c > > 15:38:56 Fuzzy Checkpoint Completed: duration was 0 seconds, 60> buffers not flushed. > 15:38:56 Checkpoint loguniq 5731, logpos 0x4921c > > 15:43:56 Fuzzy Checkpoint Completed: duration was 0 seconds, 61> buffers not flushed. > 15:43:56 Checkpoint loguniq 5731, logpos 0x6e224 > > 15:48:56 Fuzzy Checkpoint Completed: duration was 0 seconds, 4 buffers> not flushed. > 15:48:56 Checkpoint loguniq 5731, logpos 0x8305c > > 15:53:56 Fuzzy Checkpoint Completed: duration was 0 seconds, 4 buffers> not flushed. > 15:53:56 Checkpoint loguniq 5731, logpos 0x9805c> > > > # cat /informix/etc/onconfig.online1> > > #************************************************************************* > * > # > # INFORMIX SOFTWARE, INC. > # > # Title: onconfig.online1 > # Description: INFORMIX-OnLine Configuration Parameters > # > # > #************************************************************************* > * > > # Root Dbspace Configuration > > ROOTNAME online1dbs # Root dbspace name > ROOTPATH /dev/rootdbs #Path for device containing root dbspace > ROOTOFFSET 16 # 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 # Path for device containing mirrored root > MIRROROFFSET 16 # Offset into mirrored device (Kbytes)> > # Physical Log Configuration > > PHYSDBS physical_log_dbs # Location (dbspace) of physical log > PHYSFILE 50000 # Physical log file size (Kbytes)> > # Logical Log Configuration > > LOGFILES 20 # Number of logical log files > LOGSIZE 5000 # Logical log size (Kbytes)> > # Diagnostics > > MSGPATH /informix/online1.log # System message log file path > CONSOLE /informix/online1console.log # System console message path > ALARMPROGRAM /informix/etc/log_full.sh # Alarm program path > > # System Archive Tape Device > > TAPEDEV /dev/rmt/0 # Tape device path > TAPEBLK 64 # Tape block size (Kbytes) > TAPESIZE 12000000 # Maximum amount of data to put on tape > (Kbytes)> > # Log Archive Tape Device > > LTAPEDEV /dev/null # Log tape device path > LTAPEBLK 64 # Log tape block size (Kbytes)

Alexey Sonkin wrote: > You shared buffer pool is extremely small: > 6000 pages -> 12MB (with 2k page on SUN and HP) > This is why You have such a high I/O activity. > How much RAM do You have in Your server? > > > ------------------------------------------ > Alexey Sonkin > Thanks to you both for spotting this The Sun has 1Gb of RAM installed, so I'll up the shared buffers to 50,000 as suggested (that'll use up 100MB of RAM, which is fine). I can always try a bit more if performance still isn't good enough. Will let you know how I get on. Thanks again.

If the box is purely a db server then you could go 250K and not really worry Tugger wrote: > > Alexey Sonkin wrote: > > You shared buffer pool is extremely small: > > 6000 pages -> 12MB (with 2k page on SUN and HP) > > This is why You have such a high I/O activity. > > How much RAM do You have in Your server? > > > > > > ------------------------------------------ > > Alexey Sonkin > > > > Thanks to you both for spotting this > > The Sun has 1Gb of RAM installed, so I'll up the shared buffers to > 50,000 as suggested (that'll use up 100MB of RAM, which is fine). I can > always try a bit more if performance still isn't good enough. > > Will let you know how I get on. > > Thanks again. -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #