SHOW INNODB STATUS: DEAD LOCKS

In the deadlock section, innodb shows:


what the last deadlock was

what the deadlocks state was

what the deadlock lock was holding

and what they were waiting for


060718 8:00:18
*** (1) TRANSACTION:
TRANSACTION 4 4095301271, ACTIVE 0 sec, process no 19925, OS thread id 387040248038 starting index read
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 368
MySQL thread id 2287022118, query id 5904669207 [HOST] [user] Searching rows for update
/* /PHPFILE: PHP FUNCTION() */ UPDATE Latest SET `date_create`='?', `id`='?' WHERE user_id=?
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 0 page no 6669281 n bits 608 index `user_id` of table `DB/Latest` trx id 4 4095301271 lock_mode X waiting
Record lock, heap no 38 PHYSICAL RECORD: n_fields 3; 1-byte offs TRUE; info bits 32
0: len 8; hex 000000000036a53b; asc 6 ;;; 1: len 4; hex 44bc9512; asc D ;; 2: len 8; hex 000000000b786a9f; asc xj ;;