The INFORMATION_SCHEMA FILES Table • LOGFILE_GROUP_NAME • LOGFILE_GROUP_NUMBER • ENGINE • DELETED_ROWS • FULLTEXT_KEYS • UPDATE_COUNT • FREE_EXTENTS • TOTAL_EXTENTS • EXTENT_SIZE • INITIAL_SIZE 4793 For  InnoDB : The initial size of the file in bytes. For  NDB : The size of an extent for the file in bytes. For  InnoDB : Extent size is 1048576 (1MB) for files with a 4KB, 8KB, or 16KB page size. Extent size is 2097152 bytes (2MB) for files with a 32KB page size, and 4194304 (4MB) for files with a 64KB page size.  FILES  does not report  InnoDB  page size. Page size is defined by the  innodb_page_size system variable. Extent size information can also be retrieved from the  INNODB_TABLESPACES  table where  FILES.FILE_ID = INNODB_TABLESPACES.SPACE . For  NDB : The total number of extents allocated to the file. For  InnoDB : The number of full extents used in the current data file. Any partial extent at the end of the file is not counted. For  InnoDB : The number of fully free extents in the current data file. For  NDB : The number of extents which have not yet been used by the file. This is always  NULL . This is always  NULL . This is always  NULL . For  NDB : This value is always  ndbcluster . For  InnoDB : This value is always  InnoDB . For  NDB : For a Disk Data undo log file, the auto-generated ID number of the log file group to which the log file belongs. This is the same as the value shown for the  id  column in the ndbinfo.dict_obj_info  table and the  log_id  column in the  ndbinfo.logspaces  and ndbinfo.logspaces  tables for this undo log file. For  InnoDB : This is always  NULL . For  NDB : The name of the log file group to which the log file or data file belongs. For  InnoDB : This is always  NULL .