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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
