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
