How to Interpret Innodb log
Posted by: Khurram Naseem
Date: January 20, 2015 05:40AM

Hi,

How one can read or interpret below out put of innodb log ,

RECORD LOCKS space id 2039 page no 26025 n bits 160 index `PRIMARY` of table `xxx`.`abc` trx id 4005695609 lock_mode X locks rec but not gap waiting
Record lock, heap no 49 PHYSICAL RECORD: n_fields 50; compact format; info bits 0
0: len 4; hex 800ba336; asc 6;;
1: len 6; hex 0000eec0b513; asc ;;
2: len 7; hex 22000100a11117; asc " ;;
3: len 4; hex 8000c5e3; asc ;;
4: len 4; hex 80009183; asc ;;
5: len 4; hex 80009183; asc ;;
6: len 4; hex 80000002; asc ;;
7: len 4; hex 80000003; asc ;;
8: len 4; hex 80000002; asc ;;
9: len 4; hex 54be3254; asc T 2T;;
10: len 4; hex 54be3254; asc T 2T;;
11: len 4; hex 807b5e54; asc {^T;;
12: len 4; hex 807b5e55; asc {^U;;
13: len 0; hex ; asc ;;
14: len 0; hex ; asc ;;
15: len 4; hex 54be3254; asc T 2T;;
16: len 4; hex 54be3268; asc T 2h;;
17: len 4; hex 80009183; asc ;;
18: len 4; hex 80009ed9; asc ;;
19: len 0; hex ; asc ;;
20: len 0; hex ; asc ;;
21: len 4; hex 800008d2; asc ;;
22: len 4; hex 80000955; asc U;;
23: len 0; hex ; asc ;;
24: len 4; hex 80000000; asc ;;
25: len 4; hex 80000001; asc ;;
26: len 4; hex 54be3254; asc T 2T;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000001; asc ;;
29: len 4; hex 80000002; asc ;;
30: len 4; hex 80000000; asc ;;
31: len 4; hex 80000004; asc ;;
32: len 4; hex 80000000; asc ;;
33: len 4; hex 00000000; asc ;;
34: len 4; hex 80000000; asc ;;
35: len 4; hex 00000000; asc ;;
36: len 4; hex 80000002; asc ;;
37: len 4; hex 00000000; asc ;;
38: len 4; hex 80000001; asc ;;
39: SQL NULL;
40: SQL NULL;
41: SQL NULL;
42: SQL NULL;
43: SQL NULL;
44: SQL NULL;
45: len 10; hex 425a4a5a4e4159483254; asc BZJZNAYH2T;;
46: len 1; hex 81; asc ;;
47: SQL NULL;
48: SQL NULL;
49: SQL NULL;

Options: ReplyQuote


Subject
Written By
Posted
How to Interpret Innodb log
January 20, 2015 05:40AM


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.