On Sunday 10 February 2002 06:06 pm, Jeremy Zawodny wrote: > One question: > > ? Can you explain the relay log a bit. ?Does it shrink eventually? ?I > ? see it growing and growing, so I don't know if the space is > ? recycled, or if I need to do something to periodically flush the > ? executed queries from the log.
Relay log rotates once a written event pushes it over max_binlog_size in the I/O thread, and the SQL thread deletes a processed relay log when switching to the next one. So if it works without bugs, you can just leave it unattended and it should take care of itself. > > Okay, a second question: > > ? How can I control where the relay log goes? ?I always have my binlog > ? go to a special directory on a different disk from my active tables. > ? I'd like to do something similar for the relay log. relay-log=/path/to/relay-log similar to log-bin= Relay log in essence is just another binary log, and most of the code is reused from the log-bin. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA <___/ --------------------------------------------------------------------- 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
