I suggest writing a very simple shell script to run "SHOW SLAVE STATUS" and output it to a file every 15 seconds, to verify your script is working. I have never seen MySQL give a bad lag time for replication -- it's always been accurate for lag time, or 0, or NULL.
As a bonus you could then use the data from the log files and positions to actually calculate how far behind it was, and file a bug report if indeed the server is wonky. -Sheeri On 5/19/06, Martijn van den Burg <[EMAIL PROTECTED]> wrote:
> That is weird. If it only lasts a couple of seconds, how are you > monitoring it to find out what the lag time is? I've written a replication monitor script using Perl::POE, which checks replication lag every 15 seconds or so (can't check the exact interval now - weekend has begun here). -- </Martijn>
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]