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