Skip navigation links

Additional languages
MySQL 5.4 Reference Manual :: 19 INFORMATION_SCHEMA Tables :: 19.21 The INFORMATION_SCHEMA FILES Table
19.22 The INFORMATION_SCHEMA PROCESSLIST Table »
Section Navigation      [Toggle]

19.21. The INFORMATION_SCHEMA FILES Table

The FILES table provides information about the files in which MySQL Falcon tablespace data is stored. The table was added in MySQL 5.4.4.

INFORMATION_SCHEMA Name SHOW Name Remarks
FILE_ID   MySQL extension
FILE_NAME   MySQL extension
FILE_TYPE   MySQL extension
TABLESPACE_NAME   MySQL extension
TABLE_CATALOG   MySQL extension
TABLE_SCHEMA   MySQL extension
TABLE_NAME   MySQL extension
LOGFILE_GROUP_NAME   MySQL extension
LOGFILE_GROUP_NUMBER   MySQL extension
ENGINE   MySQL extension
FULLTEXT_KEYS   MySQL extension
DELETED_ROWS   MySQL extension
UPDATE_COUNT   MySQL extension
FREE_EXTENTS   MySQL extension
TOTAL_EXTENTS   MySQL extension
EXTENT_SIZE   MySQL extension
INITIAL_SIZE   MySQL extension
MAXIMUM_SIZE   MySQL extension
AUTOEXTEND_SIZE   MySQL extension
CREATION_TIME   MySQL extension
LAST_UPDATE_TIME   MySQL extension
LAST_ACCESS_TIME   MySQL extension
RECOVER_TIME   MySQL extension
TRANSACTION_COUNTER   MySQL extension
VERSION   MySQL extension
ROW_FORMAT   MySQL extension
TABLE_ROWS   MySQL extension
AVG_ROW_LENGTH   MySQL extension
DATA_LENGTH   MySQL extension
MAX_DATA_LENGTH   MySQL extension
INDEX_LENGTH   MySQL extension
DATA_FREE   MySQL extension
CREATE_TIME   MySQL extension
UPDATE_TIME   MySQL extension
CHECK_TIME   MySQL extension
CHECKSUM   MySQL extension
STATUS   MySQL extension
EXTRA   MySQL extension

Notes:

  • FILE_ID column values are auto-generated.

  • FILE_NAME is the name of a data file created by CREATE TABLESPACE or ALTER TABLESPACE.

  • FILE_TYPE is SYSTEM DATAFILE for the FALCON_MASTER, FALCON_USER and FALCON_TEMPORARY tablespace files, or USER DATAFILE for any user-create tablespace files.

  • TABLESPACE_NAME is the name of the tablespace with which the file is associated.

  • Currently, the value of the TABLESPACE_CATALOG column is always NULL.

  • TABLE_NAME is the name of the table with which the file is associated, if any.

  • The EXTENT_SIZE is always 0.

  • For MySQL Falcon tablespace files, the following columns are always NULL:

    • TABLESPACE_CATALOG

    • TABLE_SCHEMA

    • TABLE_NAME

    • LOGFILE_GROUP_NAME

    • LOGFILE_GROUP_NUMBER

    • FULLTEXT_KEYS

    • DELETED_ROWS

    • UPDATE_COUNT

    • FREE_EXTENTS

    • TOTAL_EXTENTS

    • INITIAL_SIZE

    • MAXIMUM_SIZE

    • AUTOEXTEND_SIZE

    • CREATION_TIME

    • LAST_UPDATE_TIME

    • LAST_ACCESS_TIME

    • RECOVER_TIME

    • TRANSACTION_COUNTER

    • VERSION

    • ROW_FORMAT

    • TABLE_ROWS

    • AVG_ROW_LENGTH

    • DATA_LENGTH

    • MAX_DATA_LENGTH

    • INDEX_LENGTH

    • DATA_FREE

    • CREATE_TIME

    • UPDATE_TIME

    • CHECK_TIME

    • CHECKSUM

  • For Falcon tablespaces, the value of the STATUS column is always NORMAL.

  • There are no SHOW commands associated with the FILES table.