MySQL Performance: MySQL => MySQL5 Repliction seconds slower

Members

Help

Home

Home » Performance » MySQL » MySQL5 Repliction seconds slower

Show: Today's Messages :: Show Polls :: Message Navigator

MySQL5 Repliction seconds slower [message #3303]

Tue, 15 July 2008 10:54

onno
Messages: 3
Registered: July 2008

Junior Member

Hi there,

I have two high end servers configured with MySQL5 and server A replicates to server B. Both servers are used for read-queries.

Now we discovered that most of the time the replication is around 2 á 4 secs behind the master. So when a query is insert on server A, it takes almost 4 secs to replicate to server B.

Is there any way to speed up the replication?!

Thanks~!
Onno.

Report message to a moderator

Re: MySQL5 Repliction seconds slower [message #3308 is a reply to message #3303 ]

Thu, 17 July 2008 04:14

mwallace
Messages: 14
Registered: April 2008
Location: CA

Junior Member

Are both servers configured identically? Same number of spindles, same amount of RAM, same CPUs, same, indeces, same (roughly) mysql config, etc, and no non-mysql workload on the mirror?

Is the mirror handling more reads than the master?

Report message to a moderator

Re: MySQL5 Repliction seconds slower [message #3309 is a reply to message #3303 ]

Thu, 17 July 2008 04:29

onno
Messages: 3
Registered: July 2008

Junior Member

Dear MWallace,

Both servers are completely identical. There is no non-mysql workload on the mirror and the configs are the same.

As attachement I added the 'show status' from both hosts.

Thanks!

Attachment: dbStats.txt
(Size: 23.95KB, Downloaded 45 time(s))

Report message to a moderator

Re: MySQL5 Repliction seconds slower [message #3312 is a reply to message #3309 ]

Thu, 17 July 2008 11:05

mwallace
Messages: 14
Registered: April 2008
Location: CA

Junior Member

Hm. Could you please also send the results of:
show slave status\G
show variables;
iostat 5 (for maybe 5 iterations)
free
ps -ef

for each server?

Report message to a moderator

Re: MySQL5 Repliction seconds slower [message #3336 is a reply to message #3303 ]

Wed, 23 July 2008 04:51

onno
Messages: 3
Registered: July 2008

Junior Member

Dear mwallace,

Sorry for the late reaction, but I attached the two stats of both servers. I kinda isolated the problem. It seems to be cause by the reads on the second server. I think it has something to do with locking. Because when we redirect all queries to db01, replication is better.

Thanks for your time again.
Onno.

Attachment: dbServerStats.txt
(Size: 42.17KB, Downloaded 37 time(s))

Report message to a moderator

Previous Topic:	COUNT, SUM, ORDER and 2xJOINS
Next Topic:	strange performance times

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 5 11:18:29 EST 2008

Total time taken to generate the page: 0.01376 seconds

.:: Contact :: Home :: MySQL Support by Percona.com ::.