Hi, 07.09.2007 10:32,, Gabriele Bulfon wrote:: > > Hello, > I need to speed up the backup of a machine with a lot of very small > files (600,000 = 90Gb). > I have verified that the problem is the mysql database, slowing down the > backup because it has > to write 600,000 records in the catalog. > I'm thinking of 2 options: > 1- forcing transactions at the start and end of every job (or at the end > of the last job, maybe). > 1- upgrading version 1.38 -> 2.x (latest). > > Questions are: > 1- how can I force bacula to use these transactions?
Don't try this... Bacula (once) was prepared for this aproach, but it never worked for serious reasons. > 2- should I expect performance improvements by upgrading? Definitely. Especially in case of adding files, the new batch insert code should increase the performance. Note that you'll need MySQL version 4.1 upwards. Finally, you forgot one other option: Get a faster database server :-) Arno > > Thanx for any help > Gabriele. > > <http://www.sonicle.com> > Gabriele Bulfon - Sonicle S.r.l. > Tel +39 028246016 Int. 30 - Fax +39 028243880 > Via Felice Cavallotti 16 - 20089, Rozzano - Milano - ITALY > http://www.sonicle.com > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > > > ------------------------------------------------------------------------ > > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users -- Arno Lehmann IT-Service Lehmann www.its-lehmann.de ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
