Re: [Bacula-users] purge jobs volume

[Arno L. <al...@it...>]

Hello,

On 05.10.2005 15:24, Sebastian Stark wrote:

> I want to manually recycle a volume and I did like the manual said:
> 
> ------------------------------------------------------
> *purge jobs volume=000129
> 
> This command is can be DANGEROUS!!!
> 
> It purges (deletes) all Files from a Job,
> JobId, Client or Volume; or it purges (deletes)
> all Jobs from a Client or Volume without regard
> for retention periods. Normally you should use the
> PRUNE command, which respects retention periods.
> ------------------------------------------------------
> 
> But this is already taking over half an hour and mysqld takes lots of CPU. Is 
> that normal? Is a "purge jobs volume=..." an expensive database operation? 
> Our catalog has 3 or 4 gigs.

Catalog size is one thing... equally important is the machine this runs 
on, if it's got other uses as well, and so on.

> Just wanted to ask if I should wait or look for any problems.

Just wait.
Purging etc. _can_ take quite a while, which is one reason why I prefer 
it done automatically - I just don't notice it usually, and there should 
never be a huge amount of data do delete. Searching for out-of-retention 
information still takes its time, of course.

Arno

> 
> -Sebastian
>                                  

-- 
IT-Service Lehmann                    al...@it...
Arno Lehmann                  http://www.its-lehmann.de