Hi Karthik, Thank you for your update.
My mysql server is running with old version 5.1 and it is hard to upgrade at the moment. On Mon, Mar 30, 2015 at 5:48 PM, P.R.Karthik <prk...@gmail.com> wrote: > 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 <knu...@gmail.com> wrote: > > > On Wed, Mar 25, 2015 at 4:46 PM, Ajeesh Kannan <ajeeshbkan...@gmail.com> > > 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 > -- With Regards, Ajeesh B.Kannan _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc ILUGC Mailing List Guidelines: http://ilugc.in/mailinglist-guidelines
