MySQL :: NDB 叢集內部結構 :: 2.39 DUMP 2301

NDB 叢集內部結構 / NDB 叢集管理用戶端 DUMP 指令 / DUMP 2301

2.39 DUMP 2301

程式碼: 2301
符號: LqhDumpAllScanRec
核心區塊: DBLQH

描述。 將所有掃描記錄傾印到叢集日誌。

範例輸出。 此處僅顯示單一資料節點記錄到日誌中的前幾個掃描記錄。

2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6: LQH: Dump all ScanRecords - size: 514
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6: Dblqh::ScanRecord[1]: state=0, type=0, complStatus=0, scanNodeId=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  apiBref=0x2f40006, scanAccPtr=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  copyptr=-256, ailen=6, complOps=0, concurrOps=16
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  errCnt=0, schV=1
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  stpid=0, flag=2, lhold=0, lmode=0, num=134
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  relCount=16, TCwait=0, TCRec=2, KIflag=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  LcpScan=1  RowId(0:0)
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6: Dblqh::ScanRecord[2]: state=0, type=0, complStatus=0, scanNodeId=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  apiBref=0x0, scanAccPtr=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  copyptr=0, ailen=0, complOps=0, concurrOps=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  errCnt=0, schV=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  stpid=0, flag=0, lhold=0, lmode=0, num=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  relCount=0, TCwait=0, TCRec=0, KIflag=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  LcpScan=0  RowId(0:0)
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6: Dblqh::ScanRecord[3]: state=0, type=0, complStatus=0, scanNodeId=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  apiBref=0x0, scanAccPtr=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  copyptr=0, ailen=0, complOps=0, concurrOps=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  errCnt=0, schV=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  stpid=0, flag=0, lhold=0, lmode=0, num=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  relCount=0, TCwait=0, TCRec=0, KIflag=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  LcpScan=0  RowId(0:0)
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6: Dblqh::ScanRecord[4]: state=0, type=0, complStatus=0, scanNodeId=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  apiBref=0x0, scanAccPtr=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  copyptr=0, ailen=0, complOps=0, concurrOps=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  errCnt=0, schV=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  stpid=0, flag=0, lhold=0, lmode=0, num=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  relCount=0, TCwait=0, TCRec=0, KIflag=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  LcpScan=0  RowId(0:0)
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6: Dblqh::ScanRecord[5]: state=0, type=0, complStatus=0, scanNodeId=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  apiBref=0x0, scanAccPtr=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  copyptr=0, ailen=0, complOps=0, concurrOps=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  errCnt=0, schV=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  stpid=0, flag=0, lhold=0, lmode=0, num=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  relCount=0, TCwait=0, TCRec=0, KIflag=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  LcpScan=0  RowId(0:0)
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6: Dblqh::ScanRecord[6]: state=0, type=0, complStatus=0, scanNodeId=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  apiBref=0x0, scanAccPtr=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  copyptr=0, ailen=0, complOps=0, concurrOps=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  errCnt=0, schV=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  stpid=0, flag=0, lhold=0, lmode=0, num=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  relCount=0, TCwait=0, TCRec=0, KIflag=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  LcpScan=0  RowId(0:0)
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6: Dblqh::ScanRecord[7]: state=0, type=0, complStatus=0, scanNodeId=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  apiBref=0x0, scanAccPtr=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  copyptr=0, ailen=0, complOps=0, concurrOps=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  errCnt=0, schV=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  stpid=0, flag=0, lhold=0, lmode=0, num=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  relCount=0, TCwait=0, TCRec=0, KIflag=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  LcpScan=0  RowId(0:0)
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6: Dblqh::ScanRecord[8]: state=0, type=0, complStatus=0, scanNodeId=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  apiBref=0x0, scanAccPtr=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  copyptr=0, ailen=0, complOps=0, concurrOps=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  errCnt=0, schV=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  stpid=0, flag=0, lhold=0, lmode=0, num=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  relCount=0, TCwait=0, TCRec=0, KIflag=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  LcpScan=0  RowId(0:0)
...

其他資訊。 在生產環境中的 NDB 叢集上，此 DUMP 程式碼應謹慎使用，若非必要則不應使用，因為即使在未負載的相對小型叢集上，也可能會建立數百甚至數千個掃描記錄。因此，通常最好使用 DUMP 2300 列印單一掃描記錄。

第一行提供此資料節點傾印的掃描記錄總數。