The problem of MySQL Replication unable to catch up is quite common in MySQL, First fact you absolutely need to remember is MySQL Replication is single threaded, which means if you have any long running write query it clogs replication stream and small and fast updates which go after it in MySQL binary log can’t proceed
Lets see why replication is slow, have you got slow query enabled? if not try this
SET GLOBAL slow_query_log=1;
SET GLOBAL long_query_time=1;
STOP SLAVE;
START SLAVE;
Wait for 30-60 mins
And provide us output of the following:
1) mysqldumpslow -s t -t 10 /path/to/slow_query_log
2) error log
Edited 1 time(s). Last edit at 07/13/2012 02:15AM by Aftab Khan.