I expect using the Master_log_File should be fine since the slave caches the sqls in its own Relay_Log_File using the IO Thread.
Arvind Gangal internet: http://www.lastminute.com do something lastminute.com -----Original Message----- From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] Sent: 21 October 2004 21:00 To: 'Marvin Wright'; [EMAIL PROTECTED] Subject: RE: Replication / Purge Logs No look at Relay_Master_Log_File and Exec_master_log_pos for the position of that master log file. The Master_Log_File indicates what position the IO thread is on. DVP ---- Dathan Vance Pattishall http://www.friendster.com > -----Original Message----- > From: Marvin Wright [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 21, 2004 4:01 AM > To: [EMAIL PROTECTED] > Subject: Replication / Purge Logs > > Hi, > > Just wanted to check something from the documentation. > The recommended procedure for removing the bin logs on the master is > > On each slave server, use SHOW SLAVE STATUS to check which log it is > reading. > Obtain a listing of the logs on the master server with SHOW MASTER LOGS. > Determine the earliest log among all the slaves. This is the target log. > If > all the slaves are up to date, this will be the last log on the list. > Make a backup of all the logs you are about to delete. (The step is > optional, but a good idea.) Purge all logs up to but not including the > target log. > > When I do a show slave status, I should be looking at the > Master_Log_File field ? > > Thanks. > > Marvin Wright > Flights Developer > Lastminute.com > [EMAIL PROTECTED] > +44 (0) 207 802 4543 > > > > ********************************************************************** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > the system manager. > > This footnote also confirms that this email message has been swept by > MIMEsweeper for the presence of computer viruses. > > www.mimesweeper.com > ********************************************************************** > > > ______________________________________________________________________ > __ This e-mail has been scanned for all viruses by Star. The service > is powered by MessageLabs. For more information on a proactive > anti-virus service working around the clock, around the globe, visit: > http://www.star.net.uk > ______________________________________________________________________ > __ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
