[root@apmdb01 ~]# mysql -V
mysql Ver 14.14 Distrib 5.7.22, for Linux (x86_64) using EditLine wrapper
[root@apmdb02 ~]# mysql -V
mysql Ver 14.14 Distrib 5.7.23, for Linux (x86_64) using EditLine wrapper
从ampdb01全库导出数据导入到ampdb02,两个库做主从同步,导入完毕日志持续提示如下报错
2018-08-30T03:00:06.383814Z 5 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2018-08-30T03:00:06.391642Z 5 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2018-08-30T03:00:06.391666Z 5 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
解决办法:
执行 mysql_upgrade -u root -p –force
升级完毕后报错消失。