List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:October 10 2006 7:31pm
Subject:RE: purging bin logs
View as plain text  
http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html

DÆVID  

> -----Original Message-----
> From: George Law [mailto:glaw@stripped] 
> Sent: Tuesday, October 10, 2006 11:56 AM
> To: mysql@stripped
> Subject: purging bin logs
> 
> Hi All,
> 
> I have a question on purging some old bin-logs.
> 
> whats the best way to do it?  
> 
> This is a fairly old version - 4.0.18-standard-log.  I have 128 1 GB
> files out there, going back 8 months.  
> 
> I think the correct syntax is : 
>  PURGE BINARY LOGS TO 'mysql-bin.010'; 
> 
> but from what the previous admin who I inherited this from says, this
> locks up the whole database while its purging the logs.
> 
> Are there any low-impact solutions?
> 
> This is a fairly high traffic DB, so locking up the database really is
> not an option.
> 
> Thanks!
> 
> 
> George Law
> glaw at ionosphere.net
> 
>  
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    
> http://lists.mysql.com/mysql?unsub=1
> 
> 

Thread
purging bin logsGeorge Law10 Oct
  • RE: purging bin logsDaevid Vincent10 Oct