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/[EMAIL PROTECTED]

Reply via email to