hello,
after copy jobs i see slow queries like:
# Query_time: 152 Lock_time: 0 Rows_sent: 0 Rows_examined: 16026
SELECT DISTINCT DelCandidates.JobId,DelCandidates.PurgedFiles FROM
Job,DelCandidates WHERE (Job.JobId=DelCandidates.JobId AND
DelCandidates.JobStatus NOT IN ('T','W')) OR (Job.JobTDate>1260691871
AND Job.ClientId=30 AND Job.Type='C');
i see this since i upgraded to git Branch-5.0 (5.0.2).
ClientId=30 is dummy client used only for copy jobs:
Client {
Name = None
Address = localhost
Password = "NoNe"
Catalog = MyCatalog
}
this client has only jobs of Type='c', and no real copy jobs of
Type='C'. the above select is always empty!
i have more then 100 daily copy jobs, for small incremental jobs
most of the time is spent in this needless select.
regards
ulrich
--
Ulrich Leodolter <[email protected]>
Oesterreichische Bibliothekenverbund und Service GmbH
Bruennlbadgasse 17/2A, A-1090 Wien
Fax +43 1 4035158-30
Tel +43 1 4035158-21
Web http://www.obvsg.at
------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit. See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Bacula-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-devel
