Re: Purge master logs

[gerald_clark]

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
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]