Subject | Re: page type 5 lock conversion denied (215) |
---|---|
Author | derryck.welas |
Post date | 2008-06-19T08:26:50Z |
This is the lock_print,
With the avg "Hash length" on 2 all seems to be oke.
-->
LOCK_HEADER BLOCK
Version: 16, Active owner: 0, Length: 1114112, Used:
1102288
Lock manager pid: 8981
Semmask: 0x4948, Flags: 0x0001
Enqs: 47300174346, Converts: 12194458, Rejects: 5140075,
Blocks: 6237595
Deadlock scans: 201, Deadlocks: 1, Scan interval: 10
Acquires: 47584677161, Acquire blocks: 2254329704, Spin
count: 0
Mutex wait: 4.7%
Hash slots: 1009, Hash lengths (min/avg/max): 0/ 2/ 20
Remove node: 0, Insert queue: 0, Insert prior:
0
Owners (34): forward: 19196, backward: 35620
Free owners (66): forward: 700716, backward: 188484
Free locks (2697): forward: 36280, backward: 306284
Free requests (9537): forward: 840100, backward: 446116
Lock Ordering: Enabled
With the avg "Hash length" on 2 all seems to be oke.
-->
LOCK_HEADER BLOCK
Version: 16, Active owner: 0, Length: 1114112, Used:
1102288
Lock manager pid: 8981
Semmask: 0x4948, Flags: 0x0001
Enqs: 47300174346, Converts: 12194458, Rejects: 5140075,
Blocks: 6237595
Deadlock scans: 201, Deadlocks: 1, Scan interval: 10
Acquires: 47584677161, Acquire blocks: 2254329704, Spin
count: 0
Mutex wait: 4.7%
Hash slots: 1009, Hash lengths (min/avg/max): 0/ 2/ 20
Remove node: 0, Insert queue: 0, Insert prior:
0
Owners (34): forward: 19196, backward: 35620
Free owners (66): forward: 700716, backward: 188484
Free locks (2697): forward: 36280, backward: 306284
Free requests (9537): forward: 840100, backward: 446116
Lock Ordering: Enabled