文件首頁
NDB Cluster 內部結構
相關文件
MySQL NDB Cluster 8.1 手冊
MySQL NDB Cluster 8.0 手冊
NDB Cluster API 開發人員指南
下載本手冊
PDF (美式信紙) - 1.2Mb
PDF (A4) - 1.2Mb

2.42 DUMP 2304

程式碼

2304

符號

---

核心區塊

DBLQH

說明。 此命令會將所有片段日誌檔案及其狀態寫入資料節點的輸出檔案（在資料節點的節點 ID 為 5 的情況下，這會是 ndb_5_out.log）。片段日誌檔案的數量由 NoOfFragmentLogFiles 資料節點組態參數控制。

範例輸出。 以下取自具有 2 個資料節點的 NDB Cluster 中的 ndb_5_out.log

LP 0 blockInstance: 1 partNo: 0 state: 0 WW_Gci: 1 gcprec: -256 flq: 4294967040 4294967040 currfile: 0 tailFileNo: 0 logTailMbyte: 2 cnoOfLogPages: 1016 problems: 0x0
  file 0(0)  FileChangeState: 0  logFileStatus: 20  currentMbyte: 2  currentFilepage 75
  file 1(1)  FileChangeState: 0  logFileStatus: 20  currentMbyte: 0  currentFilepage 0
  file 2(2)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 3(3)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 4(4)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 5(5)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 6(6)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 7(7)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 8(8)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 9(9)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 10(10)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 11(11)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 12(12)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 13(13)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 14(14)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 15(15)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
LP 1 blockInstance: 1 partNo: 1 state: 0 WW_Gci: 1 gcprec: -256 flq: 4294967040 4294967040 currfile: 16 tailFileNo: 0 logTailMbyte: 2 cnoOfLogPages: 1016 problems: 0x0
  file 0(16)  FileChangeState: 0  logFileStatus: 20  currentMbyte: 2  currentFilepage 69
  file 1(17)  FileChangeState: 0  logFileStatus: 20  currentMbyte: 0  currentFilepage 0
  file 2(18)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 3(19)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 4(20)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 5(21)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 6(22)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 7(23)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 8(24)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 9(25)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 10(26)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 11(27)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 12(28)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 13(29)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 14(30)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 15(31)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
LP 2 blockInstance: 1 partNo: 2 state: 0 WW_Gci: 1 gcprec: -256 flq: 4294967040 4294967040 currfile: 32 tailFileNo: 0 logTailMbyte: 2 cnoOfLogPages: 1016 problems: 0x0
  file 0(32)  FileChangeState: 0  logFileStatus: 20  currentMbyte: 2  currentFilepage 69
  file 1(33)  FileChangeState: 0  logFileStatus: 20  currentMbyte: 0  currentFilepage 0
  file 2(34)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 3(35)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 4(36)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 5(37)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 6(38)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 7(39)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 8(40)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 9(41)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 10(42)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 11(43)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 12(44)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 13(45)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 14(46)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 15(47)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
LP 3 blockInstance: 1 partNo: 3 state: 0 WW_Gci: 1 gcprec: -256 flq: 4294967040 4294967040 currfile: 48 tailFileNo: 0 logTailMbyte: 2 cnoOfLogPages: 1016 problems: 0x0
  file 0(48)  FileChangeState: 0  logFileStatus: 20  currentMbyte: 2  currentFilepage 69
  file 1(49)  FileChangeState: 0  logFileStatus: 20  currentMbyte: 0  currentFilepage 0
  file 2(50)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 3(51)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 4(52)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 5(53)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 6(54)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 7(55)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 8(56)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 9(57)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 10(58)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 11(59)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 12(60)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 13(61)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 14(62)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 15(63)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0

其他資訊。 下面的 2 個表格提供有關檔案變更狀態代碼和日誌檔案狀態代碼的資訊，如先前範例所示。

FileChangeState 代碼

表 2.5 FileChangeState 代碼狀態

值 檔案變更狀態
0 內容列 1，欄 2
1 NOT_ONGOING
2 BOTH_WRITES_ONGOING
3 LAST_WRITE_ONGOING
4 WRITE_PAGE_ZERO_ONGOING

LogFileStatus 代碼

表 2.6 LogFileStatus 代碼，包含日誌檔案狀態與說明

值 日誌檔案狀態 說明
0 LFS_IDLE 日誌檔案記錄未使用
1 CLOSED 日誌檔案已關閉。
2 OPENING_INIT ---
3 OPEN_SR_FRONTPAGE 日誌檔案在系統重新啟動時開啟；開啟檔案 0 以尋找日誌部分的首頁。
4 OPEN_SR_LAST_FILE 開啟在系統重新啟動之前寫入的最後一個日誌檔案。
5 OPEN_SR_NEXT_FILE 開啟 16 個檔案之前的日誌檔案（以尋找有關 GCP 的下一個可用資訊）。
6 OPEN_EXEC_SR_START 在系統重新啟動期間執行日誌時開啟的日誌檔案。
7 OPEN_EXEC_SR_NEW_MBYTE ---
8 OPEN_SR_FOURTH_PHASE ---
9 OPEN_SR_FOURTH_NEXT ---
10 OPEN_SR_FOURTH_ZERO ---
11 OPENING_WRITE_LOG 在寫入日誌時開啟的日誌檔案（正常操作）。
12 OPEN_EXEC_LOG ---
13 CLOSING_INIT ---
14 CLOSING_SR 日誌檔案在系統重新啟動時關閉。目前嘗試尋找從何處開始執行日誌。
15 CLOSING_EXEC_SR 日誌檔案在系統重新啟動期間執行日誌時關閉。
16 CLOSING_EXEC_SR_COMPLETED ---
17 CLOSING_WRITE_LOG 日誌檔案在正常操作期間寫入日誌時關閉。
18 CLOSING_EXEC_LOG ---
19 OPEN_INIT ---
20 OPEN 日誌檔案開啟。
21 OPEN_SR_READ_INVALIDATE_PAGES ---
22 CLOSE_SR_READ_INVALIDATE_PAGES ---
23 OPEN_SR_WRITE_INVALIDATE_PAGES ---
24 CLOSE_SR_WRITE_INVALIDATE_PAGES ---
25 OPEN_SR_READ_INVALIDATE_SEARCH_FILES ---
26 CLOSE_SR_READ_INVALIDATE_SEARCH_FILES ---
27 CLOSE_SR_READ_INVALIDATE_SEARCH_LAST_FILE ---
28 OPEN_EXEC_LOG_CACHED ---
29 CLOSING_EXEC_LOG_CACHED ---

有關如何定義這些代碼的更多資訊，請參閱原始程式碼檔案 storage/ndb/src/kernel/blocks/dblqh/Dblqh.hpp。另請參閱第 2.43 節，「DUMP 2305」。


上一頁   首頁   上一層   下一頁
相關文件
MySQL NDB Cluster 8.1 手冊
MySQL NDB Cluster 8.0 手冊
NDB Cluster API 開發人員指南
下載本手冊
PDF (美式信紙) - 1.2Mb
PDF (A4) - 1.2Mb