Re: [Bacula-users] MySQL "hangs", jobs hang. Well not really, but
2014-02-26 07:25:14
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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
Previous by Date: |
Re: [Bacula-users] MySQL "hangs", jobs hang. Well not really, but, Richard Fox |
Next by Date: |
[Bacula-users] Configure separate centos server as storage device, Sean Smith |
Previous by Thread: |
Re: [Bacula-users] MySQL "hangs", jobs hang. Well not really, but, Richard Fox |
Next by Thread: |
Re: [Bacula-users] MySQL "hangs", jobs hang. Well not really, but, Jari Fredriksson |
Indexes: |
[Date]
[Thread]
[Top]
[All Lists] |
|
|