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 '
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
--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
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