Hi, I'll forward this to the devel list, because I suppose people there are interested in your experience...
26.06.2007 18:48,, Manuel Wolff wrote:: > > > 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 :-) Good to hear... have you tried concurrent jobs and a restore to make sure everything works for you? Arno > Thanks > Manuel > -- Arno Lehmann IT-Service Lehmann www.its-lehmann.de ------------------------------------------------------------------------- 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
