1.6 billion lockreqs
This is a discussion on 1.6 billion lockreqs within the Informix forums, part of the Database Server Software category; --> If I have 1.6 billion lockreqs is this going to create a major problem (lag etc) if so does ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 08:30 AM
| |||
| |||
 Re: 1.6 billion lockreqs 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? lockreqs is a counter, so there has been 1.6 billion requests for a lock since IDS was started or onstat -z'ed, but that doesn't tell you anything about the actual number of concurrent locks      |
|
04-20-2008, 08:30 AM
| |||
| |||
| Re: 1.6 billion lockreqs 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? |
|
04-20-2008, 08:31 AM
| ||||
| ||||
| 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 |
Linear Mode
