The files tables provides information about
files and other objects used by NDB disk data
tables, and contains the columns listed here:
idObject ID
typeThe type of object; one of
Log file group,Tablespace,Undo file, orData filenameThe name of the object
parentID of the parent object
parent_nameName of the parent object
free_extentsNumber of free extents
total_extentsTotal number of extents
extent_sizeExtent size (MB)
initial_sizeInitial size (bytes)
maximum_sizeMaximum size (bytes)
autoextend_sizeAutoextend 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 25.6.11.1, “NDB Cluster Disk Data Objects”, for more
information.
See also Section 28.3.15, “The INFORMATION_SCHEMA FILES Table”.