=====================================
110201 18:08:05 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 34 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 11777325, signal count 10237043
--Thread 1452251456 has waited at btr0sea.c line 1022 for 244.00 seconds the semaphore:
X-lock on RW-latch at 0x2aaaacd8d0b8 created in file btr0sea.c line 139
a writer (thread id 1452251456) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 943
Last time write locked in file btr0sea.c line 1577
--Thread 1217960256 has waited at dict0dict.c line 751 for 244.00 seconds the semaphore:
Mutex at 0x2aaaacd962b8 created file dict0dict.c line 709, lock var 1
waiters flag 1
--Thread 1342560576 has waited at btr0sea.c line 1577 for 244.00 seconds the semaphore:
X-lock on RW-latch at 0x2aaaacd8d0b8 created in file btr0sea.c line 139
a writer (thread id 1452251456) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 943
Last time write locked in file btr0sea.c line 1577
--Thread 1199855936 has waited at btr0sea.c line 1595 for 244.00 seconds the semaphore:
X-lock on RW-latch at 0x2aaaacd8d0b8 created in file btr0sea.c line 139
a writer (thread id 1452251456) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 943
Last time write locked in file btr0sea.c line 1577
....
---TRANSACTION 20 1382652531, ACTIVE 291 sec, process no 31736, OS thread id 1452251456 updating or deleting, thread declared inside InnoDB 428
mysql tables in use 1, locked 1
32 lock struct(s), heap size 6752, undo log entries 12311
MySQL thread id 18239682, query id 656220120 mag-web08.osl.basefarm.net 10.11.15.18 root updating
DELETE FROM si_group_selection WHERE selection_id = '49063745'
....