campbell palmer wrote:
> Hi,
> I'm having a problem where if my slave server
> crashes it takes days for it to catch up to the
> master server. I populate close to 1 gig per day
> on the master server, and if the slave ever breaks
> it takes nearly 1 day to catch up for every day it
> has missed. This prevents our slave from being
> functional for extended periods of time. Are
> there tweaks I'm missing that can greatly increase
> the slave server? Both servers are gigabit
> ethernet connected and both servers are using raid
> 5 version of veritas. The slave server has quad
> 800 Mhz cpus as well. I cannot figure out how to
> improve performance.
>
> Master server is Mysql 4.0.12
> Slave server is Mysql 4.1.14
>
> Thanks!
>
>
>
> Edited 1 times. Last edit at 09/20/05 04:42PM by
> campbell palmer.
Not too sure if there are any more tunables that can be helpful. Remember that the slave server is single threaded, so there is only one thread applying SQL statements from the relay log. You may have to beef up the slave server.
Partha Dutta
Senior Consultant, MySQL Inc.
http://www.mysql.com