On Apr 23, 2007, at 6:25 AM, Damian Lubosch wrote:

> I have a machine to backup with about 1-2 million small files (~1kb).
> When I run a migration job for about 4 GB of such data the performance
> is going down. The tape rewinds very often and the overall performance
> is about 3MB/sec. I found out (with top) that the mysql is taking all
> the processing power (together with bacula-sd) when migrating many  
> files.
> On the other hand, when migrating only few large files -backups is
> running fine with 20-30MB/sec.

Well, I trust you already know about "Spool data" job directive, but  
in addition you might try setting "Spool Attributes = yes". Since  
you're dealing with many small files (and attributes scale by  
filecount, not by data amount), it could help... although I'm not  
sure how it would work with a migration job.

As the manual says:

"[I]f you want to avoid the possibility that database updates will  
slow down writing to the tape, you may want to set the value to yes,  
in which case the Storage daemon will buffer the File attributes and  
Storage coordinates to a temporary file in the Working Directory,  
then when writing the Job data to the tape is completed, the  
attributes and storage coordinates will be sent to the Director."

--
--Darien A. Hager
[EMAIL PROTECTED]



-------------------------------------------------------------------------
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

Reply via email to