MySQL 5.7.24中innodb_file_per_table参数默认值的问题

转载：https://forums.mysql.com/read.php?74,670487,670487

MySQL 5.7.24中innodb_file_per_table参数默认值的问题

Posted by: Johnson Lee
Date: November 13, 2018 02:32AM

 

Hi!
I have a question , I installed MySQL 5.7.24 Enterprise-Commercial edition as an Oracle partner Corp's staff.When I run statement below, I found that this variable's default value is OFF, and I had never self-defined or modified it.Please confirm this question.Thanks!
=====Statement=====================
mysql> show variables like 'innodb_file_per_table';

======ResultSet====================
+-----------------------+-------+
| Variable_name | Value |
+-----------------------+-------+
| innodb_file_per_table | OFF |
+-----------------------+-------+
1 row in set (0.01 sec)

After I set innodb_file_per_table = ON in /etc/my.cnf configuration file and restart MySQL server，the value of this parameter is ON now.
mysql> show variables like 'innodb_file_per_table';
+-----------------------+-------+
| Variable_name | Value |
+-----------------------+-------+
| innodb_file_per_table | ON |
+-----------------------+-------+
1 row in set (0.00 sec)