2009/12/13 Stu Teasdale <[email protected]>: > It should work fine. I had to do something very similar the other day > after a power failure wrecked the odw database on my test system (cheers > mysql).
To give an update, I noticed the script I mentioned automatically drops the DB, so I just ran the script. A minute later, I had 32GB free space. I'm now running /usr/local/nagios/bin/rc.opsview cron_daily which is now running the query "DELETE FROM nagios_servicechecks WHERE start_time <= '2009-12-06 21:30:40' " and I expect this to take a *very* long time ;) After that, I'll be doing a live dump of the whole MySQL system, deleting the ibdata/ib_logfile files and restarting MySQL - then re-importing the data. That should take down the 70GB ibdata1 file I have by a considerable degree! Not exactly the world's biggest MySQL fan at the moment - hardly set and forget! Matthew Walster _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
