Hi I have two questions about replication on MySQL. One: How far behind can a SLAVE get on reading the BIN log before not being able to catch up? My SLAVE was off for 4 days and it just seams as if it can not catch up.
Two: On SHOW SLAVE STATUS one of the fields in called Skip_conunter. Due to an error I ran SET SQL_SLAVE_SKIP_COUNTER=n. The number in the Skip_conunter is about the same number as I set skip to, but every time I do a SHOW SALVE STATUS it shows a different number. What dose Skip_counter mean and so why is the number changing. Thanks Simon --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php