ERROR 1682 (HY000): 'performance_schema'.'session_variables' 错误
解决方法:
第一步 Mysql升级:
#mysql_upgrade -u root -p --force
第二步 重启Mysql服务:
#systemctl restart mysqld.service
第三步 测试Storageworks状态:
#show variables like "%stor%";
mysql> show variables like "%stor%";
+----------------------------------------------------------+--------+
| Variable_name | Value|
+----------------------------------------------------------+--------+
| default_storage_engine | InnoDB |
| default_tmp_storage_engine | InnoDB |
| disabled_storage_engines | |
| internal_tmp_disk_storage_engine | InnoDB |
| performance_schema_events_stages_history_long_size | 10000|
| performance_schema_events_stages_history_size | 10 |
| performance_schema_events_statements_history_long_size | 10000|
| performance_schema_events_statements_history_size | 10 |
| performance_schema_events_transactions_history_long_size | 10000|
| performance_schema_events_transactions_history_size | 10 |
| performance_schema_events_waits_history_long_size | 10000|
| performance_schema_events_waits_history_size | 10 |
| profiling_history_size | 15 |
| stored_program_cache | 256 |
+----------------------------------------------------------+--------+
14 rows in set (0.00 sec)
mysql> show variables like "have%";
+------------------------+----------+
| Variable_name | Value |
+------------------------+----------+
| have_compress | YES |
| have_crypt | YES |
| have_dynamic_loading | YES |
| have_geometry | YES |
| have_openssl | DISABLED |
| have_profiling | YES |
| have_query_cache | YES |
| have_rtree_keys | YES |
| have_ssl | DISABLED |
| have_statement_timeout | YES |
| have_symlink | DISABLED |
+------------------------+----------+
11 rows in set (0.01 sec)
页:
[1]