Hi , The slave lag for a few seconds is common. It might be heavy writes on master delaying the replication. As replication in MySQL is single threaded it can happen ( Hope you are not using Multi threaded replication in MySQL 5.6 ).
What is the binglog format ? Is the queries are tuned along with MySQL settings ? Any notable queries in slow query log ? Regards, KarthiK.P.R MySQL DBA On Wed, Mar 25, 2015 at 5:10 PM, Arun Khan <[email protected]> wrote: > On Wed, Mar 25, 2015 at 4:46 PM, Ajeesh Kannan <[email protected]> > wrote: > > Hi, > > > > I am using the slave connection using the internal LAN IP. Number of cpu > > cores in slave is higher than master server. > > List guidelines -- do *not* top post. > > Look at number of transactions pending replication @ primary and > compare those number at the replica. > > -- Arun Khan > _______________________________________________ > ILUGC Mailing List: > http://www.ae.iitm.ac.in/mailman/listinfo/ilugc > ILUGC Mailing List Guidelines: > http://ilugc.in/mailinglist-guidelines > _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc ILUGC Mailing List Guidelines: http://ilugc.in/mailinglist-guidelines
