MYSQL index page Structure diagram

int (onenullchar(3defaultnull, PRIMARY key (a));

Select  from T; +----+------+| A  | b    |+----+------+|  1 | AAA  | |  2 | BBB  | |  3 | CCC  | |  4 | DDD  | |  5 | Eee  | |  6 | FFF  | |  7 | GGG  | |  8 | HHH  | |  9 | III   | jjj  |+----+------+teninset (0.00 sec)

Hexdump-c T.IBD

Lock structure vs. index page

RECORD LOCKS Space ID142Page no3N Bits theIndex ' PRIMARY ' of table ' test '. ' t ' Trx ID31785Lock_mode XrecordLock, Heap No1Physical Record:n_fields1; Compact format; Info bits0 0: Len8; hex 73757072656d756d; ASC supremum;; RecordLock, Heap No2Physical Record:n_fields4; Compact format; Info bits0 0: Len4; Hex80000001; asc;;1: Len6; Hex 000000007c12; ASC | ;; 2: Len7; hex 8f000001460110; ASC F;;3: Len3; Hex616161; ASC AAA;; RecordLock, Heap No3Physical Record:n_fields4; Compact format; Info bits0 0: Len4; Hex80000002; asc;;1: Len6; Hex 000000007c13; ASC | ;; 2: Len7; hex 90000001b70110; ASC;3: Len3; Hex626262; ASC BBB;; RecordLock, Heap No4Physical Record:n_fields4; Compact format; Info bits0 0: Len4; Hex80000003; asc;;1: Len6; Hex 000000007c18; ASC | ;; 2: Len7; hex 93000001b80110; ASC;3: Len3; Hex636363; ASC CCC;; RecordLock, Heap No5Physical Record:n_fields4; Compact format; Info bits0 0: Len4; Hex80000004; asc;;1: Len6; Hex 000000007c19; ASC | ;; 2: Len7; hex 940000020a0110; ASC;3: Len3; Hex646464; ASC DDD;; RecordLock, Heap No6Physical Record:n_fields4; Compact format; Info bits0 0: Len4; Hex80000005; asc;;1: Len6; Hex 000000007c1a; ASC | ;; 2: Len7; hex 950000014b0110; ASC K;;3: Len3; Hex656565; ASC Eee;; RecordLock, Heap No7Physical Record:n_fields4; Compact format; Info bits0 0: Len4; Hex80000006; asc;;1: Len6; Hex 000000007c1b; ASC | ;; 2: Len7; hex 960000014c0110; ASC L;;3: Len3; Hex666666; ASC FFF;; RecordLock, Heap No8Physical Record:n_fields4; Compact format; Info bits0 0: Len4; Hex80000007; asc;;1: Len6; Hex 000000007c20; ASC | ;; 2: Len7; hex 99000001a10110; ASC;3: Len3; Hex676767; ASC GGG;; RecordLock, Heap No9Physical Record:n_fields4; Compact format; Info bits0 0: Len4; Hex80000008; asc;;1: Len6; Hex 000000007c21; ASC |!;; 2: Len7; hex 9a0000014f0110; ASC O;;3: Len3; Hex686868; ASC HHH;; RecordLock, Heap NoTenPhysical Record:n_fields4; Compact format; Info bits0 0: Len4; Hex80000009; asc;;1: Len6; Hex 000000007c22; ASC |";; 2: Len7; hex 9b000001500110; ASC P;;3: Len3; Hex696969; ASC III;; RecordLock, Heap No OnePhysical Record:n_fields4; Compact format; Info bits0 0: Len4; hex 8000000a; asc;;1: Len6; Hex 000000007c23; ASC |#;; 2: Len7; hex 9c000001a40110; ASC;3: Len3; Hex 6a6a6a; ASC JJJ;;

MYSQL index page Structure diagram