MySQL Forums
Forum List  »  Install & Repo

Re: [Replication] Seconds_Behind_Master increasing
Posted by: Keith Larson
Date: July 05, 2013 07:57PM

First thank you for providing so much information. It is very helpful and gets some questions out of the way that way.

But I do still have one....

What does your error log say on the slave ? Are you getting anything?

What is they query that it is trying to replicate ? Is it stuck on one or you do see it processing just very slowly. Did someone toss some long running queries into your master and it taking twice as long on the slave since it is not multithreaded ?

Can you check the binlog on the master at the id of the current slave so you can see what query it is hanging on?

Just trying to help....

http://anothermysqldba.blogspot.com

Options: ReplyQuote


Subject
Written By
Posted
Re: [Replication] Seconds_Behind_Master increasing
July 05, 2013 07:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.