Hi there, I've inadvertently filled up /var with 100GB of Opsview databases. It turns out leaving "purge small/large tables" at zero for more than a year is a bad thing!
The ibdata1 file is 70GB big, and I know I can't shrink that without a dump/restore, so I'll ignore that for now (the dump compressed down to 11GB, so I imagine it'll uncompress to a full disk again) and I can't delete any data because it says the filesystem is full. My thought is to drop the odw database (currently 35GB) and re-create it with /usr/local/nagios/bin/db_odw db_install Without any other amendments, is this likely to work? I'd set the upgrade.lock as per usual, to prevent imports. Any input welcome and appreciated - Opsview is currently working, but I don't want to leave it in the current situation! Matthew Walster _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
