Hello James,

It looks like you have found the most important things: turn on 
attribute spooling,
and switch to InnoDB.  Before switching to PostgreSQL, you might try running
the MySQL tunning program mysqltune (I forgot the exact name).  It tells 
you
items you should tune.  Often users do not give it enough memory, or even do
the opposite which can cause problems, that is give it too much.

There are several scripts that switch from MySQL to PostgreSQL that work
fine. They also allow you to keep your MySQL running until you get a good
config for PostgreSQL.  Tunning PostgreSQL is much more complicated, but
it gives *far* better results for big jobs.

Best regards,
Kern


On 04/25/2013 04:51 AM, James Harper wrote:
> 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!
>
> 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
>


------------------------------------------------------------------------------
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