Hi,
we have bacula 3.0.3 in production environment with catalog on mysql
5.1.40, engine innodb. During normal jobs bconsole is fast but during
copyjobs is very slow. We noticed that bconsole is waiting for this
query to complete:
SELECT DISTINCT DelCandidates.JobId,DelCandidates.PurgedFiles FROM
Job,DelCandidates WHERE (Job.JobId=DelCandidates.JobId AND
DelCandidates.JobStatus NOT IN ('T','W')) OR (Job.JobTDate>1262847609
AND Job.ClientId=26 AND Job.Type='C')
(ClientId 26 is the fake client for copyjobs named "None" in bacula-
dir.conf)
Do you have a suggestion or workaround for this issue?
Thank you.
Kindest regards.
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|