[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Bacula-devel] small mysql patch


Yuri Timofeev wrote:
> 2008/9/5 Kern Sibbald <kern@xxxxxxxxxxx>:
> 
>>From what I understand, it *does* work, but just slowly. It is not correct to say that nothing is done.  It has been working and doing its job it may have even been removing orphaned records in this time.
> 
> No. This is not a work.
> 
> Mysql all the time (3 days) performs the same request:
> 
> SELECT File.FileId, Job.JobId FROM File LEFT OUTER JOIN Job ON
>        (File.JobId = Job.JobId) WHERE Job.JobId IS NULL LIMIT 300000;
> 
> Orphaned records are not deleted.
> There was a difference between 3 days and 3 minutes.
> 
> dbcheck does not solve the problem of disk space and you as a
> developer, it should be well known.

Correct.  dbcheck does not solve the disk space issue.

We would happily review a patch that does.


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-devel mailing list
Bacula-devel@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/bacula-devel


This mailing list archive is a service of Copilotco.