|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: Purge master logs
From: gerald_clark (gerald_clark
suppliersystems.com)
Date: Fri Jul 02 2004 - 08:07:21 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
SHOW MASTER STATUS will show you where you currently are on the master.
You should connect to each slave, and do a SHOW SLAVE STATUS to find where
the slaves are, and delete the logs lower than the lowest one in use by
the slaves.
Luis Mediero wrote:
>Hi,
>
>
> I'm looking for an automatic method to purge the master logs. I know I can
>do it with "PURGE MASTER LOGS TO 'mysql-bin.010';", but I need know the last
>log file to automate it.
>
> Somebody know the way.
>
>
> TIA
> Luis Mediero
>
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]