On Wed, 25 Jan 2006 - 12:19pm, Florian Schnabel wrote: > Juliet Kemp wrote: >> Hi, >> >> How long is it normal for pruning/purging a volume to take? I have found >> that it takes several hours, even if only purging 2 or 3 jobs (& incremental >> jobs, rather than full ones) - this obviously can delay backups quite >> significantly. >> >> Does the purge/prune actually require interaction with the tape? Or just the >> database? >> >> I'm running 1.36.3, on Linux, & using MySQL as the backend. It's quite an >> old machine, as well. My backup is to LTO-3 tapes in an autochanger (backing >> up etc works fine). >> >> >> Thanks for any help/comments! >> >> >> Juliet Kemp > > pruning shouldn't take hours ... > i can get 6 jobs pruned in about 5-10 minutes ... > i suggest checking your database layout, there were ppl on the mailing list > that were missing indices in the database, that would explain why it takes so > long for you.
I suggest getting a faster box, cause prune/pruge is all about SQL Statements. DELETE FROM File where JobId='1234'; That took hours on our old box as well, now we switched to a 3.xGHz Xeon and it runs pretty nice. Greetings, Michael -- I love deadlines, especially the sound they make as they go whooshing by. ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
