表`t`的INODE結構檔案分析

so_easy發表於2020-09-21

前言

表結構索引：4個索引，8個段–對應8個INode Entry。

  PRIMARY KEY (`id`),
  UNIQUE KEY `unq_md5` (`md5`),
  KEY `idx_matchId_sourceName` (`matchId`,`sourceName`),
  KEY `idx_oddsId_changeTime` (`oddsId`,`changeTime`)

表結構分析：

page offset 00000000, page type <File Space Header>
page offset 00000001, page type <Insert Buffer Bitmap>
page offset 00000002, page type <File Segment inode>
page offset 00000003, page type <B-tree Node>, page level <0001>
page offset 00000004, page type <B-tree Node>, page level <0001>
page offset 00000005, page type <B-tree Node>, page level <0001>
page offset 00000006, page type <B-tree Node>, page level <0001>
page offset 00000007, page type <B-tree Node>, page level <0000>
page offset 00000008, page type <B-tree Node>, page level <0000>
page offset 00000009, page type <B-tree Node>, page level <0000>
page offset 0000000a, page type <B-tree Node>, page level <0000>
page offset 0000000b, page type <B-tree Node>, page level <0000>
page offset 0000000c, page type <B-tree Node>, page level <0000>
page offset 0000000d, page type <B-tree Node>, page level <0000>
page offset 0000000e, page type <B-tree Node>, page level <0000>
page offset 0000000f, page type <B-tree Node>, page level <0000>
page offset 00000010, page type <B-tree Node>, page level <0000>
page offset 00000011, page type <B-tree Node>, page level <0000>
page offset 00000012, page type <B-tree Node>, page level <0000>
page offset 00000013, page type <B-tree Node>, page level <0000>
page offset 00000014, page type <B-tree Node>, page level <0000>
page offset 00000015, page type <B-tree Node>, page level <0000>
page offset 00000016, page type <B-tree Node>, page level <0000>
page offset 00000017, page type <B-tree Node>, page level <0000>
page offset 00000018, page type <B-tree Node>, page level <0000>
page offset 00000019, page type <B-tree Node>, page level <0000>
page offset 0000001a, page type <B-tree Node>, page level <0000>
page offset 0000001b, page type <B-tree Node>, page level <0000>
page offset 0000001c, page type <B-tree Node>, page level <0000>
page offset 0000001d, page type <B-tree Node>, page level <0000>
page offset 0000001e, page type <B-tree Node>, page level <0000>
page offset 0000001f, page type <B-tree Node>, page level <0000>
page offset 00000020, page type <B-tree Node>, page level <0000>
page offset 00000021, page type <B-tree Node>, page level <0000>
page offset 00000022, page type <B-tree Node>, page level <0000>
page offset 00000023, page type <B-tree Node>, page level <0000>
page offset 00000024, page type <B-tree Node>, page level <0000>
page offset 00000025, page type <B-tree Node>, page level <0000>
page offset 00000026, page type <B-tree Node>, page level <0000>
page offset 00000027, page type <B-tree Node>, page level <0000>
page offset 00000028, page type <B-tree Node>, page level <0000>
page offset 00000029, page type <B-tree Node>, page level <0000>
page offset 0000002a, page type <B-tree Node>, page level <0000>
page offset 0000002b, page type <B-tree Node>, page level <0000>
page offset 0000002c, page type <B-tree Node>, page level <0000>
page offset 0000002d, page type <B-tree Node>, page level <0000>
page offset 0000002e, page type <B-tree Node>, page level <0000>
page offset 0000002f, page type <B-tree Node>, page level <0000>
page offset 00000030, page type <B-tree Node>, page level <0000>
page offset 00000031, page type <B-tree Node>, page level <0000>
page offset 00000032, page type <B-tree Node>, page level <0000>
page offset 00000033, page type <B-tree Node>, page level <0000>
page offset 00000034, page type <B-tree Node>, page level <0000>
page offset 00000035, page type <B-tree Node>, page level <0000>
page offset 00000036, page type <B-tree Node>, page level <0000>
page offset 00000037, page type <B-tree Node>, page level <0000>
page offset 00000038, page type <B-tree Node>, page level <0000>
page offset 00000039, page type <B-tree Node>, page level <0000>
page offset 0000003a, page type <B-tree Node>, page level <0000>
page offset 0000003b, page type <B-tree Node>, page level <0000>
page offset 0000003c, page type <B-tree Node>, page level <0000>
page offset 0000003d, page type <B-tree Node>, page level <0000>
page offset 0000003e, page type <B-tree Node>, page level <0000>
page offset 0000003f, page type <B-tree Node>, page level <0000>
page offset 00000040, page type <B-tree Node>, page level <0000>
page offset 00000041, page type <B-tree Node>, page level <0000>
page offset 00000042, page type <B-tree Node>, page level <0000>
page offset 00000043, page type <B-tree Node>, page level <0000>
page offset 00000044, page type <B-tree Node>, page level <0000>
page offset 00000045, page type <B-tree Node>, page level <0000>
page offset 00000046, page type <B-tree Node>, page level <0000>
page offset 00000047, page type <B-tree Node>, page level <0000>
page offset 00000048, page type <B-tree Node>, page level <0000>
... 55條：page offset 00000000, page type <Freshly Allocated Page>

