Results 1 to 3 of 3
  1. #1

    Scheduling MySQL "reset master"

    I have to regularly run the "RESET MASTER" command in MySQL to clear up space on a server's hard drive partition, is there a way to have this command execute automatically so as to avoid having to manually log in to the shell and enter it all the time ? Can this be done via Crontab ?

    Thanks in advance.

  2. #2
    Just to add a closing comment to this following further research in to the issue, a better solution if you find that your drive space is being used up by binary log files is to disable the generation of these files unless you specifically need them for database replication.

    To do so, edit my.cnf and comment out the "log-bin" line.

    Hope this helps someone.

  3. #3
    Join Date
    May 2007
    Location
    Chicago
    Posts
    322
    Take a look at http://dev.mysql.com/doc/refman/5.0/...intenance.html which has several scripts for binary log rotation. You want to be careful about automatically calling RESET MASTER as you might lose records if the slave(s) is at all lagging the master.
    Panopta | Never Blinks
    Advanced Server Monitoring and Outage Management Solutions

    http://www.panopta.com | sales@panopta.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •