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