Hi, 07.09.2007 12:52,, Gabriele Bulfon wrote:: > > haha, mysql should be fast enough on a Sun T2000 8Gb RAM....or not?!....
I think so... of course you could almways find a faster DB machine :-) Is this the machine the DIR is running on, too? If not, you might havethe bottleneck in the network connection. > 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.............. Just use 'mes' instead of 'm' - that's for memory usage now :-) Arno > 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. > > <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 > > > > > ---------------------------------------------------------------------------------- > > 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 > > > -- 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
