Mysql innodb_log_files_in_group参数-CSDN博客

本文链接：https://blog.csdn.net/hbhe0316/article/details/122701148

日志组中的日志文件数目。InnoDB 以环型方式(circular fashion)写入文件。数值 3 被推荐使用。在 my.cnf 中以数字格式设置。
1.查看默认值https://www.cndba.cn/hbhe0316/article/22630https://www.cndba.cn/hbhe0316/article/22630https://www.cndba.cn/hbhe0316/article/22630https://www.cndba.cn/hbhe0316/article/22630https://www.cndba.cn/hbhe0316/article/22630

mysql> SHOW VARIABLES LIKE 'innodb_log_files_in_group';
+---------------------------+-------+
| Variable_name             | Value |
+---------------------------+-------+
| innodb_log_files_in_group | 2     |
+---------------------------+-------+
1 row in set (0.00 sec)

2.设置innodb_log_files_in_group

https://www.cndba.cn/hbhe0316/article/22630

mysql> SHOW VARIABLES LIKE 'innodb_log_files_in_group';
+---------------------------+-------+
| Variable_name             | Value |
+---------------------------+-------+
| innodb_log_files_in_group | 3     |
+---------------------------+-------+
1 row in set (0.00 sec)

[root@mysql57 logs]# cat /etc/my.cnf | grep -i innodb_log_files_in_group
innodb_log_files_in_group = 3
[root@mysql57 logs]# service mysqld restart
Shutting down MySQL.... SUCCESS! 
Starting MySQL.. SUCCESS!

MYSQL