Re: [Bacula-users] Slow Backups with MySQL

2012-05-31 Thread Keet Fox
Hey Martin, Thanks for taking the time to read my problems. It's much appreciated. src/config.h reports #define USE_BATCH_FILE_INSERT 1 #define HAVE_THREAD_SAFE_MYSQL 1 I also turned on general logging on MySQL to see what queries were coming across and it's inserting everything into the batch t

Re: [Bacula-users] Slow Backups with MySQL

2012-05-31 Thread Martin Simmons
> On Tue, 29 May 2012 18:01:35 -0400, Greg Neujahr said: > > I also did not originally have '--enable-batch-insert' in the > configure options, as it supposedly defaulted to 'yes'. I recompiled > to enable it, just for testing. Batch insert might be off if configure thinks that the MySQL can'

[Bacula-users] Slow Backups with MySQL

2012-05-29 Thread Greg Neujahr
Hey Folks, I run a few slackware boxes and recently (read: about a month ago) upgraded the mysql server and client libraries on my installs. Sometime after that point, the full backups I was performing on these three boxes started to take 5-6 hours a piece, as opposed to the 30-40 minutes it was p