RE: 1.6 billion lockreqs
A poster asked whether 1.6 billion lock requests reported by his Informix 7.31UC5 server on Solaris 8 could explain poor performance, and whether raising the LOCKS setting would help. He noted that ovlock (times the max lock count was exceeded) and lock waits were both zero, while an identical server with the same data performed fine. A respondent said a high lockreqs count alone is harmless — his own system showed 2.6 billion lockreqs with zero overflows and few waits and ran fine — and advised looking elsewhere, e.g. at disk layout/type. No resolution of the actual slowdown is recorded in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Geezer I currently have 2.6 billon lock reqs with 0 ovlocks and 1080 lock waits in 3 1/2 days. Ssytem is running fine with 250,000 locks in config file. Sugest you lok elsewhere for your performance problems. Disk layout, type ? Keith -----Original Message----- From: Geezer From The Freezer [mailto:Geezer@Freezer.com] Sent: Wednesday, January 26, 2005 16:35 To: informix-list@iiug.org Subject: Re: 1.6 billion lockreqs Claus Samuelsen wrote: > > continued ... > > more interesting is the ovlock, which counts the number of times maximum > number of locks has been reached, and the lockwts which counts counts > the number of times sessions waited for a lock. > > Geezer From The Freezer wrote: > > If I have 1.6 billion lockreqs is this going to create a major problem (lag etc) > > if so does increasing the locks help? ovlocks = 0 lokwaits = 0 System is grinding. In comparison to another server which has the same data and is running fine. Informix 7.31UC5 (up 6 days) on Solaris 8 ********************************************************************************** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ********************************************************************************** sending to informix-list