MySQL Forums
Forum List  »  InnoDB

how to convert the hex of the output of a deadlock to decimal
Posted by: z z
Date: April 28, 2018 03:52AM

hi,
there was a deadlock when i did a test on linux ,i know the filed 0(hex 8003d370) means primary key's value and filed 4 means c's value,but how i convert them to decimal or characters?

| sbtest9 | CREATE TABLE `sbtest9` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`k` int(11) NOT NULL DEFAULT '0',
`c` char(120) NOT NULL DEFAULT '',
`pad` char(60) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `k_9` (`k`)
) ENGINE=InnoDB AUTO_INCREMENT=500001 DEFAULT CHARSET=latin1 |


DELETE FROM sbtest9 WHERE id=?
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 55 page no 3467 n bits 144 index PRIMARY of table `test`.`sbtest9` trx id 2507825 lock_mode X locks rec but not gap waiting
Record lock, heap no 19 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 4; hex 8003d370; asc p;;
1: len 6; hex 000000264427; asc &D';;
2: len 7; hex 2e000001841b3d; asc . =;;
3: len 4; hex 8004f02b; asc +;;
4: len 30; hex 36363931333938303739392d36363733383137333331332d303735323939; asc 66913980799-66738173313-075299; (total 120 bytes);
5: len 30; hex 33393439373437343438362d31313639353431343634392d363732373639; asc 39497474486-11695414649-672769; (total 60 bytes);

Options: ReplyQuote


Subject
Views
Written By
Posted
how to convert the hex of the output of a deadlock to decimal
127
z z
April 28, 2018 03:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.