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 <martin AT lispworks DOT com>
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
> Bacula-users AT lists.sourceforge DOT net
> 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
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
