Skip navigation links

Additional languages
8.1.1.3 Cluster Data Node BackupDataDir Files »
Section Navigation      [Toggle]

8.1.1.2. Cluster Data Node FileSystemDir Files

This directory is named ndb_nodeid_fs, where nodeid is the data node's node ID. It contains the following files and directories:

  • Files:

    • data-nodeid.dat

    • undo-nodeid.dat

  • Directories:

    • LCP: This directory holds 3 subdirectories, named 0, 1, and 2, which contain local checkpoint datafiles (one per checkpoint — see Configuring Parameters for Local Checkpoints).

      These subdirectories each contain a number of files whose names follow the pattern TNFM.Data, where N is a table ID and and M is a fragment number. For each table, there are NoOfFragmentLogFiles fragments, and thus that many files.

    • Directories named D1 and D2, each of which contains 2 subdirectories:

      • DBDICT: Contains data dictionary information. This is stored in:

        • The file P0.SchemaLog

        • A set of directories T0, T1, T2, ..., each of which contains an S0.TableList file.

      • Directories named D8, D9, D10, and D11, each of which contains a directory named DBLQH. In each case, the DBLQH directory contains 8 files named S0.Fraglog, S1.FragLog, ..., S6.FragLog, S7.FragLog.

      • DBDIH: This directory contains the file PX.sysfile, which records information such as the last GCI, restart status, and node group membership of each node; its structure is defined in storage/ndb/src/kernel/blocks/dbdih/Sysfile.hpp in the MySQL source tree. In addition, the SX.FragList files keep records of the fragments belonging to each table.