怎么解决mysql的报错[ERROR] Native table 'performance_schema'问题

本篇内容主要讲解”怎么解决关系型数据库的报错[错误]本机表” performance_schema “问题”,感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习”怎么解决关系型数据库的报错[错误]本机表” performance_schema “问题”吧！

报错信息：

2016-02-15 10:12:24 9692[ERROR]原生表性能模式.”事件_阶段_当前”的结构错误

2016-02-15 10:12:24 9692[ERROR]原生表性能模式.”事件_阶段_历史”的结构错误

2016-02-15 10:12:24 9692[ERROR]原生表性能模式.”事件_阶段_历史_长”的结构错误

2016-02-15 10:12:24 9692[ERROR]原生表性能模式.” events _ stages _ summary _ by _ thread _ by _ event _ name “的结构错误

2016-02-15 10:12:24 9692[ERROR]原生表性能模式.” events _ stages _ summary _ by _ account _ by _ event _ name “的结构错误

2016-02-15 10:12:24 9692[ERROR]原生表性能模式.” events _ stages _ summary _ by _ user _ by _ event _ name “的结构错误

2016-02-15 10:12:24 9692[ERROR]原生表性能模式.” events _ stages _ summary _ by _ host _ by _ event _ name “的结构错误

2016-02-15 10:12:24 9692[ERROR]原生表性能模式.” events _ stages _ summary _ global _ by _ event _ name “的结构错误

2016-02-15 10:12:24 9692[ERROR]原生表性能模式.” events_statements_current “的结构错误

2016-02-15 10:12:24 9692[ERROR]原生表性能模式.”事件_语句_历史记录”的结构错误

2016-02-15 10:12:24 9692[ERROR]原生表性能模式.”事件_语句_历史_长”的结构错误

2016-02-15 10:12:24 9692[ERROR]原生表性能模式.” events _ statements _ summary _ by _ thread _ by _ event _ name “的结构错误

2016-02-15 10:12:24 9692[ERROR]原生表性能模式.” events _ statements _ summary _ by _ account _ by _ event _ name “的结构错误

2016-02-15 10:12:24 9692[ERROR]原生表性能模式.” events _ statements _ summary _ by _ user _ by _ event _ name “的结构错误

2016-02-15 10:12:24 9692[ERROR]原生表性能模式.” events _ statements _ summary _ by _ host _ by _ event _ name “的结构错误

2016-02-15 10:12:24 9692[ERROR]原生表性能模式.” events _ statements _ summary _ global _ by _ event _ name “的结构错误

2016-02-15 10:12:24 9692[ERROR]原生表性能模式.”事件_语句_摘要_ by _摘要”的结构错误

2016-02-15 10:12:24 9692[ERROR]原生表性能模式.用户的结构错误

2016-02-15 10:12:24 9692[ERROR]原生表性能模式.”帐户”的结构不正确

2016-02-15 10:12:24 9692[ERROR]原生表性能模式.“主机”的结构错误

2016-02-15 10:12:24 9692[ERROR]原生表性能模式.”套接字实例”的结构错误

2016-02-15 10:12:24 9692[ERROR]原生表性能模式.” socket_summary_by_instance “的结构错误

2016-02-15 10:12:24 9692[ERROR]原生表性能模式.” socket_summary_by_event_name “的结构错误

2016-02-15 10:12:24 9692[ERROR]原生表性能模式.session_connect_attrs ‘的结构不正确

2016-02-15 10:12:24 9692[ERROR]原生表性能模式.”会话_帐户_连接_属性”的结构错误

解决办法：

MySQL _ upgrade-h localhost-uroot-p

需要注意的是mysql_upgrade会调用mysqlcheck方法，期间会锁表对于大表可能执行的时间会很长。

至此，相信大家对“如何解决mysql的error [error]原生表‘performance _ schema’问题”有了更深的理解，那么我们来做点什么吧！这是网站。更多相关内容，可以去相关渠道查询，关注我们，继续学习！