From: Daevid Vincent
Date: October 10 2006 7:31pm
Subject: RE: purging bin logs
List-Archive: http://lists.mysql.com/mysql/202512
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html

D=C6VID =20

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