MYSQL Specifies the file location for the table data directory

Background knowledge:

If the table does not specify a file location, it is saved to Data/database_name/table_file, where data is in the installation directory you specify, in order to improve IO We try our best to

Using the IO capability of multiple hard drives, this will need to save the table to a different disk;

Method 1,

CREATE TABLE table_name (...) Data directory = ' absolute path to directory '

CREATE TABLE T (X int) Data directory = ' E:\DB ';

‘

MYSQL Specifies the file location for the table data directory