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: 

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: 

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 

For more information, see Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables” . 

## 15.6.1.2 Creating Tables Externally 

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. 

## Using the DATA DIRECTORY Clause 

InnoDB  supports the following methods for creating tables externally: 

•Using the DATA DIRECTORY Clause 

•Using CREATE TABLE ... TABLESPACE Syntax 

•Creating a Table in an External General Tablespace 

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. 

mysql> SELECT @@innodb_file_per_table; +-------------------------+ | @@innodb_file_per_table | +-------------------------+ | 1 | 

