Workaround table ' performance_schema.session_variables ' doesn ' t exist

Oracle is a registered trademark the Oracle Corporation and/or its
Affiliates. Names may trademarks of their respective
Owners.

Type ' help, ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

Mysql> Show variables like ' Performance_schema ';

ERROR 1146 (42S02): Table ' performance_schema.session_variables ' doesn ' t exist

Or
when running MySQL, prompt table ' performance_schema.session_variables ' doesn ' t exist

The error in the log file is as follows:

2017-04-27t08:58:04.195252z 0 [Warning] System table ' Time_zone_leap_second ' is expected to be transactional.
2017-04-27t08:58:04.195281z 0 [Warning] System table ' Time_zone_name ' is expected to be transactional.
2017-04-27t08:58:04.195289z 0 [Warning] System table ' Time_zone ' is expected to be transactional.
2017-04-27t08:58:04.195296z 0 [Warning] System table ' Time_zone_transition_type ' is expected to be transactional.
2017-04-27t08:58:04.195303z 0 [Warning] System table ' time_zone_transition ' is expected to be transactional.
2017-04-27t08:58:04.196269z 0 [Warning] System table ' servers ' is expected to be transactional.
2017-04-27t08:58:04.196770z 0 [ERROR] incorrect definition of table performance_schema.events_waits_current:expected Column ' Nesting_event_type ' at position to have type enum (' TRANSACTION ', ' STATEMENT ', ' STAGE ', ' Wait ', found type enum (' S Tatement ', ' STAGE ', ' wait '.
2017-04-27t08:58:04.196873z 0 [ERROR] incorrect definition of table performance_schema.events_waits_history:expected Column ' Nesting_event_type ' at position to have type enum (' TRANSACTION ', ' STATEMENT ', ' STAGE ', ' Wait ', found type enum (' S Tatement ', ' STAGE ', ' wait '.
2017-04-27t08:58:04.196968z 0 [ERROR] incorrect definition of table Performance_schema.events_waits_history_long: Expected column ' Nesting_event_type ' at position-have TYPE enum (' TRANSACTION ', ' STATEMENT ', ' STAGE ', ' Wait ', found Typ e enum (' STATEMENT ', ' STAGE ', ' wait ').
2017-04-27t08:58:04.197278z 0 [ERROR] incorrect definition of table Performance_schema.events_waits_summary_by_user_ by_event_name:expected column ' USER ' at position 0 to have type char (#), found type char (16).
2017-04-27t08:58:04.197369z 0 [ERROR] incorrect definition of table Performance_schema.events_waits_summary_by_ account_by_event_name:expected column ' USER ' at position 0 to have type char (#), found type char (16).
2017-04-27t08:58:04.198123z 0 [ERROR] Column count of Performance_schema.setup_actors is wrong. Expected 5, found 3. Created with the MySQL 50616, now running 50717. Please use the Mysql_upgrade to fix this error.
2017-04-27t08:58:04.198356z 0 [ERROR] incorrect definition of table performance_schema.setup_objects:expected column ' Object_type ' at position 0 to have type enum (' EVENT ', ' FUNCTION ', ' PROCEDURE ', ' table ', ' TRIGGER ', found TYPE enum (' table ').
2017-04-27t08:58:04.198868z 0 [ERROR] Column count of Performance_schema.table_lock_waits_summary_by_table is wrong. Expected, found 73. Created with the MySQL 50616, now running 50717. Please use the Mysql_upgrade to fix this error.
2017-04-27t08:58:04.198960z 0 [ERROR] Column count of Performance_schema.threads is wrong. expected, found 14. Created with the MySQL 50616, now running 50717. Please use the Mysql_upgrade to fix this error.
2017-04-27t08:58:04.199045z 0 [ERROR] Column count of Performance_schema.events_stages_current is wrong. expected, found 10. Created with the MySQL 50616, now running 50717. Please use the Mysql_upgrade to fix this error.
2017-04-27t08:58:04.199128z 0 [ERROR] Column count of Performance_schema.events_stages_history is wrong. expected, found 10. Created with the MySQL 50616, now running 50717. Please use the Mysql_upgrade to fix this error.
2017-04-27t08:58:04.199211z 0 [ERROR] Column count of Performance_schema.events_stages_history_long is wrong. expected, found 10. Created with the MySQL 50616, now running 50717. Please use the Mysql_upgrade to fix this error.
2017-04-27t08:58:04.199372z 0 [ERROR] incorrect definition of table Performance_schema.events_stages_summary_by_ account_by_event_name:expected column ' USER ' at position 0 to have type char (#), found type char (16).
2017-04-27t08:58:04.199461z 0 [ERROR] incorrect definition of table Performance_schema.events_stages_summary_by_user_ by_event_name:expected column ' USER ' at position 0 to have type char (#), found type char (16).
2017-04-27t08:58:04.199750z 0 [ERROR] Column count of Performance_schema.events_statements_current is wrong. expected, found 40. Created with the MySQL 50616, now running 50717. Please use the Mysql_upgrade to fix this error.
2017-04-27t08:58:04.199885z 0 [ERROR] Column count of Performance_schema.events_statements_history is wrong. expected, found 40. Created with the MySQL 50616, now running 50717. Please use the Mysql_upgrade to fix this error.
2017-04-27t08:58:04.200013z 0 [ERROR] Column count of Performance_schema.events_statements_history_long is wrong. expected, found 40. Created with the MySQL 50616, now running 50717. Please use the Mysql_upgrade to fix this error.
2017-04-27t08:58:04.200196z 0 [ERROR] incorrect definition of table Performance_schema.events_statements_summary_by_ account_by_event_name:expected column ' USER ' at position 0 to have type char (#), found type char (16).
2017-04-27t08:58:04.200296z 0 [ERROR] incorrect definition of table Performance_schema.events_statements_summary_by_ user_by_event_name:expected column ' USER ' at position 0 to have type char (#), found type char (16).
2017-04-27t08:58:04.200609z 0 [ERROR] Native table ' Performance_schema '. ' Events_statements_summary_by_program ' has the wrong structure
2017-04-27t08:58:04.200651z 0 [ERROR] Native table ' Performance_schema '. ' Events_transactions_current ' has the wrong structure
2017-04-27t08:58:04.200687z 0 [ERROR] Native table ' Performance_schema '. ' Events_transactions_history ' has the wrong structure
2017-04-27t08:58:04.200723z 0 [ERROR] Native table ' Performance_schema '. ' Events_transactions_history_long ' has the wrong structure
2017-04-27T08:58:04.200762Z 0 [ERROR] Native table ' Performance_schema '. ' Events_transactions_summary_by_thread_by_event_name ' has the wrong structure
2017-04-27t08:58:04.200800z 0 [ERROR] Native table ' Performance_schema '. ' Events_transactions_summary_by_account_by_event_name ' has the wrong structure
2017-04-27t08:58:04.200838z 0 [ERROR] Native table ' Performance_schema '. ' Events_transactions_summary_by_user_by_event_name ' has the wrong structure
2017-04-27t08:58:04.200883z 0 [ERROR] Native table ' Performance_schema '. ' Events_transactions_summary_by_host_by_event_name ' has the wrong structure
2017-04-27t08:58:04.200921z 0 [ERROR] Native table ' Performance_schema '. ' Events_transactions_summary_global_by_event_name ' has the wrong structure
2017-04-27t08:58:04.201002z 0 [ERROR] incorrect definition of table performance_schema.users:expected column ' USER ' at PO Sition 0 to have type char (), found type char (16).
2017-04-27t08:58:04.201083z 0 [ERROR] incorrect definition of table performance_schema.accounts:expected column ' USER ' T position 0 to have type char (a), found type char (16).
2017-04-27t08:58:04.201576z 0 [ERROR] Native table ' Performance_schema '. ' Memory_summary_global_by_event_name ' has the wrong structure
2017-04-27t08:58:04.201621z 0 [ERROR] Native table ' Performance_schema '. ' Memory_summary_by_account_by_event_name ' has the wrong structure
2017-04-27t08:58:04.201676z 0 [ERROR] Native table ' Performance_schema '. ' Memory_summary_by_host_by_event_name ' has the wrong structure
2017-04-27t08:58:04.201715z 0 [ERROR] Native table ' Performance_schema '. ' Memory_summary_by_thread_by_event_name ' has the wrong structure
2017-04-27t08:58:04.201755z 0 [ERROR] Native table ' Performance_schema '. ' Memory_summary_by_user_by_event_name ' has the wrong structure
2017-04-27t08:58:04.201791z 0 [ERROR] Native table ' Performance_schema '. ' Table_handles ' has the wrong structure
2017-04-27t08:58:04.201827z 0 [ERROR] Native table ' Performance_schema '. ' Metadata_locks ' has the wrong structure
2017-04-27t08:58:04.201864z 0 [ERROR] Native table ' Performance_schema '. ' Replication_connection_configuration ' has the wrong structure
2017-04-27t08:58:04.201898z 0 [ERROR] Native table ' Performance_schema '. ' Replication_group_members ' has the wrong structure
2017-04-27t08:58:04.201934z 0 [ERROR] Native table ' Performance_schema '. ' Replication_connection_status ' has the wrong structure
2017-04-27t08:58:04.201969z 0 [ERROR] Native table ' Performance_schema '. ' Replication_applier_configuration ' has the wrong structure
2017-04-27t08:58:04.202003z 0 [ERROR] Native table ' Performance_schema '. ' Replication_applier_status ' has the wrong structure
2017-04-27t08:58:04.202041z 0 [ERROR] Native table ' Performance_schema '. ' Replication_applier_status_by_coordinator ' has the wrong structure
2017-04-27t08:58:04.202077z 0 [ERROR] Native table ' Performance_schema '. ' Replication_applier_status_by_worker ' has the wrong structure
2017-04-27t08:58:04.202118z 0 [ERROR] Native table ' Performance_schema '. ' Replication_group_member_stats ' has the wrong structure
2017-04-27t08:58:04.202153z 0 [ERROR] Native table ' Performance_schema '. ' Prepared_statements_instances ' has the wrong structure
2017-04-27t08:58:04.202192z 0 [ERROR] Native table ' Performance_schema '. ' User_variables_by_thread ' has the wrong structure
2017-04-27t08:58:04.202227z 0 [ERROR] Native table ' Performance_schema '. ' Status_by_account ' has the wrong structure
2017-04-27t08:58:04.202260z 0 [ERROR] Native table ' Performance_schema '. ' Status_by_host ' has the wrong structure
2017-04-27t08:58:04.202294z 0 [ERROR] Native table ' Performance_schema '. ' Status_by_thread ' has the wrong structure
2017-04-27t08:58:04.202332z 0 [ERROR] Native table ' Performance_schema '. ' Status_by_user ' has the wrong structure
2017-04-27t08:58:04.202366z 0 [ERROR] Native table ' Performance_schema '. ' Global_status ' has the wrong structure
2017-04-27t08:58:04.202400z 0 [ERROR] Native table ' Performance_schema '. ' Session_status ' has the wrong structure
2017-04-27t08:58:04.202434z 0 [ERROR] Native table ' Performance_schema '. ' Variables_by_thread ' has the wrong structure
2017-04-27t08:58:04.202472z 0 [ERROR] Native table ' Performance_schema '. ' Global_variables ' has the wrong structure
2017-04-27t08:58:04.202520z 0 [ERROR] Native table ' Performance_schema '. ' Session_variables ' has the wrong structure
2017-04-27t08:58:04.202654z 0 [ERROR] incorrect definition of table mysql.db:expected column ' User ' at position 2 to have Type char, found type char (16).
2017-04-27t08:58:04.202686z 0 [ERROR] mysql.user has no ' event_priv ' column at position 28
2017-04-27t08:58:04.202896z 0 [ERROR] Event Scheduler:an ERROR occurred when initializing system tables. Disabling the Event Scheduler.
2017-04-27t08:58:04.202987z 0 [note] executing ' SELECT * from INFORMATION_SCHEMA. tables; ' To get a list of tables using the deprecated partition engine. Use the "startup option '--disable-partition-engine-check ' to skip this check.
2017-04-27t08:58:04.202999z 0 [note] Beginning of the list of non-natively partitioned tables
2017-04-27t08:58:04.219168z 0 [note] End of list of non-natively partitioned tables
2017-04-27t08:58:04.219316z 0 [note] mysqld:ready for connections.

The workaround is as follows:

1. View data status

Root@storm-master-01:/root#ps-ef|grep MySQL
Root 68391 67024 0 16:01 pts/4 00:00:00 mysql-h192.168.22.22-uloan-px xxxx-p3308
MySQL 72949 68459 17:55 pts/6 00:00:00/usr/local/mysql/bin/mysqld--defaults-file=/data/backup/backup-my.cnf
Root 72980 68459 0 17:55 pts/6 00:00:00 grep--color=auto MySQL

2, login database as follows

Root@storm-master-01:/data/backup#mysql_upgrade-h192.168.22.22-u root-p--force-p3308 sock=/data/backup/ Mysql3308.sock
Mysql_upgrade: [Warning] Using a password on the command line interface can insecure.
Checking Server version.
Running queries to upgrade MySQL server.
Checking system database.
Mysql.columns_priv OK
Mysql.db OK
Mysql.engine_cost OK
Mysql.event OK
Mysql.func OK
Mysql.general_log OK
Mysql.gtid_executed OK
Mysql.ha_health_check OK
Mysql.help_category OK
Mysql.help_keyword OK
Mysql.help_relation
Sys.sys_config OK
Upgrade process completed successfully.
Checking if update is needed.

3. Close the database

4, start the database
Root@storm-master-01:/data/backup#/usr/local/mysql/bin/mysqld--DEFAULTS-FILE=/DATA/BACKUP/BACKUP-MY.CNF &