错误日志，复制自动退出

shmiya

090608 14:59:23 [Note] Slave I/O thread killed while reading event
090608 14:59:23 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000089', position 9984160
090608 14:59:23 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.000089' at position 9569256
090608 15:34:45 [Note] Slave I/O thread: connected to master 'replication@192.168.2.42:3306',replication started in log 'mysql-bin.000089' at position 9984160
090608 15:34:45 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000089' at position 9569256, relay log './LNGHKGSQLP02-relay-bin.000523' position: 1782669
090608 15:52:21 [Note] Slave I/O thread killed while reading event
090608 15:52:21 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000089', position 15203255
090608 15:52:21 [Note] Error reading relay log event: slave SQL thread was killed

cenalulu

show slave status \G
先看看last error是什么，看看表是不是你刚才出错的那个表。
没有的话用mysqlbinlog，看看那条出错的语句是什么。

估计是你之前的optimize操作锁表导致数据的错误。