Hi and good evening to you...
Michael 'buk' Scherer wrote:
Good morning.
I guess I should have waited before cheering too loud. The spooling and the writing of the data to tape is done with a nice speed. Between 6 and 8 MB/s, which is good. I could live with that.
BUT, here we go, after everything is written to tape, Bacula starts to fix/add/remove/clean the file attributes in the database, which takes, you guess it, as long as before.
As a result I come off with a average speed of ~1.5MB/s. Painfull.
Any ideas?
Sure.
Get a faster database.
;-)
Seriously:
The database speed issue was discussed quite often (to my knowledge) and nothing definite resulted from it.
I don't recall which db you use and am too lazy to look throgh the mail now, but insert speed seems to be different depending on the DBMS (MySQL vs. PostgreSQL, I don't know about the standalone db... even forgot it's name).
One important item are transactions in PGSQL and, with every DBMS, the indizes to update. You might try to remove (or disable) indizes during the attribute despooling and to recreate them afterwards - that alone could help a lot.
Completely removing them is not what I'd suggest... unless you want to spend lots of time staring at the console when you want to restore something.
Others have tried to pin down the performance cost of different indizes existence, but I assume that this depends too much on your DBMS and hardware.
If you already have a (f***king fast) dedicated database server in your organization you might try moving the catalog to it.
Admittedly, nopromises from me, but perhaps some hints how to tackle that problem.
Arno
Greetings, Michael
-- IT-Service Lehmann [EMAIL PROTECTED] Arno Lehmann http://www.its-lehmann.de
------------------------------------------------------- This SF.net email is sponsored by Demarc: A global provider of Threat Management Solutions. Download our HomeAdmin security software for free today! http://www.demarc.com/Info/Sentarus/hamr30 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
