> 
> My setup has suddenly slowed down when running virtualfull jobs. I don't
> think it's all virtualfull jobs as if I kill off the one that's stalled then 
> a few more
> run okay until it hits another bad one.
> 
> iostat on the sd shows pretty much nothing happening most of the time...
> bursts of 1MB/second or so then nothing for the next 10 seconds.
> 
> Logging mysql queries I'm seeing lots of 'insert into batch ...' but there 
> are a
> few other jobs running concurrently so I can't be sure that these relate to my
> slow job.
> 
> Bacula says the job is 'running' but way slower than it should. It's going to
> USB2 disk so I'd expect and have previously observed speeds of
> 20Mbytes/second.
> 
> Once the other jobs have completed I'll start stracing and monitoring the
> mysql queries to get a better picture of where it's going wrong, but any other
> suggestions for what to monitor would be greatly appreciated!
> 

I switched on attribute spooling and now the job flies along until it gets to 
inserting attributes then it stops for ages. A virtual job that took 2 minutes 
to run is still inserting attributes 2 hours later. It is making progress, just 
very very slowly, and mysql is using lots of CPU.

What could have gone wrong with my mysql to make this happen? I've tried 
rebooting it.

How difficult is it to convert an existing installation over to postgresql? 
I've been meaning to do this for a while and it may be faster than trying to 
resolve the issue...

Thanks

James


------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service 
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users