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]

Reply via email to