Native table 'performance_schema'.'session_variables' has the wrong structure（某表结构错误）

最新推荐文章于 2024-03-22 17:00:03 发布
原创 最新推荐文章于 2024-03-22 17:00:03 发布 · 3.9k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#myeclipse

本文介绍了如何解决在MyEclipse中遇到的MySQL表'session_variables'结构错误的问题。通过在my.ini文件中添加特定指令并使用mysql_upgrade工具，最终成功解决了这一错误。

上一篇接：

Table 'performance_schema.session_variables' doesn't exist（某表不存在）的错误

第一：运行之前编写的myeclipse测试，发现第二个Native table 'performance_schema'.'session_variables' has the wrong structure（某表结构错误）的错误；


第二，在my.ini文件中再添加一句话# mysql_upgrade -u root -p --force，然后再运行myeclipse的测试，对！成功啦；



The MySQL 8.0.0 Milestone Release is available
帅的数说
09-20 2184
http://mysqlserverteam.com/the-mysql-8-0-0-milestone-release-is-available/ The MySQL Development team is happy to announce our 8.0.0 development milestone release (DMR), now available for downloa
‘performance_schema‘.‘session_variables‘ has the wrong structure
qq_46268601的博客
03-18 578
从mysql5.7.6开始information_schema.global_status已经开始被舍弃，为了兼容性，此时需要打开 show_compatibility_56。mysql 5.6升级到mysql5.7查看参数报错。
宝塔面板MySQL错误修复 has the wrong structure or is missing
tiger_web0的博客
03-22 520
MySQL未知原因造成停止服务，发现： [Warning] Optional native table ＇performance_schema＇.＇processlist＇ has the wrong structure or is missing
出现错误mysql Table ‘performance_schema…解决办法
12-16
测试环境搭了一个mariadb 5.7，使用jdbc驱动 <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.34</version> </dependency> 在hibernate工程中正常。 临时搭建了一个jdbc的简单工程，发现连接数据库报错： Table 'performance_schema.session_variables' doesn't exist 问度娘无果，无奈升级MySQL驱动为5.1.36，解决。 据了解：
Native table 'performance_schema'.'session_variables' has the wrong structure
LI_AINY的博客
03-09 2435
Native table 'performance_schema'.'session_variables' has the wrong structure cmd’进入mysqlmysql -u root -p 执行set @@global.show_compatibility_56=ON;
问题解答1：ERROR 1682 (HY000): Native table 'performance_schema'.'session_variables' has the wrong struct
尘埃落定
05-05 3314
数据库MySQL在MySQL5.7.6版本之后，导入的文件只能在secure_file_priv 指定的文件夹下。 执行 mysql> show variables like ‘%secure%’; ERROR 1682 (HY000): Native table ‘performance_schema’.‘session_variables’ has the wrong structu...
2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'users' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure 2025-06-05 23:33:06 27796 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
最新发布
06-07
当遇到 `MySQL performance_schema tables have the wrong structure` 错误时，通常表明当前数据库中的 `performance_schema` 表结构与所使用的 MySQL 版本不兼容。以下是详细的解决方案： #### 1. 确认 MySQL 版本...
2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'users' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure 2025-06-04 09:56:15 24636 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
06-05
### 解决 Performance Schema 表结构错误问题 Performance Schema 的表结构错误通常是由数据库版本升级或配置不一致引起的。以下是一些可能的解决方案和相关建议： 1. **检查 MySQL 版本与性能架构兼容性** 确保...
mysql 从库升主库_mysql_upgrade升级(主从模式,先升级从库)
weixin_39859394的博客
01-19 986
我们这里的环境是主从环境,我们将从库先升级到新的版本,然后将从库升级为主库，再升级原来的主库，完成主从环境的升级.------------------------------------------从库mysql_upgrade升级---------------------------------------------------------------------------------mys...
mysqldump: Couldn‘t execute ‘SHOW VARIABLES LIKE ‘ndbinfo\_version‘‘: Native table ‘performance_sche
weixin_43557605的博客
07-15 717
mysql备份错误
出现错误mysql Table 'performance_schema...解决办法
09-09
主要介绍了解决出现错误mysql Table 'performance_schema.session_variables' doesn't exist的相关资料,需要的朋友可以参考下
【MySQL】116.Native table ‘performance_schema‘.‘session_variables‘ has the wrong structure
weixin_43346403的博客
02-02 741
1.无法查看mysql变量。2.修改参数文件。
Mysql Native table 'performance_schema'.'session_variables' has the wrong structure
landylxy的博客
11-08 5446
命令行直接：set @@global.show_compatibility_56=ON;
mysql1682错误_ERROR 1682 (HY000): Native table 'performance_schema'.'session_variables' has the wrong ...
weixin_33327330的博客
01-19 904
出现的原因是我升级了mysql的版本.只要root用户执行以下语句即可.# mysql_upgrade -u root -p --force# systemctl restart mysqld 或 service mysql restart附上my.cnf配置文件[client]port= 3306socket= /var/run/mysqld/mysqld.sock[mysql]default-...
阿里云MySql数据库突然出现运行查询语句失败提示：Native table 'performance_schema'.'session_variables' has the wrong struct
Pillar的专栏
04-04 2309
1、问题描述： 阿里云数据库MySQL运行查询语句突然出现查询失败 2、错误日志： [Err] 1682 - Native table ‘performance_schema’.‘session_variables’ has the wrong structure 3、问题原因：MySQL过时，需要升级 4、解决办法： 只要root用户执行以下语句即可： # mysql_upgrade -...
MESSAGE: Native table 'performance_schema'.'session_variables' has the wrong structure
小小的木头人的博客
11-07 807
--从mysql5.7.6开始information_schema.global_status已经开始被舍弃，为了兼容性，此时需要打开 show_compatibility_56 2）character_set_database ，collation_database Value改为utf8，修改my.conf [client] default-character-set=utf8 ...
ERROR 1682 (HY000): Native table 'performance_schema'.'session_variables' has the wrong structure
一大三千的博客
02-10 9126
出现的原因是我升级了mysql的版本. 只要root用户执行以下语句即可. # mysql_upgrade -u root -p --force # systemctl restart mysqld 或 service mysql stop|service mysql start
ERROR 1682 (HY000): Native table ‘performance_schema‘.‘session_variables‘ has the wrong structure
m0_62128746的博客
05-12 645
原因是升级了mysql的版本，可以在cmd中使用。
[ERROR] Native table 'performance_schema'.'table name' has the wrong structure
cuiping7421的博客
02-15 1460
报错信息： 2016-02-15 10:12:24 9692[ERROR]Native table'performance_schema'.'events_stages_current'has the ...
navicat table performance_schema.session_variables
03-16
当使用 Navicat 连接到 MySQL 数据库时，如果遇到错误提示 “1146 - Table ‘performance_schema.session_variables’ doesn’t exist”，通常是因为该表不存在或未被正确初始化。此问题可能源于 MySQL 版本升级过程...
评论 2
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值