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