本机表'performance_schema'.'???'结构错误 [英] Native table 'performance_schema'.'???' has the wrong structure

问题描述

我得到以下信息:

Native table 'performance_schema'.'file_instances' has the wrong structure
Native table 'performance_schema'.'cond_instances' has the wrong structure
Native table 'performance_schema'.'rwlock_instances' has the wrong structure
Native table 'performance_schema'.'mutex_instances' has the wrong structure
...

然后继续 当我重新启动MySql时会出现这些错误.似乎导致MySql Administrator变得不稳定，我得到了很多:

And on it goes These errors come up when I restart MySql. It seems to cause MySql Administrator to become unstable, I get a lot of:

"MySQL server has gone away"

推荐答案

显然，MySQL模式存储由于某种原因而损坏.这些原因可能是:

Apparently MySQL schema storage is broken due to a reason. These reasons may be:

• 您已损坏数据库information_schema
• 文件系统损坏或文件系统中的某些错误损坏了数据库.
• 由于MySQL中的一个bug(也许以前没有人遇到过)，MySQL内部人员破坏了模式数据库.

如果您没有备份，但是仍然可以访问数据，请先备份数据，然后执行以下操作:

If you don't have backups however you are still able to access your data, first backup your data then do the following:

如果您有备份，请重新安装MySQL(在此之前，请先彻底清除mysql的所有数据)，然后导入您的数据.

If you have backups, then reinstall MySQL (before that completely clear all data of mysql) and then import your data.

这篇关于本机表'performance_schema'.'???'结构错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！