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]
