线上mysql服务器日志出现异常,错误如下:
[root@localhost ~]# tailf /mydata/mydata/localhost.localdomain.err
InnoDB: in effect disabling the AUTOINC next value generation.InnoDB: You can either set the next AUTOINC value explicitly using ALTER TABLE
InnoDB: or fix the data dictionary by recreating the table.
2015-03-20 17:30:02 7f9ef3559700 InnoDB: AUTOINC next value generation is disabled for 'db_name/table_name'
2015-03-20 17:31:00 7f9ef1af1700 InnoDB: MySQL and InnoDB data dictionaries are out of sync.
InnoDB: Unable to find the AUTOINC column id in the InnoDB table db_name/table_name.
InnoDB: We set the next AUTOINC column value to 0,
InnoDB: in effect disabling the AUTOINC next value generation.
InnoDB: You can either set the next AUTOINC value explicitly using ALTER TABLE
InnoDB: or fix the data dictionary by recreating the table.
发现db_name/table_name表的自增列数值应为36 ,结果却是0,数据量6条,重建表解决。
另外发现该mysql服务器的binlog日志刷新频繁,没到最大日志量,也没flush log,如图:
什么原因导致的呢,是不是和上面自增列问题有关,自增问题已经解决,进一步观察。
看还经常刷新日志不