Re: lock table overflow

I don't like the look of this. ovbuff is too high, you want this to be low. Yours is not. You need to add more buffers. Be careful though. Adding buffers will likely increase your checkpoint times. I would suggest that you double it initially since the 50k is pretty low to begin with. If your checkpoints are unacceptable - for OLTP systems 2-3 secs is about as high as you want to see then you can control it with: CKPTINTVAL - Number of seconds between checkpoints. 300 is what I normally see. LRUMIN and LRUMAX - These may need to be lowered in order to keep your checkpoints short. If necessary you can go as low as 0 and 1, although with the small number of buffers that you have this should not be required. Mark ----- Original Message ----- From: "Francisco Roldan" <froldan@5b.com.gt> To: "Everett Mills" <eemills@nationalbeef.com>; <informix-list@iiug.org> Sent: Wednesday, August 20, 2003 19:02 Subject: RE: lock table overflow > I have these onconfig parameters : > > LOCKS 200000 > BUFFERS 50000> > And onstat -p shows : > > ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes > 0 0 0 74218.73 45534.51 2159 4340 > > bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans > 3927560 233 835904429 0 0 5467 201123 331942 > > Do I need to increase the parameters? > > thanks > > -----Mensaje original----- > De: Everett Mills [mailto:eemills@nationalbeef.com] > Enviado el: Mi'rcoles, 20 de Agosto de 2003 04:31 p.m. > Para: informix-list@iiug.org > Asunto: RE: lock table overflow > > > An excerpt from my onconfig: > > LOCKS 250000 # Maximum number of locks > BUFFERS 60000 # Maximum number of shared buffers> > Note that BUFFERS and LOCKS depend on how much RAM you can dedicate to > Informix. I have 2GB, so 60,000 buffers isn't a whole lot, really. Unless > you are scrambling for RAM, I'd bump your locks to at least 50,000 and > buffers to at least 2,000-3,000. The book says add buffers to account for > 1/4 of your physical memory... that would be excessive for most > applications. > > -EEM > -----Original Message----- > From: Bill Hamilton [mailto:bham@finsco.com] > Sent: Wednesday, August 20, 2003 2:05 PM > To: malcolm.iiug; informix-list iiug > Subject: Re: lock table overflow > > After bringing the server online for about 2 hours, onstat -p shows" > ovrlocks = 12 ovrbufs = 23 bufwaits = 265372 lokreqs = 64million+ > > In onconfig: > LOCKS = 20,000> BUFFS = 200 > > Does this seem reasonable? > If not, what values would be appropriate? > What other parameters should I check? > > > Bill, > > what is onstat -p showing for ovlocks? > > > sending to informix-list > > sending to informix-list > > sending to informix-list sending to informix-list