I'd say you'll get the best performance with postgresql right now : batch insert has been made primarily for it (and uses a special bulk insert statement with postgresql). I guess some optimizations could be done for mysql too, but I don't think they've been done for now ...
On Friday 07 September 2007 12:52:36 Gabriele Bulfon wrote: > haha, mysql should be fast enough on a Sun T2000 8Gb RAM....or not?!.... > Anyway, I'm installing the 2.2.2 from scratch on a test machine. > - Rebuilt mysql 5.0.33 with thread-safe switch on. > - Built Bacula with batch-insert on > Once prepared the clean db and everything needed for my existing volumes, > I ran one job to check rate. > What happens, is that the bconsole "m" command is throwing out a big amount > of debug infos about buffer allocation.............. So I rebuilt bacula > with "disable-smartalloc", but I had no chance to > make..................full of errors.... What should I do to take off all > that debug info?!?! Why do I need smartalloc on?! ...oh, sorry: I'm testing > on a Solaris 10 amd (Sun v20z). > Thanx a lot > Gabriele. > 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 > --------------------------------------------------------------------------- >------- Da: Arno Lehmann <[EMAIL PROTECTED]> > A: bacula-users@lists.sourceforge.net > Data: 7 settembre 2007 12.39.41 CEST > Oggetto: Re: [Bacula-users] performance > 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 ------------------------------------------------------------------------- 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
