服务器异常关机后重启mysql出现如下错误:
131016 9:21:09 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
131016 9:21:09 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
131016 9:21:09 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
131016 9:21:09 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
131016 9:21:09 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
131016 9:21:09 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
解决方法如下:
/usr/local/mysql/bin/mysql_upgrade
阅读(2213) | 评论(0) | 转发(0) |