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 table when it despools. The problem is, I would be expecting it to insert more than 20-30 entries a second into the database as it despools. As I said in the original post, it could be a MySQL issue, or potentially a client library issue. However, doing a mysqldump of the database on the remote server, copying it over to the director/file daemon, and then running 'mysql' and using 'source' to reinsert, takes all of 10-20 seconds. So, the database server itself seems to be happy with the information, just not bacula's communication with it. I'd be willing to insert some debug code to monitor how quickly bacula is sending the queries if someone could give me a spot to look. I'm not opposed to hacking a few things to get more information, I just don't have the time to understand the entire project to know where to put in some printfs :> Thanks again for your help! I do appreciate the time you're putting into looking at this. - Greg On Thu, May 31, 2012 at 2:38 PM, Martin Simmons <[email protected]> wrote: >>>>>> 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't do it. > > What did configure print for "Batch insert enabled:"? > > Also, check the values of USE_BATCH_FILE_INSERT and HAVE_MYSQL_THREAD_SAFE in > the src/config.h that it generated. Both need to be 1. > > __Martin > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > Bacula-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/bacula-users ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
