rt,今天发现了这个现象,
Slave_IO_Running 为 No ,同步也停止了
但 Slave_SQL_Running 依然为Yes,
start slave 后同步继续正常工作。大家遇见过这种现象吗? 什么样的情况会导致这种现象的出现?
Slave_IO_Running 为 No ,同步也停止了
但 Slave_SQL_Running 依然为Yes,
start slave 后同步继续正常工作。大家遇见过这种现象吗? 什么样的情况会导致这种现象的出现?
100720 15:32:55 [ERROR] Log entry on master is longer than max_allowed_packet (1049369) on slave. If the entry is correct, restart the server with a higher value of max_allowed_packet
100720 15:32:55 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000028', position 766057638这个问题是 ?
均为 +--------------------+---------+
| Variable_name | Value |
+--------------------+---------+
| max_allowed_packet | 1048576 |
+--------------------+---------+