26.02.2014 14:23, Jari Fredriksson kirjoitti:
> 26.02.2014 14:13, Richard Fox kirjoitti:
>> Hi Jari,
>>
>> On Wed, 26 Feb 2014, Jari Fredriksson wrote:
>>
>>> MySQL process keeps on running at 100% CPU and is processing
>>>
>>> SELECT Path.Path, Filename.Name, Temp.FileIndex, Temp.JobId, LStat, MD5
>> [snip]
>>> 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)
>> I have just overcome this problem it would seem. It was suggested that
>> this might be due to an index getting fouled. The solution for me was
>> to dump and reload the database(s). I didn't spend much time tinkering
>> with it so I dumped the whole server since I don't have any other
>> significant data. Perhaps you could just rebuild just the relevant
>> indexes or reload only the tables involved to save time.
>>
>> Thanks,
>> Rich.
>>
> Thanks. I will try that next. Sounds like it might be a good idea to
> switch to pgsql later...
>
>

dump/restore did not help. Doing an explain plan next to see what gives.


-- 
jarif.bit

signature.asc
Description: OpenPGP digital signature

------------------------------------------------------------------------------
Flow-based real-time traffic analytics software. Cisco certified tool.
Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
Customize your own dashboards, set traffic alerts and generate reports.
Network behavioral analysis & security monitoring. All-in-one tool.
http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users