细节
-
错误
-
状态: Done">完成
-
媒介
-
解决方法: 固定
-
3.0.12
-
没有一个
媒介描述
参数innodb_temp_data_file_path不正确处理,当使用“max”参数。
没有max参数在配置文件中,按预期输出是:
pt-config-diff /etc/mysql/my.cnf h = localhost 1配置差异变量/etc/mysql/my.cnf <主机名> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = innodb_temp_data_file_……ibtmp1:14M: autoextend ibtmp1:12M: autoextend grep innodb_temp_data_file_path /etc/mysql/my.cnf innodb_temp_data_file_path = ibtmp1:14M: autoextend mysql - b - e”显示变量如“innodb_temp_data_file_path”;“Variable_name Value innodb_temp_data_file_path ibtmp1:12M:autoextend
max参数添加到配置时,没有重启服务器,配置中的值是提到一个数字,不是一个字符串:
pt-config-diff /etc/mysql/my.cnf h = localhost 1配置差异变量/etc/mysql/my.cnf <主机名> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = innodb_temp_data_file_……5368709120 ibtmp1:12M: autoextend grep innodb_temp_data_file_path /etc/mysql/my.cnf innodb_temp_data_file_path = ibtmp1:12M: autoextend:马克斯:5 g mysql - b - e”显示变量如“innodb_temp_data_file_path”;“Variable_name Value innodb_temp_data_file_path ibtmp1:12M:autoextend
重启服务器后,提到的配置值是正确的服务器,但仍是错误的配置文件:
pt-config-diff /etc/mysql/my.cnf h = localhost 1配置差异变量/etc/mysql/my.cnf gpmysql1 = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = innodb_temp_data_file_……5368709120 ibtmp1:12M: autoextend:马克斯:5 g grep innodb_temp_data_file_path /etc/mysql/my.cnf innodb_temp_data_file_path = ibtmp1:12M: autoextend:马克斯:5 g mysql - b - e”显示变量如“innodb_temp_data_file_path”;“Variable_name Value innodb_temp_data_file_path ibtmp1:12M:autoextend:max:5G
作为参考,再次修改参数配置文件时,没有重启服务器,pt-config-diff是预期的结果。它显示的值正确configfile和服务器:
pt-config-diff /etc/mysql/my.cnf h = localhost 1配置差异变量/etc/mysql/my.cnf gpmysql1 = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = innodb_temp_data_file_……ibtmp1:12M: autoextend ibtmp1:12M: autoextend:马克斯:5 g grep innodb_temp_data_file_path /etc/mysql/my.cnf innodb_temp_data_file_path = ibtmp1:12M: autoextend mysql - b - e”显示变量如“innodb_temp_data_file_path”;“Variable_name Value innodb_temp_data_file_path ibtmp1:12M:autoextend:max:5G
版本的pt-config-diff: pt-config-diff 3.0.12
版本的MySQL服务器:服务器版本:5.7.23-23-log Percona服务器(GPL),发布“23”,修雷竞技下载官网订“500 fcf5”