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 'SHOW SLAVE STATUS'
query a large amount of replicated queries were processed causing the
slave to temporarily lag behind.
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Tue, 5 Sep 2006, Jocelyn Fournier wrote:
> 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 column :
>
> 0
> 48
> 0
>
> I don't understand how it's possible within 1 or 2 seconds to switch
> from 0 second behind master to 48 seconds behind master and then back
> again to 0 second behind master.
>
> Any idea of what could be wrong here ?
>
> Thanks,
> Jocelyn
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
