MySQL :: MySQL 8.4 Reference Manual :: 28.4.10 The INFORMATION_SCHEMA INNODB

Documentation Home

version 8.4

8.0 current

8.0 Japanese

MySQL 8.4 Reference Manual / ... / The INFORMATION_SCHEMA INNODB_DATAFILES Table

28.4.10 INFORMATION_SCHEMA INNODB_DATAFILES 表

The INNODB_DATAFILES table provides data file path information for InnoDB file-per-table and general tablespaces.

For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”.

Note

The INFORMATION_SCHEMA FILES table reports metadata for InnoDB tablespace types including file-per-table tablespaces, general tablespaces, the system tablespace, the global temporary tablespace, and undo tablespaces.

The INNODB_DATAFILES table has these columns:

SPACE

The tablespace ID.
PATH

The tablespace data file path. If a file-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.

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

You must have the PROCESS privilege to query this table.
Use the INFORMATION_SCHEMA COLUMNS table or the SHOW COLUMNS statement to view additional information about the columns of this table, including data types and default values.

PREV HOME UP NEXT