Hi Ajeesh,
MySQL 5.1 should be upgraded as there is no bug fixes on MySQL 5.1.
Consider moving to MySQL 5.5 or MySQL 5.6. It will be just an binary
upgrade in MySQL and the underlying data do not any change. Please let me
know if you need any help in mysql upgrade too.
Regards,
KarthiK.P.R
On Tu
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 wrote:
> Hi ,
>
> The slave lag for a few seconds is common. It might be heavy writes on
> master delaying the replicatio
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 wit
On Wed, Mar 25, 2015 at 4:46 PM, Ajeesh Kannan 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 t
Hi,
I am using the slave connection using the internal LAN IP. Number of cpu
cores in slave is higher than master server.
On Wed, Mar 25, 2015 at 11:15 AM, Arun Khan wrote:
> On Tue, Mar 24, 2015 at 5:42 PM, Ajeesh Kannan
> wrote:
> > Hi
> >
> > My mysql slave server is showing Second Behind M
On Tue, Mar 24, 2015 at 5:42 PM, Ajeesh Kannan wrote:
> Hi
>
> My mysql slave server is showing Second Behind Master values 30 to 100 . At
> this time there is no mysql backup is running. I would like to make my
> slave server should be up to date. But upon checking I can see that the
> Second Beh
