Are these normal? I don't know much about locking but these seem quite
high.
sendbufferpool waiting for lock, contentions: 5800000 spins: 322072643
sendbufferpool waiting for lock, contentions: 5805000 spins: 322097231
sendbufferpool waiting for lock, contentions: 5810000 spins: 322428685
sendbufferpool waiting for lock, contentions: 5815000 spins: 323070584
jbalock thr: 0 waiting for lock, contentions: 65000 spins: 222832938
WARNING: timerHandlingLab now: 5396272820 sent: 5396272735 diff: 85
sendbufferpool waiting for lock, contentions: 5820000 spins: 323741449
WARNING: timerHandlingLab now: 5396544426 sent: 5396544329 diff: 97
send lock node 1 waiting for lock, contentions: 2600 spins: 18388176
memmanagerlock waiting for lock, contentions: 4400 spins: 27164885
sendbufferpool waiting for lock, contentions: 5825000 spins: 333717143
2010-02-04 00:28:12 [ndbd] WARNING -- Ndb kernel thread 0 is stuck in:
Performing Send elapsed=100
2010-02-04 00:28:12 [ndbd] INFO -- Watchdog: User time: 1583191
System time: 1121752
2010-02-04 00:28:12 [ndbd] WARNING -- Ndb kernel thread 2 is stuck in:
Job Handling elapsed=100
2010-02-04 00:28:12 [ndbd] INFO -- Watchdog: User time: 1583191
System time: 1121752
2010-02-04 00:28:12 [ndbd] WARNING -- Ndb kernel thread 3 is stuck in:
Job Handling elapsed=100
2010-02-04 00:28:12 [ndbd] INFO -- Watchdog: User time: 1583191
System time: 1121752
Matthew Boehm,
Senior MySQL DBA, The Planet
E: mboehm@stripped
C: 832-253-8258
O: 281-714-4018
Certified MySQL 5.0 DBA, #226735534
Certified MySQL Cluster 5.1 DBA, #227094842
RedHat Certified Engineer, #805009324738628
| Thread |
|---|
| • high lock contentions in ndbmtd | Matthew Boehm | 5 Feb |