你的位置:首页 > 服务器类

一、今天编译安装了MySQL5.6.31,安装启动之后错误日志报以下Warning信息:

160727 12:52:32 mysqld_safe Starting mysqld daemon with databases from /home/mysql/3307/data

2016-07-27 12:52:33 0 [Note] /usr/local/webserver/mysql56/bin/mysqld (mysqld 5.6.31-log) starting as process 26248 ...

2016-07-27 12:52:33 26248 [Note] InnoDB: Using atomics to ref count buffer pool pages

2016-07-27 12:52:33 26248 [Note] InnoDB: The InnoDB memory heap is disabled

2016-07-27 12:52:33 26248 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2016-07-27 12:52:33 26248 [Note] InnoDB: Memory barrier is not used

2016-07-27 12:52:33 26248 [Note] InnoDB: Compressed tables use zlib 1.2.3

2016-07-27 12:52:33 26248 [Note] InnoDB: Using CPU crc32 instructions

2016-07-27 12:52:33 26248 [Note] InnoDB: Initializing buffer pool, size = 512.0M

2016-07-27 12:52:33 26248 [Note] InnoDB: Completed initialization of buffer pool

2016-07-27 12:52:33 26248 [Note] InnoDB: Highest supported file format is Barracuda.

2016-07-27 12:52:33 26248 [Note] InnoDB: 128 rollback segment(s) are active.

2016-07-27 12:52:33 26248 [Note] InnoDB: Waiting for purge to start

2016-07-27 12:52:33 26248 [Note] InnoDB: 5.6.31 started; log sequence number 1601096

2016-07-27 12:52:33 26248 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3307

2016-07-27 12:52:33 26248 [Note]   - '0.0.0.0' resolves to '0.0.0.0';

2016-07-27 12:52:33 26248 [Note] Server socket created on IP: '0.0.0.0'.

2016-07-27 12:52:33 26248 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.

2016-07-27 12:52:33 26248 [Warning] 'user' entry '@localhost.localdomain' ignored in --skip-name-resolve mode.

2016-07-27 12:52:33 26248 [Warning] 'proxies_priv' entry '@ root@localhost.localdomain' ignored in --skip-name-resolve mode.

2016-07-27 12:52:33 26248 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for th

e table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.

2016-07-27 12:52:33 26248 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.

2016-07-27 12:52:33 26248 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for th

e table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.

2016-07-27 12:52:33 26248 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for

the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.

2016-07-27 12:52:33 26248 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.

2016-07-27 12:52:33 26248 [Note] Event Scheduler: Loaded 0 events

2016-07-27 12:52:33 26248 [Note] /usr/local/webserver/mysql56/bin/mysqld: ready for connections.

BUG产生具体原因不详,官方bugs.mysql.com上有提供修复这5张表的SQL文件,下载链接:http://bugs.mysql.com/file.php?id=19725

下面我们就按照文件的说明操作

  1. drop these tables from mysql:

     innodb_index_stats

     innodb_table_stats

     slave_master_info

     slave_relay_log_info

     slave_worker_info

  2. delete all .frm & .ibd of the tables above.

  3. run this file to recreate the tables above (source five-tables.sql).

  4. restart mysqld.

二、具体操作步骤

2.1、删除这5张表

drop table if exists innodb_index_stats;

drop table if exists innodb_table_stats;

drop table if exists slave_master_info;

drop table if exists slave_relay_log_info;

drop table if exists slave_worker_info;

2.2、删除这5张表对应的.frm和.ibd文件

rm -f /home/mysql/3307/data/mysql/*.ibd

2.3、导入下载的five-tables.sql文件

source /home/sql/five-tables.sql

2.4、导入完成之后,重新启动MYSQL服务

三、检验结果:

已经没有报错信息了。

  • 发表评论
  • 查看评论
【暂无评论!】

发表评论:

◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。