MySQL-5.7 setting InnoDB table data file storage location

[[email protected] data]# lsa1  a2  a3  auto.cnf  ib_buffer_pool  ibdata1  ib_logfile0  ib_logfile1  ibtmp1  localhost.localdomain.err  localhost.localdomain.pid  mysql  performance_schema  sys

IBDATA1 is the shared storage space for the InnoDB table, and the default InnoDB all table data is in one ibdata1.

View current configuration

mysql> show variables like ‘%per_table%‘;+-----------------------+-------+| Variable_name         | Value |+-----------------------+-------+| innodb_file_per_table | ON    |+-----------------------+-------+1 row in set (0.02 sec)

is currently open, indicating that the data will be stored separately by table.

If not, set the configuration file and add the following line:

innodb_file_per_table=1

MySQL-5.7 setting InnoDB table data file storage location