25.03.2014 17:04, Kern Sibbald kirjoitti:
> Hello,
>
> Aside from tuning as recommended by Gary, did you add any new indexes
> recently? Often users a new indexes because they speed up some
> particular operation, but because of the complexities of SQL, those
> indexes can seriously slow down other queries such as batch insert
> which is what I imagine is taking the time in your case.
>
> Best regards,
> Kern
>
No, I did not add any indices but just recreated the database by using
script from 5.0.3. The software version in CentOS is 5.0.0. but I could
not find that from bacula.org repository.
>
> On 14-03-24 10:19 AM, Jari Fredriksson wrote:
>> 26.02.2014 12:00, Jari Fredriksson kirjoitti:
>>> MySQL process keeps on running at 100% CPU and is processing
>>>
>>> SELECT Path.Path, Filename.Name, Temp.FileIndex, Temp.JobId, LStat, MD5
>>> FROM ( SELECT FileId, Job.JobId AS JobId, FileIndex, File.PathId AS
>>> PathId, File.FilenameId AS FilenameId, LStat, MD5 FROM Job, File, (
>>> SELECT MAX(JobTDate) AS JobTDate, PathId, FilenameId FROM ( SELECT
>>> JobTDate, PathId, FilenameId FROM File JOIN Job USING (JobId) WHERE
>>> File.JobId IN (7088,7196,7204,7260) UNION ALL SELECT JobTDate, PathId,
>>> FilenameId FROM BaseFiles JOIN File USING (FileId) JOIN Job ON
>>> (BaseJobId = Job.JobId) WHERE BaseFiles.JobId IN (7088,7196,7204,7260) )
>>> AS tmp GROUP BY PathId, FilenameId ) AS T1 WHERE (Job.JobId IN ( SELECT
>>> DISTINCT BaseJobId FROM BaseFiles WHERE JobId IN (7088,7196,7204,7260))
>>> OR Job.JobId IN (7088,7196,7204,7260)) AND T1.JobTDate = Job.JobTDate
>>> AND Job.JobId = File.JobId AND T1.PathId = File.PathId AND T1.FilenameId
>>> = File.FilenameId ) AS Temp JOIN Filename ON (Filename.FilenameId =
>>> Temp.FilenameId) JOIN Path ON (Path.PathId = Temp.PathId) WHERE
>>> FileIndex > 0 ORDER BY Temp.JobId, FileIndex ASC
>>>
>>> My setup has worked flawlessly for years, and now suddenly this.
>>>
>>> This is on CentOS 6.5 with Version: 5.0.0 (26 January 2010)
>>>
>>> Any thoughts, what might cause this?
>>>
>>>
>> I dropped the database, recretead it again. The problems stays! I wonder
>> if 5.0.0. has some inherent problem into it, that is the version in
>> CentOS 6.5.
>>
>> Irritating.
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Learn Graph Databases - Download FREE O'Reilly Book
>> "Graph Databases" is the definitive new guide to graph databases and their
>> applications. Written by three acclaimed leaders in the field,
>> this first edition is now available. Download your free book today!
>> http://p.sf.net/sfu/13534_NeoTech
>>
>>
>> _______________________________________________
>> Bacula-users mailing list
>> Bacula-users AT lists.sourceforge DOT net
>> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
--
jarif.bit
signature.asc
Description: OpenPGP digital signature
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech _______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
