Tables Rows: 0  Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0  Auto_increment: NULL Create_time: 2021-02-18 12:18:28 Update_time: NULL Check_time: NULL Collation: utf8mb4_0900_ai_ci Checksum: NULL  Create_options:  Comment:  mysql>  SELECT * FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME=’test/t1’ \G *************************** 1. row *************************** TABLE_ID: 1144 NAME: test/t1 FLAG: 33 N_COLS: 5 SPACE: 30 ROW_FORMAT: Dynamic ZIP_PAGE_SIZE: 0 SPACE_TYPE: Single  INSTANT_COLS: 0 mysql>  SELECT @@innodb_file_per_table; +-------------------------+ | @@innodb_file_per_table | +-------------------------+ | 1 | For information about  SHOW TABLE STATUS  output, see Section 13.7.7.38, “SHOW TABLE STATUS Statement” . You can also access  InnoDB  table properties by querying the  InnoDB  Information Schema system tables: For more information, see Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables” . There are different reasons for creating  InnoDB  tables externally; that is, creating tables outside of the data directory. Those reasons might include space management, I/O optimization, or placing tables on a storage device with particular performance or capacity characteristics, for example. InnoDB  supports the following methods for creating tables externally: You can create an  InnoDB  table in an external directory by specifying a  DATA DIRECTORY  clause in the CREATE TABLE  statement. CREATE TABLE t1 (c1 INT PRIMARY KEY) DATA DIRECTORY = ’ /external/directory ’; The  DATA DIRECTORY  clause is supported for tables created in file-per-table tablespaces. Tables are implicitly created in file-per-table tablespaces when the  innodb_file_per_table  variable is enabled, which it is by default. 3018 15.6.1.2 Creating Tables Externally Using the DATA DIRECTORY Clause •Using the DATA DIRECTORY Clause •Using CREATE TABLE ... TABLESPACE Syntax •Creating a Table in an External General Tablespace