2 cases of MySQL Server 5.6 Fault Handling

2 cases of MySQL Server 5.6 Fault Handling

November 4, 2014, Mysql-server failed after upgrading from 5.1 to 5.6 on 117.79.133.132 server

###############################################################################

• Accident information

  MySQL cannot start;

  There is a section in the MySQL log:

  2014-11-04 10:14:02 18736 [ERROR]/usr/sbin/mysqld:unknown variable ' Default-character-set=utf8 '

  2014-11-04 10:14:02 18736 [ERROR] Aborting

• Treatment methods

  Fixed the Default-character-set=utf8 in my.cnf as Character_set_server=utf8;

  Cause the new version has been modified

###############################################################################

• Accident information:

  Startup MySQL has a lot of error messages;

2014-11-04 10:30:05 7f90329fb700 InnoDB:Error:Table "MySQL". Innodb_table_stats "not found.

2014-11-04 10:30:05 7f90329fb700 InnoDB:Error:Fetch of persistent statistics requested for table "Zabbix". " Group_prototype "But the required system tables Mysql.innodb_table_stats and Mysql.innodb_index_stats is not present or H Ave unexpected structure. Using transient stats instead.

2014-11-04 10:30:05 7f90329fb700 InnoDB:Error:Table "MySQL". Innodb_table_stats "not found.

2014-11-04 10:30:05 7f90329fb700 InnoDB:Error:Fetch of persistent statistics requested for table "Zabbix". " Group_discovery "But the required system tables Mysql.innodb_table_stats and Mysql.innodb_index_stats is not present or H Ave unexpected structure. Using transient stats instead.

2014-11-04 10:30:05 7f90329fb700 InnoDB:Error:Table "MySQL". Innodb_table_stats "not found.

2014-11-04 10:30:05 7f90329fb700 InnoDB:Error:Fetch of persistent statistics requested for table "Zabbix". " Interface_discovery "But the required system tables Mysql.innodb_table_stats and Mysql.innodb_index_stats is not present or has unexpected structure. Using transient stats instead.

2014-11-04 10:30:11 7f90297fb700 InnoDB:Error:Table "MySQL". Innodb_table_stats "not found.

2014-11-04 10:30:11 7f90297fb700 Innodb:recalculation of persistent statistics requested for table "Zabbix". " Escalations "But the required persistent statistics storage are not present or is corrupted. Using transient stats instead.

2014-11-04 10:32:06 7f90297fb700 InnoDB:Error:Table "MySQL". Innodb_table_stats "not found.

2014-11-04 10:32:06 7f90297fb700 Innodb:recalculation of persistent statistics requested for table "Zabbix". " Escalations "But the required persistent statistics storage are not present or is corrupted. Using transient stats instead.

Treatment methods:

reconstruct MySQL library structure;

Because it is a Yum installation, RPM queries the SQL statement file path

[Email protected]~] #rpm QL mysql-community-server-5.6.21-2.el6.x86_64|grep mysql_system_tables_data.sql

/usr/share/mysql/mysql_system_tables_data.sql

[Email protected]~]# rpm-ql mysql-community-server-5.6.21-2.el6.x86_64 |grep mysql_system_tables.sql

/usr/share/mysql/mysql_system_tables.sql

Import two SQL statement files in the MySQL library in turn!

2 cases of MySQL Server 5.6 Fault Handling