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