21.29.14 The INFORMATION_SCHEMA INNODB_SYS_DATAFILES Table

The INNODB_SYS_DATAFILES table provides datafile path information for InnoDB tablespaces, equivalent to the information in the SYS_DATAFILES table in the InnoDB data dictionary.

Table 21.15 INNODB_SYS_DATAFILES Columns

Column nameDescription
SPACEThe tablespace Space ID.
PATHThe tablespace datafile path (for example, .\world\innodb\city.ibd). If a file-per-table tablespace is created in a location outside the MySQL data directory using the DATA DIRECTORY clause of the CREATE TABLE statement, the tablespace PATH field shows the fully qualified directory path.

Example:

mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_DATAFILES WHERE SPACE = 57 \G 
*************************** 1. row ***************************
SPACE: 57
 PATH: ./test/t1.ibd
1 row in set (0.01 sec)

Notes: