Bacula-users

Re: [Bacula-users] Finding performance issues

2009-02-17 10:08:17
Subject: Re: [Bacula-users] Finding performance issues
From: Daniel Holtkamp <holtkamp AT riege DOT com>
To: Bacula-users AT lists.sourceforge DOT net
Date: Tue, 17 Feb 2009 15:51:57 +0100
Hi !

(private) HKS wrote:
> It seems more and more likely to me that this is a Bacula-specific
> issue. What else can I dig into to try to resolve this?

Can you check how many queries per second you get on the database while
backing up ?

Spooling makes no difference i take it ?
Does attribute spooling make a difference ? (Spool Attributes = yes)

If you didn`t check out attribute spooling yet it could still be a
problem with the database. If it is you should see higher transfer speed
during the backup. After the backup the attributes are commited to the
database and THIS takes quite a while.

At least that is what i can see on my system.

I can see it inserting with about 250 - 300 queries per second ... never
goes higher ... and for filesets with 10 million files that takes quite
a while to commit ...

Database, Attribute-Spool-Files, MySQL-Temp Files and Backup-Files are
all on different arrays ...

-- 
Daniel Holtkamp                    Riege Software International GmbH
System Administration                                   Mollsfeld 10
40670 Meerbusch, Germany                     Phone: +49-2159-9148-41
mail: holtkamp [at] riege.com                Fax:   +49-2159-9148-11
--------------------------------------------------------------------


.............................................................
Riege Software International GmbH  Fon: +49 (2159) 9148 0
Mollsfeld 10                       Fax: +49 (2159) 9148 11
40670 Meerbusch                    Web: www.riege.com
Germany                            E-Mail: holtkamp AT riege DOT com
---                                ---
Handelsregister:                   Managing Directors:
Amtsgericht Neuss HRB-NR 4207      Christian Riege
USt-ID-Nr.: DE120585842            Gabriele  Riege
                                   Johannes  Riege
.............................................................
           YOU CARE FOR FREIGHT, WE CARE FOR YOU          




------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users