Re: [Bacula-users] Finding performance issues
2009-02-17 10:08:17
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
|
|
|