Hi,
Scott Haneda wrote:
Running mysql 4, just poked into data and see I have gigs and gigs of
hostname-bin.xxx log files.
How does one maintain these, can someone point me to relevant data on what
to do about drive space being lost to these?
thanks
See attached message I just sent to another user a bit ago :-)
Baron
--- Begin Message ---
Hello,
Brown, Charles wrote:
Hello All. My bin.log directory is getting full with bin.log files. We
are running out of space. What can I do in the short term? Is there a
command that I can issue that will get rid of old bin log files not
needed?
In the short term, see the manual page for PURGE MASTER LOGS. In the
long term, write a cron job.
innotop (http://sourceforge.net/projects/innotop) also has a new
feature, unreleased because I just wrote it a few hours ago, which will
help you figure out which binlogs can be purged safely with a single
keystroke :-)
Baron
--- End Message ---
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]