Re: Seconds Behind the master 0 but in reality it's over 10 minutes or hours..

[Adam PAPAI]

Adam PAPAI wrote:
> Dear List,
>
> I have a Master -> [ Slave 1, Slave 2 ] setup for years.


I have the db under /var/db/mysql

it shows:

-rw-rw----   1 mysql  mysql  149765008 Sep  4 18:37 
tungsten-relay-bin.000214
-rw-rw----   1 mysql  mysql         67 Sep  4 18:38 relay-log.info
-rw-rw----   1 mysql  mysql         73 Sep  4 18:38 master.info

but the date is:

[root@tungsten /var/db/mysql]# date
Sun Sep  4 19:11:13 CEST 2011



And it's delayed 1 hour. No data is transferred to the slave. It says: 
Secords behind master 0.

What the hell is going on here?

-- 
Adam PAPAI
Grapes Communication Kft.
http://www.grapes.hu
E-mail: papai.adam@stripped
Phone: [phone] (Hungary)