Re: [Bacula-users] Check database when bacula-dir start

Do you think if I tuning databases with :
http://www.newitperson.com/2011/01/reduce-bacula-dbcheck-time/
CREATE INDEX File_JobId_idx ON File(JobId);
CREATE INDEX File_PathId_idx ON File(PathId);
CREATE INDEX File_FilenameId_idx ON File(FilenameId);
CREATE INDEX Path_PathId_idx ON Path(PathId);
CREATE INDEX Job_FileSetId_idx ON Job(FileSetId);
CREATE INDEX Job_ClientId_idx ON Job(ClientId);
CREATE INDEX File_FilenameIdPathId_idx ON File(FilenameId,PathId);

Or with :
http://www.bacula.org/manuals/en/catalog/catalog/Catalog_Maintenance.html#SECTION00291000000000000000
CREATE INDEX file_jobid_idx on file (jobid);
CREATE INDEX file_jpf_idx on file (jobid, pathid, filenameid);

it will be faster?

Le 6 avril 2012 18:10, John Drescher <drescherjm AT gmail DOT com> a écrit :

> I have a bacual-dir with ~250 clients. And each client has its own catalog.
>
> When bacula-dir start, bacula-dir checks each database (~10s per client =
> ~45 minutes !!!)
> Meanwhile, the director is not accessible...
>
> How can I bypass that or reduce that ?
>

I would try speeding up your database server perhaps by putting the
databases on an SSD or an array of them or at minimum a RAID10 of fast
harddrives.

John

------------------------------------------------------------------------------
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know...and Tell You.
Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
http://p.sf.net/sfu/Boundary-d2dvs2

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users