page offset 00000080, page type <B-tree Node>, page level <0000>
page offset 00000081, page type <B-tree Node>, page level <0000>
page offset 00000082, page type <B-tree Node>, page level <0000>
page offset 00000083, page type <B-tree Node>, page level <0000>
page offset 00000084, page type <B-tree Node>, page level <0000>
page offset 00000085, page type <B-tree Node>, page level <0000>
page offset 00000086, page type <B-tree Node>, page level <0000>
page offset 00000087, page type <B-tree Node>, page level <0000>
page offset 00000088, page type <B-tree Node>, page level <0000>
page offset 00000089, page type <B-tree Node>, page level <0000>
page offset 0000008a, page type <B-tree Node>, page level <0000>
page offset 0000008b, page type <B-tree Node>, page level <0000>
... 500條：page offset 00000000, page type <Freshly Allocated Page>

Total number of page: 640:
Freshly Allocated Page: 555
Insert Buffer Bitmap: 1
File Space Header: 1
B-tree Node: 82
File Segment inode: 1

結合下面的圖感受分析：
表`t`的INODE結構二進位制分析

開始分析

INode在第三頁，即0x8000~0xbfff。

00008000: ‘0A E5 97 54 00 00 00 02 00 00 00 00 00 00 00 00
00008010: 00 00 00 0F B6 D9 40 1F 00 03 00 00 00 00 00 00
00008020: 00 00 00 00 03 6E’ FF FF FF FF 00 00 FF FF FF FF

當前該段屬於哪個索引，在專門講解Page的時候提到過。Page.PAGE_INDEX_ID索引ID–表示當前頁屬於哪個索引。
雖然找到了這個值：00 00 00 00 00 00 07 17，但是我該如何查詢是哪個索引呢？

段01

00008030: 00 00 ‘`00 00 00 00 00 00 00 01` `00 00 00 00` `00 00
00008040: 00 00 FF FF FF FF 00 00 FF FF FF FF 00 00` `00 00
00008050: 00 00 FF FF FF FF 00 00 FF FF FF FF 00 00` `00 00
00008060: 00 00 FF FF FF FF 00 00 FF FF FF FF 00 00` `05 D6
00008070: 69 D2` `00 00 00 03` FF FF FF FF FF FF FF FF FF FF
00008080: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008090: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
000080a0: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
000080b0: FF FF FF FF FF FF’ ‘FF FF FF FF FF FF FF FF FF FF
000080c0: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
000080d0: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
000080e0: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
000080f0: FF FF’ 00 00 00 00 00 00 00 02 00 00 00 0C 00 00

Fragment：頁號0x03–索引頁–非葉子節點–對應id主鍵。

段02

000080f0: FF FF ‘`00 00 00 00 00 00 00 02` `00 00 00 0C` `00 00
00008100: 00 00 FF FF FF FF 00 00 FF FF FF FF 00 00` `00 00
00008110: 00 01 00 00 00 00 00 EE 00 00 00 00 00 EE` `00 00
00008120: 00 00 FF FF FF FF 00 00 FF FF FF FF 00 00` `05 D6
00008130: 69 D2` 00 00 00 07 00 00 00 08 00 00 00 09 00 00
00008140: 00 0A 00 00 00 0B 00 00 00 0E 00 00 00 0F 00 00
00008150: 00 12 00 00 00 16 00 00 00 18 00 00 00 19 00 00
00008160: 00 1A 00 00 00 1D 00 00 00 1E 00 00 00 1F 00 00
00008170: 00 22 00 00 00 26 00 00 00 27 00 00 00 28 00 00
00008180: 00 2A 00 00 00 2C 00 00 00 2D 00 00 00 2E 00 00
00008190: 00 2F 00 00 00 30 00 00 00 31 00 00 00 34 00 00
000081a0: 00 36 00 00 00 38 00 00 00 3B 00 00 00 40 00 00
000081b0: 00 41’ 00 00 00 00 00 00 00 03 00 00 00 00 00 00

