mysql 近一分钟_mysql从数据库一分钟产生50个中继日志

本帖最后由 damoa 于 2010-05-04 18:33 编辑

小弟做了主从mysql备份。但发现从数据库一分钟内产生50个中继日志。重启数据库后又正常。。。错误日志没有任何提示。正常关闭正常启动。请问如何使mysql错误日志显示更多内容。以上我这个情况有人碰见吗？请问解决方法。

mysql手册是这样描述中继日志创建的

在下面的条件下创建新的中继日志：

·         每次I/O线程启动时创建一个新的中继日志。

·         当日志被刷新时；例如，用FLUSH LOGS或mysqladmin flush-logs。

·         当当前的中继日志文件变得太大时。“太大”含义的确定方法：

我看见中继日志大小在200k。我设置了max-relay-log-size=512M       relay-log-space-limit=1G

第二点日志被刷新。。应该怎么看一天给刷新的日志记录呢？

第一点每次I/0线程启动。。。是不是线程被多次重连呢？

从数据库和主数据库在不断产生日志的情况下是同步的。

不断产生中继日志的情况，在重启mysql主数据库后正常。

以下是mysql没重启主数据库的从数据库日志

100504 17:35:21 [Note] /opt/lampp/sbin/mysqld: ready for connections.

Version: '5.0.45'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution

100504 17:35:21 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000020' at position 98, relay log './localhost-relay-bin.186015' position: 4

100504 17:35:21 [Note] Slave I/O thread: connected to master 'slave@192.168.19.101:3306',  replication started in log 'mysql-bin.000020' at position 4

100504 17:35:26 [Note] /opt/lampp/sbin/mysqld: Normal shutdown

100504 17:35:26 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000020', position 4

100504 17:35:26 [Note] Error reading relay log event: slave SQL thread was killed

100504 17:35:26 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

从启主数据库后的从数据库日志

100504 18:07:54 [Note] /opt/lampp/sbin/mysqld: ready for connections.

Version: '5.0.45'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution

100504 18:07:54 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000020' at position 98, relay log './localhost-relay-bin.186531' position: 4

100504 18:07:54 [Note] Slave I/O thread: connected to master 'slave@192.168.19.101:3306',  replication started in log 'mysql-bin.000020' at position 4

100504 18:29:27 [Note] /opt/lampp/sbin/mysqld: Normal shutdown

100504 18:29:27 [Note] Slave I/O thread killed while reading event

100504 18:29:27 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000021', position 709927

100504 18:29:27 [Note] Error reading relay log event: slave SQL thread was killed

100504 18:29:27 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

作者: damoa

发布时间: 2010-05-04