> I wasn't aware that it was important to run dbcheck at certain intervals. So
> I sat it up about 8 hours ago. It showed 4919334 orphaned file records and
> it is now deleting them. How long time is it supposed to take? It has now
> been deleting for almost 8 hours and mysqld takes about 85% of the cpu. Is
> it looping or is it just what I should expect?
If you are using mysql or postgresql, you can try this (no backup must be run
during this operation, you can stop your director)
begin;
DELETE FROM Filename
WHERE NOT EXISTS
(SELECT 1 FROM File WHERE FilenameId=Filename.FilenameId)
DELETE FROM Path
WHERE NOT EXISTS
(SELECT 1 FROM File WHERE PathId=Path.PathId)
commit or rollback;
It's more efficient :) i think it will take 10 mins (with 100% cpu)...
Thanks to marc
Bye
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
