内容发布更新时间 : 2024/11/1 8:04:53星期一 下面是文章的全部内容请认真阅读。

MySQL Server 5.6故障处理2例 2014年11月4日，117.79.133.132服务器上mysql-server从5.1升级到5.6后出现故障 ############################################################################### ? 事故信息

MySQL无法启动； MySQL日志中有一段： 2014-11-0410:14:02 18736 [ERROR] /usr/sbin/mysqld: 'default-character-set=utf8'

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

unknown variable

? 处理办法

修正my.cnf中的default-character-set=utf8为character_set_server=utf8； 原因新版本有修改

############################################################################### ? 事故信息：

启动MySQL有大量错误信息；

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

2014-11-04 10:30:05 7f90329fb700 InnoDB: Error: Fetch of persistent statistics requested for table \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 \2014-11-04 10:30:05 7f90329fb700 InnoDB: Error: Fetch of persistent statistics requested for table \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 \2014-11-04 10:30:05 7f90329fb700 InnoDB: Error: Fetch of persistent statistics requested for table \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 \2014-11-04 10:30:11 7f90297fb700 InnoDB: Recalculation of persistent statistics requested for table \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 \2014-11-04 10:32:06 7f90297fb700 InnoDB: Recalculation of persistent statistics requested for table \but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.

处理办法： 重新构建mysql库结构；

由于是yum安装，rpm查询sql语句文件路径

[root@oms~]#rpm–qlmysql-community-server-5.6.21-2.el6.x86_64|grepmysql_system_tables_data.sql

/usr/share/mysql/mysql_system_tables_data.sql [root@oms~]# rpm -ql mysql-community-server-5.6.21-2.el6.x86_64 |grepmysql_system_tables.sql

/usr/share/mysql/mysql_system_tables.sql

依次在mysql库中导入两个sql语句文件即可！