=====================================
070420  9:30:25 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 50 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 14900584, signal count 10500861
--Thread 514866688 has waited at buf0buf.c line 856 for 245.00 seconds the semaphore:
Mutex at 0xc6af860 created file buf0buf.c line 545, lock var 0
waiters flag 0
--Thread 517134848 has waited at btr0sea.c line 995 for 245.00 seconds the semaphore:
X-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
--Thread 525105920 has waited at btr0sea.c line 916 for 245.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
--Thread 517106176 has waited at btr0sea.c line 916 for 245.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
--Thread 525103360 has waited at btr0sea.c line 1127 for 245.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
--Thread 517946880 has waited at btr0sea.c line 916 for 245.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
--Thread 530931712 has waited at btr0sea.c line 1127 for 245.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
--Thread 525105152 has waited at btr0sea.c line 916 for 245.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
--Thread 517104640 has waited at row0sel.c line 3326 for 245.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
--Thread 140541696 has waited at btr0sea.c line 916 for 244.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
--Thread 523987200 has waited at btr0sea.c line 916 for 244.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
--Thread 517943296 has waited at btr0sea.c line 916 for 243.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
--Thread 528903424 has waited at btr0sea.c line 916 for 243.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
--Thread 515098112 has waited at btr0sea.c line 916 for 242.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
--Thread 525105664 has waited at btr0sea.c line 916 for 240.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
Mutex spin waits 0, rounds 478430716, OS waits 12326261
RW-shared spins 2340148, OS waits 961546; RW-excl spins 658652, OS waits 147938

------------
TRANSACTIONS
------------
Trx id counter 0 3173446
Purge done for trx's n:o < 0 3172930 undo n:o < 0 0
History list length 26

I put some lines at the 'Private comment'.

--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (write thread)
Pending normal aio reads: 0, aio writes: 0,
 ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
16478364 OS file reads, 307175 OS file writes, 147327 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s

-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
InnoDB: ###### Diagnostic info printed to the standard error stream
InnoDB: Warning: a long semaphore wait:
--Thread 514866688 has waited at buf0buf.c line 856 for 273.00 seconds the semaphore:
Mutex at 0xc6af860 created file buf0buf.c line 545, lock var 0
waiters flag 0
InnoDB: Warning: a long semaphore wait:
--Thread 517134848 has waited at btr0sea.c line 995 for 273.00 seconds the semaphore:
X-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 525105920 has waited at btr0sea.c line 916 for 273.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 517106176 has waited at btr0sea.c line 916 for 273.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 525103360 has waited at btr0sea.c line 1127 for 273.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 517946880 has waited at btr0sea.c line 916 for 273.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 530931712 has waited at btr0sea.c line 1127 for 273.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 525105152 has waited at btr0sea.c line 916 for 273.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 517104640 has waited at row0sel.c line 3326 for 273.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 140541696 has waited at btr0sea.c line 916 for 272.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 523987200 has waited at btr0sea.c line 916 for 272.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 517943296 has waited at btr0sea.c line 916 for 271.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 528903424 has waited at btr0sea.c line 916 for 271.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 515098112 has waited at btr0sea.c line 916 for 270.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 525105664 has waited at btr0sea.c line 916 for 268.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
InnoDB: Pending preads 0, pwrites 0
InnoDB: ###### Diagnostic info printed to the standard error stream
InnoDB: Warning: a long semaphore wait:
--Thread 514866688 has waited at buf0buf.c line 856 for 305.00 seconds the semaphore:
Mutex at 0xc6af860 created file buf0buf.c line 545, lock var 0
waiters flag 0
InnoDB: Warning: a long semaphore wait:
--Thread 517134848 has waited at btr0sea.c line 995 for 305.00 seconds the semaphore:
X-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 525105920 has waited at btr0sea.c line 916 for 305.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 517106176 has waited at btr0sea.c line 916 for 305.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 525103360 has waited at btr0sea.c line 1127 for 305.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 517946880 has waited at btr0sea.c line 916 for 305.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 530931712 has waited at btr0sea.c line 1127 for 305.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 525105152 has waited at btr0sea.c line 916 for 305.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 517104640 has waited at row0sel.c line 3326 for 305.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 140541696 has waited at btr0sea.c line 916 for 304.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 523987200 has waited at btr0sea.c line 916 for 304.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 517943296 has waited at btr0sea.c line 916 for 303.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 528903424 has waited at btr0sea.c line 916 for 303.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 515098112 has waited at btr0sea.c line 916 for 302.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: Warning: a long semaphore wait:
--Thread 525105664 has waited at btr0sea.c line 916 for 300.00 seconds the semaphore:
S-lock on RW-latch at 0xc6afa60 created in file btr0sea.c line 139
a writer (thread id 517134848) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 995
InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
InnoDB: Pending preads 0, pwrites 0
InnoDB: ###### Diagnostic info printed to the standard error stream