On Friday 19 May 2006 17:49, sheeri kritzer wrote:
> 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.

That's a good idea. I'll try it on monday.

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

Thanks for the suggestion.

Have a nice weekend,

-- 
</Martijn>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to