mysql主从隔一天同步一次_mysql主从同步，从库会隔几分钟或更长时间重启一次，直至停止...

error-log如下16121215:50:04mysqld_safeNumberofprocessesrunningnow:016121215:50:04mysqld_safemysqldrestarted16121215:50:05[Warning]'forreplicationstartupoptions'isdeprecat...

error-log如下

161212 15:50:04 mysqld_safe Number of processes running now: 0

161212 15:50:04 mysqld_safe mysqld restarted

161212 15:50:05 [Warning] 'for replication startup options' is deprecated and will be removed in a future release. Please use ''CHANGE MASTER'' instead.

161212 15:50:07 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000050' at position 32788587, relay log './mysql-relay-bin.000041' position: 3145994

161212 15:50:07 [Note] Slave I/O thread: connected to master 'zmtread@10.51.62.159:3306',replication started in log 'mysql-bin.000050' at position 33120121

161212 15:50:08 [Note] Event Scheduler: Loaded 0 events

161212 15:50:08 [Note] /www/wdlinux/mysql-5.1.69/libexec/mysqld: ready for connections.

Version: '5.1.69' socket: '/tmp/mysql.sock' port: 3306 Source distribution

161212 15:55:29 mysqld_safe Number of processes running now: 0

161212 15:55:29 mysqld_safe mysqld restarted

161212 15:55:30 [Warning] 'for replication startup options' is deprecated and will be removed in a future release. Please use ''CHANGE MASTER'' instead.

161212 15:55:30 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000050' at position 35336028, relay log './mysql-relay-bin.000043' position: 2216158

161212 15:55:30 [Note] Slave I/O thread: connected to master 'zmtread@10.51.62.159:3306',replication started in log 'mysql-bin.000050' at position 35529695

161212 15:55:30 [Note] Event Scheduler: Loaded 0 events

161212 15:55:30 [Note] /www/wdlinux/mysql-5.1.69/libexec/mysqld: ready for connections.

Version: '5.1.69' socket: '/tmp/mysql.sock' port: 3306 Source distribution

161212 16:02:20 mysqld_safe Number of processes running now: 0

161212 16:02:20 mysqld_safe mysqld restarted

161212 16:02:20 [Warning] 'for replication startup options' is deprecated and will be removed in a future release. Please use ''CHANGE MASTER'' instead.

161212 16:02:23 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.69/var/iZ254nqrxxhZ.pid ended

展开