mysql 5.7 修改参数_MySQL :: MySQL 5.7.24中innodb_file_per_table参数默认值的问题

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)