Re: Performance & checkpoint
Hi All, Thank you for your responded.
My SUN V480 server have 2 900mhz CPUs. That's why I setted
MULTIPROCESSOR=1 and NUMCPUVPS=1. This way 1 CPU for database and one
for OS/Business application.
Yes, I run Update Statistics weekly.
Anyway, I will try your sugesstion to increase LRUS and will let you
know how it go. Thanks again.
--Wayne
"Murray Wood" <murray@quanta.co.nz> wrote in message news:<b9v43t$1se$1@terabinaries.xmission.com>...
> Other than the checkpoint duration increasing, do you have a problem you are
> trying to solve?
>
> How frequently do you run the recommended Update Statistics?
> How many processors does the SUN have and what else is running on this
> server?
> You have MULTIPROCESSOR set to 1 but NUMCPUVPS=1 ??
>
> Why do you have NOAGE 1?
> How busy do your disks get at Checkpoint time? If they are busy then reduce
> LRU_MAX_DIRTY to 2 and MIN to 1. Or even 1 and 0.
>
>
> MW
>
>
> > -----Original Message-----
> > From: owner-informix-list@iiug.org
> > [mailto:owner-informix-list@iiug.org]On Behalf Of Wayne T
> > Sent: Thursday, 15 May 2003 1:08 p.m.
> > To: informix-list@iiug.org
> > Subject: Re: Performance & checkpoint
> >
> >
> > Here is my system configuration:
> > SUN V480 900mhz and 8GB ram
> > Solaris 5.8
> > IDS 9.21
> > RAID 10
> > Businesss application is Baan5c.
> >
> > If you have any input would be appreciated. Thank you in advance.
> > --Wayne
> >
> > ********************************************************
> > onstat -d> >
> > Chunks
> > address chk/dbs offset size free bpages flags pathname
> > 5310f918 1 1 0 200000 197720 PO-
> > /dev/rawlinks/rootdbs
> > 5310fb00 2 2 0 1000000 999897 PO-
> > /dev/rawlinks/tempdbs
> > 5310fc70 3 3 0 1000000 99947 PO-
> > /dev/rawlinks/plogdbs
> > 5310fde0 4 4 0 1000000 499947 PO-
> > /dev/rawlinks/llogdbs
> > 5313f830 5 5 0 1000000 221 PO-
> > /dev/rawlinks/data01
> > 5313f9a0 6 5 0 1000000 430 PO-
> > /dev/rawlinks/data02
> > 5313fb10 7 5 0 1000000 218 PO-
> > /dev/rawlinks/data03
> > 5313fc80 8 5 0 1000000 165 PO-
> > /dev/rawlinks/data04
> > 5313fdf0 9 5 0 1000000 770 PO-
> > /dev/rawlinks/data05
> > 539b4018 10 5 0 1000000 285 PO-
> > /dev/rawlinks/data06
> > 539b4188 11 5 0 1000000 267 PO-
> > /dev/rawlinks/data07
> > 539b42f8 12 5 0 1000000 369 PO-
> > /dev/rawlinks/data08
> > 539b4468 13 5 0 1000000 341 PO-
> > /dev/rawlinks/data09
> > 539b45d8 14 5 0 1000000 502 PO-
> > /dev/rawlinks/data10
> > 539b4748 15 5 0 1000000 87 PO-
> > /dev/rawlinks/data11
> > 539b48b8 16 5 0 1000000 28 PO-
> > /dev/rawlinks/data12
> > 539b4a28 17 5 0 1000000 470861 PO-
> > /dev/rawlinks/data13
> > 539b4b98 18 5 0 1000000 999997 PO-
> > /dev/rawlinks/data14
> > 539b4d08 19 5 0 1000000 999997 PO-
> > /dev/rawlinks/data15
> > 539b4e78 20 5 0 1000000 999997 PO-
> > /dev/rawlinks/data16
> > 539b5018 21 5 0 1000000 999997 PO-
> > /dev/rawlinks/data17
> > 539b5188 22 5 0 1000000 999997 PO-
> > /dev/rawlinks/data18
> > 22 active, 2047 maximum
> > ************************************************************
> >
> > $ onstat -g iov> >
> > Informix Dynamic Server 2000 Version 9.21.UC4 -- On-Line -- Up 3
> > days 07:17:17 -- 1806336 Kbytes
> >
> > AIO I/O vps:
> > class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup
> > errors
> > kio 0 i 23.6 6743404 5911155 832249 0 15142951 0.4
> > 0
> > msc 0 i 0.3 83026 0 0 0 82978 1.0
> > 0
> > aio 0 i 0.0 161 61 0 0 64 2.5
> > 0
> > pio 0 i 0.0 0 0 0 0 1 0.0
> > 0
> > lio 0 i 0.0 0 0 0 0 1 0.0
> > 0
> >
> > *****************************************************
> > Informix Dynamic Server 2000 Version 9.21.UC4 -- On-Line -- Up 3
> > days 07:17:46 -- 1806336 Kbytes
> >
> > Profile
> > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
> > 11775792 39362423 2251324629 99.48 971533 5778329 6053142 83.95
> >
> > isamtot open start read write rewrite delete commit
> > rollbk
> > 1243684959 1781075 27883004 1068978860 352608 631757 199160
> > 218938 176
> >
> > 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 42103.68 20251.59 1158 3166
> >
> > bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress
> > seqscans
> > 1144801 13 231849680 0 0 423 162451 282224
> >
> > ixda-RA idx-RA da-RA RA-pgsused lchwaits
> > 9118728 14358 1134854 10041192 1355
> >
> >
> > ntrieu@yahoo.com (Wayne T) wrote in message
> > news:<e6623a40.0305121517.15f36184@posting.google.com>...
> > > Hi All,
> > > My database has grown 3 times and the performance is
> degrading. During
> > > the business hours my checkpoint duration is between 1-8 seconds.
> > > About two months ago my checkpoint mostly is between 0-1 seconds. I
> > > included my onconfig file for you to review. If you have any
> > > suggestions I would be appreciated.
> > > Thank you. --Wayne
> > >
> > >
> > > # Physical Log Configuration
> > >
> > > PHYSDBS plogdbs # Location (dbspace) of physical log
> > > PHYSFILE 1800000 # Physical log file size (Kbytes)> > >
> > >
> > > # Logical Log Configuration
> > >
> > > LOGFILES 50 # Number of logical log files
> > > LOGSIZE 20000 # 20MB each Logical log
> size (Kbytes)
> > >
> > > NETTYPE tlitcp,1,100,NET # Configure poll thread(s) for> > > nettype
> > > NETTYPE ipcstr,1,63,CPU # Configure poll
> thread(s) for nettype
> > > #NETTYPE tlitcp,1,100,CPU # Configure poll thread(s) for> > > nettype
> > > #NETTYPE ipcshm,1,63,CPU # Configure poll thread(s) for
> > > nettype
> > > # above never work
> > > DEADLOCK_TIMEOUT 60 # Max time to wait of lock in> > > distributed env.
> > > RESIDENT 1 # Forced residency flag
> (Yes = 1, No =
> > > 0)
> > >
> > > MULTIPROCESSOR 1 # 0 for single-processor, 1 for> > > multi-processor
> > > NUMCPUVPS 1 # Number of user (cpu) vps
> > > SINGLE_CPU_VP 0 # If non-zero, limit number
> of cpu vps> > > to on