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.

-- 
  Rich Fox
  Systems Administrator
  JBPC - Marine Biological Laboratory
  http://www.mbl.edu/jbpc
  508-289-7669 - mbl-at-richfox.org

------------------------------------------------------------------------------
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