Robinson, Eric wrote:
>>> When I execute SHOW TABLE STATUS on my master replication server, it
>>> shows an Update_Time for some tables that is more than 2 hours earlier
>>> than the Update_Time for the same tables on the slave server. However
>>> the bin log names, positions, and number or records are correct.
>>>
>>> What's with that?
>> Let us know if your timezones are set correctly.
> The time zones are correct. Besides, the difference is not an even hour,
> and it varies. Sometimes the master server shows an update_time that is
> only a few minutes different, other times it is 510 seconds or 633
> seconds or 6056 seconds different. Eventually it catches up, but it
> sometimes takes an hour or two. Other times it catches up immediately
> after an update. I cannot discern a pattern. The only thing I know is
> that update_time seems to match the .MYD file's timestamp in Windows.
>
http://bugs.mysql.com/bug.php?id=4164
--
___
|K | Ongame E-Solutions AB - www.ongame.com
| /\| Mikael Fridh / Technical Operations
|_\/| tel: +46 18 606 538 / fax: +46 18 694 411
