SEO

#1 (**permalink**) 02-27-2008, 09:31 PM

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

#2 (**permalink**) 02-27-2008, 09:31 PM

http://dev.mysql.com/doc/refman/5.0/...ster-logs.html

DÆVID

> -----Original Message-----
> From: George Law [mailto:glaw@IONOSPHERE.net]
> 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/mysql?unsub=daevid@daevid.com
>
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode