Re: [Bacula-devel] Schema patch

2017-08-06 Thread Kern Sibbald
Hello Ulrich, I obviously would be interested in seeing the statistics, and unless you take some precautions I would strongly suggest not running it on a production environment. If you do, nevertheless, want to try, at a minimum, I would create a new database (named perhaps TestBacula. Then

Re: [Bacula-devel] Schema patch

2017-08-06 Thread Phil Stracchino
On 08/06/17 13:47, Ulrich Leodolter wrote: > Hi Phil, > >> Phil Stracchino hat am 6. August 2017 um 17:03 >> geschrieben: >> >> Community request: >> Does anyone else here have a test environment which DOES have jobs of >> that size who could perform comparison tests of the same 20-50 million >>

Re: [Bacula-devel] Schema patch

2017-08-06 Thread Ulrich Leodolter
Hi Phil, > Phil Stracchino hat am 6. August 2017 um 17:03 > geschrieben: > > Community request: > Does anyone else here have a test environment which DOES have jobs of > that size who could perform comparison tests of the same 20-50 million > file backup job with and without batch insert? We h

Re: [Bacula-devel] Schema patch

2017-08-06 Thread Phil Stracchino
On 08/06/17 03:24, Kern Sibbald wrote: > Hello Phil, > > Thank you for your comments, and I am pleased that you have found a > solution for your batch insert problem. Unfortunately, I cannot apply > the patch to a released version two days before I go on vacation. Nor > will I change the defa

Re: [Bacula-devel] Schema patch

2017-08-06 Thread Kern Sibbald
Phil, Here is my response concerning the mysql_tables_change (see your email below). I cannot make changes of the kind that you suggest where some change items that are not broken or items where I cannot reproduce a problem. This is especially since this is a production release, which I can

Re: [Bacula-devel] Schema patch

2017-08-06 Thread Kern Sibbald
Hello Phil, Thank you for your comments, and I am pleased that you have found a solution for your batch insert problem. Unfortunately, I cannot apply the patch to a released version two days before I go on vacation. Nor will I change the default. If you can show me solid statistics on a Li

[Bacula-devel] Schema patch

2017-08-05 Thread Phil Stracchino
Kern, Rather than re-opening the ticket again - the schema patch doesn't do NEARLY as much as it looks as though it does. The make_mysql_tables script currently creates a new Bacula schema in which all DATETIME fields *except one* are left as unadorned DATETIME with no NOT NULL or DEFAULT. The o