Re: Slave behind master... or not ?

2006-09-05 Thread Atle Veka
Jocelyn, without more information about how many queries your system has, it's impossible to say. I do not know how MySQL calculates the 'Seconds_Behind_Master' data, but: If your system has bursts of queries, why is the data represented below confusing? What if inbetween your 1st and 2nd '

Re: Slave behind master... or not ?

2006-09-05 Thread Jocelyn Fournier
Hi, Thanks for the answer. I don't think this is what's happening because I can also see within a few seconds : 0 48 0 48 0 for example. Thanks, Jocelyn Michael Loftis a écrit : --On September 5, 2006 3:18:21 PM +0200 Jocelyn Fournier <[EMAIL PROTECTED]> wrote: Hi, Any idea of

Re: Slave behind master... or not ?

2006-09-05 Thread Michael Loftis
--On September 5, 2006 3:18:21 PM +0200 Jocelyn Fournier <[EMAIL PROTECTED]> wrote: Hi, Any idea of what could be wrong here ? My guess is that the variable is based on the last update timestamp, and the last time that the slave has seen data from the master. If it had been about a

Slave behind master... or not ?

2006-09-05 Thread Jocelyn Fournier
Hi, I encounter a really strange behaviour with some of my slaves servers : I'm using MySQL 4.1.20 x86_64 on both master and slave servers. If I issue three times the command SHOW SLAVE STATUS several times in a few seconds, I could obtain the following results for the Seconds_Behind_Master co