Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  / ...  / INFORMATION_SCHEMA Tables  / INFORMATION_SCHEMA InnoDB Tables  /  The INFORMATION_SCHEMA INNODB_SYS_DATAFILES Table

24.4.18 The INFORMATION_SCHEMA INNODB_SYS_DATAFILES Table

TheINNODB_SYS_DATAFILES table provides data file path information forInnoDB file-per-table and general tablespaces, equivalent to the information in theSYS_DATAFILES table in theInnoDB data dictionary.

For related usage information and examples, seeSection 14.16.3, “InnoDB INFORMATION_SCHEMA System Tables”.

Note

TheINFORMATION_SCHEMAFILES table reports metadata for allInnoDB tablespace types including file-per-table tablespaces, general tablespaces, the system tablespace, the temporary tablespace, and undo tablespaces, if present.

TheINNODB_SYS_DATAFILES table has these columns:

  • SPACE

    The tablespace ID.

  • PATH

    The tablespace data file path. If afile-per-table tablespace is created in a location outside the MySQL data directory, the path value is a fully qualified directory path. Otherwise, the path is relative to the data directory.

Example

mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_DATAFILES WHERE SPACE = 57\G*************************** 1. row ***************************SPACE: 57 PATH: ./test/t1.ibd

Notes

  • You must have thePROCESS privilege to query this table.

  • Use theINFORMATION_SCHEMACOLUMNS table or theSHOW COLUMNS statement to view additional information about the columns of this table, including data types and default values.