Segment ID：0x02
NOT_FULL_N_USED：值為0x0C。對應下面XDES Entry.Page State Bitmap，都是12。
Fragment：已寫滿–資料頁–葉子節點–對應id主鍵。
FREE：預設
NOT_FULL：00 00 00 01 00 00 00 00 00 EE 00 00 00 00 00 EE
FULL：預設

分析NOT_FULL：
連結串列長度為1，值為00 00 00 01。
頭尾指標都指向了00 00 00 00 00 EE。前4B表示頁號：0x00，後2B表示偏移量0xEE。這是一個XDES Entry的List Node起始位置。部分資料如：

000000d0: 00 00 00 00 00 02 AA AA FE FF FF FF FF FF FF FF
000000e0: FF FF FF FF FF FF ‘`00 00 00 00 00 00 00 02` `FF FF
000000f0: FF FF 00 00 FF FF FF FF 00 00` `00 00 00 04` AA AA
00000100: AA FF FF FF FF FF FF FF FF FF FF FF FF FF’ 00 00

- `Segment ID`：0x02

段03

000081b0: 00 41 ‘`00 00 00 00 00 00 00 03` `00 00 00 00` `00 00
000081c0: 00 00 FF FF FF FF 00 00 FF FF FF FF 00 00` `00 00
000081d0: 00 00 FF FF FF FF 00 00 FF FF FF FF 00 00` `00 00
000081e0: 00 00 FF FF FF FF 00 00 FF FF FF FF 00 00` `05 D6
000081f0: 69 D2` `00 00 00 04` FF FF FF FF FF FF FF FF FF FF
00008200: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008210: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008220: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008230: FF FF FF FF FF FF’ FF FF FF FF FF FF FF FF FF FF
00008240: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008250: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008260: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008270: FF FF’ 00 00 00 00 00 00 00 04 00 00 00 00 00 00

Fragment：頁號0x04–索引頁–非葉子節點–對應xx索引。

段04

00008270: FF FF ‘00 00 00 00 00 00 00 04 00 00 00 00 00 00
00008280: 00 00 FF FF FF FF 00 00 FF FF FF FF 00 00 00 00
00008290: 00 00 FF FF FF FF 00 00 FF FF FF FF 00 00 00 00
000082a0: 00 00 FF FF FF FF 00 00 FF FF FF FF 00 00 05 D6
000082b0: 69 D2 00 00 00 0C 00 00 00 0D 00 00 00 13 00 00
000082c0: 00 17 00 00 00 20 00 00 00 21 00 00 00 24 00 00
000082d0: 00 25 00 00 00 35 00 00 00 39 00 00 00 3C 00 00
000082e0: 00 3D 00 00 00 3E 00 00 00 42 00 00 00 43 00 00
000082f0: 00 44 FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008300: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008310: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008320: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008330: FF FF’ 00 00 00 00 00 00 00 05 00 00 00 00 00 00

Fragment：未寫滿–資料頁–葉子節點–對應xx索引。

段05

00008330: FF FF ‘00 00 00 00 00 00 00 05 00 00 00 00 00 00
00008340: 00 00 FF FF FF FF 00 00 FF FF FF FF 00 00 00 00
00008350: 00 00 FF FF FF FF 00 00 FF FF FF FF 00 00 00 00
00008360: 00 00 FF FF FF FF 00 00 FF FF FF FF 00 00 05 D6
00008370: 69 D2 00 00 00 05 FF FF FF FF FF FF FF FF FF FF
00008380: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008390: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
000083a0: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
000083b0: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
000083c0: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
000083d0: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
000083e0: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
000083f0: FF FF’ 00 00 00 00 00 00 00 06 00 00 00 00 00 00

Fragment：頁號0x05–索引頁–非葉子節點–對應xx索引。

段06

000083f0: FF FF ‘00 00 00 00 00 00 00 06 00 00 00 00 00 00
00008400: 00 00 FF FF FF FF 00 00 FF FF FF FF 00 00 00 00
00008410: 00 00 FF FF FF FF 00 00 FF FF FF FF 00 00 00 00
00008420: 00 00 FF FF FF FF 00 00 FF FF FF FF 00 00 05 D6
00008430: 69 D2 00 00 00 14 00 00 00 15 00 00 00 1C 00 00
00008440: 00 29 00 00 00 33 00 00 00 45 00 00 00 48 FF FF
00008450: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008460: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008470: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008480: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008490: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
000084a0: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
000084b0: FF FF’ 00 00 00 00 00 00 00 07 00 00 00 00 00 00

Fragment：未寫滿–資料頁–葉子節點–對應xx索引。

