本篇内容主要讲解"怎么解决关系型数据库的报错[错误]本机表" 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’问题”有了更深的理解,那么我们来做点什么吧!这是网站。更多相关内容,可以去相关渠道查询,关注我们,继续学习!
内容来源网络,如有侵权,联系删除,本文地址:https://www.230890.com/zhan/104205.html