Bug #15914 | Slave I/O thread lags behind master | ||
---|---|---|---|
Submitted: | 21 Dec 2005 18:21 | Modified: | 23 Jan 2006 8:17 |
Reporter: | Partha Dutta | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: Replication | Severity: | S2 (Serious) |
Version: | 5.0.15 | OS: | Linux (Linux Gentoo 2.6.10) |
Assigned to: | CPU Architecture: | Any |
[21 Dec 2005 18:21]
Partha Dutta
[22 Dec 2005 0:25]
Partha Dutta
Here's some more info: When the slave i/o thread is idle (nothing being written to the master's binary log), then i/o thread goes to sleep and does not wake up. I am not sure of how long this inactivity time is. We have jobs that run at the top of the hour inserting hundreds of thousands of records. One workaround that I have come up with is to insert a record into a table every 5 minutes. This seems to keep the slave i/o thread awake.
[23 Dec 2005 8:17]
Valeriy Kravchuk
Thank you for a problem report. Please, send the my.cnf content from you master and slave. Check with SHOW PROCESSLIST and netstat that connection from slave to master exists when this will happen next time.
[24 Jan 2006 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".