段07

000084b0: FF FF ‘00 00 00 00 00 00 00 07 00 00 00 00 00 00
000084c0: 00 00 FF FF FF FF 00 00 FF FF FF FF 00 00 00 00
000084d0: 00 00 FF FF FF FF 00 00 FF FF FF FF 00 00 00 00
000084e0: 00 00 FF FF FF FF 00 00 FF FF FF FF 00 00 05 D6
000084f0: 69 D2 00 00 00 06 FF FF FF FF FF FF FF FF FF FF
00008500: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008510: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008520: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008530: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008540: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008550: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008560: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008570: FF FF’ 00 00 00 00 00 00 00 08 00 00 00 00 00 00

Fragment：頁號0x06–索引頁–非葉子節點–對應xx索引。

段08

00008570: FF FF ‘00 00 00 00 00 00 00 08 00 00 00 00 00 00
00008580: 00 00 FF FF FF FF 00 00 FF FF FF FF 00 00 00 00
00008590: 00 00 FF FF FF FF 00 00 FF FF FF FF 00 00 00 00
000085a0: 00 00 FF FF FF FF 00 00 FF FF FF FF 00 00 05 D6
000085b0: 69 D2 00 00 00 10 00 00 00 11 00 00 00 1B 00 00
000085c0: 00 23 00 00 00 2B 00 00 00 32 00 00 00 37 00 00
000085d0: 00 3A 00 00 00 3F 00 00 00 46 00 00 00 47 FF FF
000085e0: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
000085f0: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008600: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008610: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008620: FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF
00008630: FF FF’ 00 00 00 00 00 00 00 00 00 00 00 00 00 00

Fragment：未寫滿–資料頁–葉子節點–對應xx索引。

本作品採用《CC 協議》，轉載必須註明作者和本文連結

阿門阿前一棵葡萄樹阿嫩阿嫩綠地剛發芽蝸牛揹著那重重的殼呀一步一步地往上爬

表`t`的XDES Entry結構檔案分析
2020-09-21
檔案描述符、開啟檔案表以及inode
2018-01-04
INODE結構二進位制頁分析
2020-09-19
列出檔案的inode資訊
2007-06-26
wsdl檔案結構分析
2011-06-16
REdis AOF檔案結構分析
2019-03-22
Redis
VFS檔案系統結構分析
2016-09-09
例項分析JAVA CLASS的檔案結構
2019-02-21
Java
類檔案結構_class類檔案的的結構
2018-04-11
PE檔案結構（四）輸出表
2014-10-06
EXT4檔案系統學習（9）VFS之磁碟結構inode和direntry
2019-02-13
Mysql如何讀.frm結尾的表結構定義檔案
2017-11-08
MySql
檢視linux中檔案的inode資訊
2011-03-14
Linux
EXT4檔案系統學習（11）VFS之記憶體結構sb和inode
2019-02-13
記憶體
Java Class檔案結構例項分析（下）
2018-12-18
Java
Java Class檔案結構例項分析（上）
2018-10-14
Java
控制檔案的結構
2010-07-10
理解Linux檔案系統之 inode
2020-10-19
Linux
class檔案的基本結構及proxy原始碼分析二
2020-07-10
原始碼
BMP檔案結構
2013-12-20
用sed從mysqldump全備檔案中取出某張表的表結構
2020-04-12
MySql
【Mysql】Mysql從frm檔案裡恢復表結構
2016-05-04
MySql
通過替換frm檔案方式修改表結構
2015-12-08
Linux檔案系統iNode及stat命令
2022-03-17
Linux
GPFS檔案系統inode數是否有限制？
2015-08-18
mysql 從 frm 檔案恢復 table 表結構的3種方法
2018-09-27
MySql
檔案的邏輯結構、檔案目錄
2020-11-21
linux下的檔案結構
2015-01-11
Linux
ODBC檔案DSN 的結構 (轉)
2007-12-02
PE 檔案結構圖
2023-09-05
Class類檔案結構
2017-08-18
Linux檔案結構
2011-06-19
Linux
BMP檔案結構 (轉)
2007-12-12
oracle結構梳理---歸檔檔案
2015-01-28
Oracle
Macbook磁碟系統結構/檔案/目錄介紹分析
2023-12-05
Mac
sqlserver關於filestream檔案流、filetable檔案表的總結
2019-05-20
SQLServer
資料表結構更新後，遷移檔案怎麼使用？
2020-08-17
深入解析Class類檔案的結構
2019-03-24

表`t`的INODE結構檔案分析

前言

開始分析

段01

段02

段03

段04

段05

段06

段07

段08

相關文章