MySQL Server 5.6故障处理2例
MySQL Server 5.6故障处理2例2014年11月4日，117.79.133.132服务器上mysql-server从5.1升级到5.6后出现故障
###############################################################################
[*] 事故信息
MySQL无法启动；
MySQL日志中有一段：
2014-11-04 10:14:02 18736 /usr/sbin/mysqld: unknown variable 'default-character-set=utf8'
2014-11-04 10:14:02 18736 Aborting
[*] 处理办法
修正my.cnf中的default-character-set=utf8为character_set_server=utf8；
原因新版本有修改
###############################################################################
[*] 事故信息：
启动MySQL有大量错误信息；
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 are not present or have 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 are not present or have 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 are not present or have 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 is 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 is not present or is corrupted. Using transient stats instead.
处理办法：
重新构建mysql库结构；
由于是yum安装，rpm查询 sql语句文件路径
#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
# rpm -qlmysql-community-server-5.6.21-2.el6.x86_64 |grep mysql_system_tables.sql
/usr/share/mysql/mysql_system_tables.sql
依次在mysql库中导入两个sql语句文件即可！
页:
[1]