Bacula-users

[Bacula-users] Improving catalog performance

2008-11-27 12:07:08
Subject: [Bacula-users] Improving catalog performance
From: "Kelly, Brian" <Brian.Kelly AT uwsp DOT edu>
To: "bacula-users AT lists.sourceforge DOT net" <bacula-users AT lists.sourceforge DOT net>
Date: Thu, 27 Nov 2008 11:04:47 -0600
Arno,

I've been studying different options for improving my database performance. 

After reading your recommendations on improving catalog performance. 

"There are two rather simple solutions:
- Don't keep file information for this job in the catalog. This makes 
restoring single mails difficult.
- Tune your catalog database for faster inserts. That can mean moving 
it to a faster machine, assigning more memory for it, or dropping some 
indexes (during inserts). If you're not yet using batch inserts, try 
to recompile Bacula with batch-inserts enabled."

Could you elaborate on how to:

1. Not keep file information for particular jobs in the catalog. 
2. How does one drop an index during inserts?

Thanks,

Brian Kelly



-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

<Prev in Thread] Current Thread [Next in Thread>