Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.3Mb
PDF (A4) - 43.4Mb
Man Pages (TGZ) - 297.3Kb
Man Pages (Zip) - 402.5Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

25.6.16.35 The ndbinfo files Table

Thefiles tables provides information about files and other objects used byNDB disk data tables, and contains the columns listed here:

  • id

    Object ID

  • type

    The type of object; one ofLog file group,Tablespace,Undo file, orData 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 always0, and theparent_name,free_extents,total_extents,extent_size,initial_size,maximum_size, andautoentend_size columns are allNULL.

Thefiles table is empty if no disk data objects have been created inNDB. SeeSection 25.6.11.1, “NDB Cluster Disk Data Objects”, for more information.

Thefiles table was added in NDB 8.0.29.

See alsoSection 28.3.15, “The INFORMATION_SCHEMA FILES Table”.