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.
glaw at ionosphere.net