Re: Deadlock Detection in InnoDB storage engine

[Manjunath C]

Hi Aftab,

Please find the below queries output.

mysql> SHOW CREATE TABLE OB_SEQUENCE_INFO\G
*************************** 1. row ***************************
Table: OB_SEQUENCE_INFO
Create Table: CREATE TABLE `OB_SEQUENCE_INFO` (
`ID` varchar(32) NOT NULL DEFAULT '',
`NAME` varchar(64) DEFAULT NULL,
`VALUE` bigint(20) DEFAULT NULL,
`INCREMENT_SIZE` int(11) DEFAULT NULL,
`IS_POOLED` varchar(1) DEFAULT NULL,
`POOL_SIZE` int(11) DEFAULT NULL,
`PARTY_ROLE_ID` varchar(32) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.02 sec)

mysql> EXPLAIN SELECT
-> obsequence0_.ID AS ID77_,
-> obsequence0_.NAME AS NAME77_,
-> obsequence0_.VALUE AS VALUE77_,
-> obsequence0_.INCREMENT_SIZE AS INCREMENT4_77_,
-> obsequence0_.IS_POOLED AS IS5_77_,
-> obsequence0_.POOL_SIZE AS POOL6_77_,
-> obsequence0_.PARTY_ROLE_ID AS PARTY7_77_
-> FROM
-> OB_SEQUENCE_INFO obsequence0_
-> WHERE obsequence0_.NAME = 'bill'
-> AND obsequence0_.PARTY_ROLE_ID = '21ce44c2d23a11e1a3bf68b599c22bdc' FOR UPDATE;
+----+-------------+--------------+------+---------------+------+---------+------+------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+--------------+------+---------------+------+---------+------+------+-------------+
| 1 | SIMPLE | obsequence0_ | ALL | NULL | NULL | NULL | NULL | 8 | Using where |
+----+-------------+--------------+------+---------------+------+---------+------+------+-------------+
1 row in set (0.01 sec)

mysql>