http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html
DÆVID > -----Original Message----- > From: George Law [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 10, 2006 11:56 AM > To: mysql@lists.mysql.com > 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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
