主:
110417 18:05:46 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:10:47 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:15:48 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:20:49 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:25:49 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:30:50 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:35:51 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:40:51 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:50:28 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197529)
110417 18:55:28 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197529)
从:
110417 18:05:46 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:05:46 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:10:47 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:10:47 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:15:48 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:15:48 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:20:49 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:20:49 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:25:49 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:25:49 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:30:50 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:30:50 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:35:51 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:35:51 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:40:51 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:40:51 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:50:28 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:50:28 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197529
110417 18:55:28 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:55:28 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197529
能看出是网络问题么?或者MySQL的配置不对?
110417 18:05:46 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:10:47 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:15:48 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:20:49 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:25:49 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:30:50 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:35:51 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:40:51 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:50:28 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197529)
110417 18:55:28 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197529)
从:
110417 18:05:46 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:05:46 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:10:47 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:10:47 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:15:48 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:15:48 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:20:49 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:20:49 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:25:49 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:25:49 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:30:50 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:30:50 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:35:51 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:35:51 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:40:51 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:40:51 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:50:28 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:50:28 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197529
110417 18:55:28 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:55:28 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197529
能看出是网络问题么?或者MySQL的配置不对?
解决方案 »
- 小弟 初到本版问个问题mysql配置中如何提高效率和稳定性
- mysql将B表数据插入A表 表结构相同 记录不重复
- c#插入数据到mysql数据库实现发送短信的功能,中文显示乱码,谢谢!
- sql 语名不能得能期望的结果,求解决方法
- 我用mysql高版本数据库备份文件*.sql无法导到低版本里~
- 关于MYSQL的事务处理,高手过来。
- 一个去除重复记录的问题
- 超奇怪,Mysql为何怎么也连不上???--------------从没遇到的问题!!!!!!
- 送分来了,LINUX下,怎么执行MYSQL,进入命令提示符理,我启动后,执行另外一个MYSQL脚本,说我权限拒绝,怎么办?
- navicat 创建mysql存储过程 中文参数报错
- WEB系统操作一段时间就连接不上,数据库mysql
- 执行SHOW BINLOG EVENTS后报错,请教
包或任何生成的/中间字符串的最大大小。
包消息缓冲区初始化为net_buffer_length字节,但需要时可以增长到max_allowed_packet字节。该值默认很小,以捕获大的(可能是错误的)数据包。
如果你使用大的BLOB 列或长字符串,你必须增加该值。应同你想要使用的最大的BLOB一样大。max_allowed_packet的协议限制为1GB。
http://space.itpub.net/7607759/viewspace-683607
110417 18:50:28 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197529)
110417 18:55:28 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
只需要关注ERR的信息。NOTE的不是错误,是提示信息而已。
110424 21:17:08 [Note] Start binlog_dump to slave_server(121281), pos(mysql-bin.000027, 723776392)
110424 21:17:08 [Note] Stop asynchronous binlog_dump to slave (server_id: 121281)
110424 21:17:08 [Note] Start asynchronous binlog_dump to slave (server_id: 121281), pos(mysql-bin.000027, 723776392)
110424 21:17:08 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110424 21:17:08 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000027' at postion 544212893
110424 21:23:07 [Note] Start binlog_dump to slave_server(121281), pos(mysql-bin.000027, 723776844)
110424 21:23:07 [Note] Start asynchronous binlog_dump to slave (server_id: 121281), pos(mysql-bin.000027, 723776844)
110424 21:23:07 [Note] Stop asynchronous binlog_dump to slave (server_id: 121281)
110424 21:45:11 [Note] Start binlog_dump to slave_server(121281), pos(mysql-bin.000027, 728535286)
110424 21:45:11 [Note] Stop asynchronous binlog_dump to slave (server_id: 121281)
110424 21:45:11 [Note] Start asynchronous binlog_dump to slave (server_id: 121281), pos(mysql-bin.000027, 728535286)
110424 21:47:06 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110424 21:47:06 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000027' at postion 549293649
[Server2]
110424 21:17:07 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110424 21:17:07 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000027' at postion 723776392
110424 21:17:08 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000027, 544212893)
110424 21:17:08 [Note] Stop asynchronous binlog_dump to slave (server_id: 121291)
110424 21:17:08 [Note] Start asynchronous binlog_dump to slave (server_id: 121291), pos(mysql-bin.000027, 544212893)
110424 21:23:07 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110424 21:23:07 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000027' at postion 723776844
110424 21:45:11 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110424 21:45:11 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000027' at postion 728535286
110424 21:47:06 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000027, 549293649)
110424 21:47:06 [Note] Stop asynchronous binlog_dump to slave (server_id: 121291)
110424 21:47:06 [Note] Start asynchronous binlog_dump to slave (server_id: 121291), pos(mysql-bin.000027, 549293649)
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#110423 22:27:19 server id 1 end_log_pos 107 Start: binlog v 4, server v 5.5.11-log created 110423 22:27:19
# Warning: this binlog is either in use or was not closed properly.
BINLOG '
l5izTQ/L2QEAZwAAAGsAAAABAAQANS41LjExLWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAVAAEGggAAAAICAgCAA==
'/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;