Documentation Home
MySQL NDB Cluster 8.0
Related Documentation Download this Excerpt
PDF (US Ltr) - 4.7Mb
PDF (A4) - 4.8Mb


6.16.35 The ndbinfo files Table

The files tables provides information about files and other objects used by NDB disk data tables, and contains the columns listed here:

  • id

    Object ID

  • type

    The type of object; one of Log file group, Tablespace, Undo file, or Data file

  • name

    The name of the object

  • parent

    ID of the parent object

  • parent_name

    Name of the parent object

  • free_extents

    Number of free extents

  • total_extents

    Total number of extents

  • extent_size

    Extent size (MB)

  • initial_size

    Initial size (bytes)

  • maximum_size

    Maximum size (bytes)

  • autoextend_size

    Autoextend size (bytes)

For log file groups and tablespaces, parent is always 0, and the parent_name, free_extents, total_extents, extent_size, initial_size, maximum_size, and autoentend_size columns are all NULL.

The files table is empty if no disk data objects have been created in NDB. See Section 6.11.1, “NDB Cluster Disk Data Objects”, for more information.

The files table was added in NDB 8.0.29.

See also The INFORMATION_SCHEMA FILES Table.