List:Cluster« Previous MessageNext Message »
From:Matthew Boehm Date:February 5 2010 4:57pm
Subject:high lock contentions in ndbmtd
View as plain text  
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 ndbmtdMatthew Boehm5 Feb