Manuel Wolff wrote:
>
>
>
> Arno Lehmann wrote:
>>
>>
>> the current beta version 2.1.10 has some improvements that should speed
>> up catalog inserts *a lot*. I'd recommend to give it a try if you dare
>> running a beta version on a production system.
>>
>> As far as I know, there is neither a tape format change, nor a catalog
>> schema change between 2.0 and 2.1.10, so if you keep a catalog dump and
>> use new tapes you could revert to your existing installation without any
>> problems.
>>
>>
>>
>
> Hi Arno
>
> It is a production system, but I'll think about it when I'm back from
> vacation in about two and a half
> weeks.
> Another Idea is to workaround this by splitting the job (and the fileset)
> in two pieces running at the same time.
>
> Thanks a lot
> Manuel
>
>
Hi Arno
First I've splitted the big Job into two smaller jobs.
It is faster but not fast enough. So last week I switched to 2.1.18
Yesterday I found out that the speed of attribute spooling is still only
about one MB per minute. I searched in webSVN and I found Kerns changelog
kes Fix HAVE_BATCH_INSERT to be HAVE_BATCH_FILE_INSERT, pointed out by Eric
(my typo).
Today I switched to 2.1.22
I found in patches/testing/batch-insert.readme
from Eric Bollengier:
[...]
and you MUST change some indexes.
mysql)
ALTER TABLE Filename DROP INDEX Name;
ALTER TABLE Filename ADD UNIQUE (Name(255));
ALTER TABLE Path DROP INDEX Path;
ALTER TABLE Path ADD UNIQUE (Path(255));
[...]
We have longer paths than 255 so I typed 511 instead
Now it seems to work as expected with about 10MB/Min :-)
Thanks
Manuel
--
View this message in context:
http://www.nabble.com/spooling-attributes-to-the-director-too-slow-tf3800623.html#a11309420
Sent from the Bacula - Users mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
