In response to Ondrej PLANKA <[EMAIL PROTECTED]>:
> Alan Brown napsal(a):
> > On Tue, 9 Jan 2007, Ondrej PLANKA wrote:
> >
> >>> It sounds silly, but add individual indexes for JobId, PathId and
> >>> FilnameId as well as the 3-way one.
> >>>
> >> Ok, do you have some tip, how can I add individual indexes? Because I
> >> think, my indexes are OK or not?
> >
> > ALTER TABLE File ADD INDEX [name] {column} ;
> >
> > so...
> >
> > ALTER TABLE File ADD INDEX file_jobid_idx JobId ;
> > ALTER TABLE File ADD INDEX file_pathid_idx PathId ;
> > ALTER TABLE File ADD INDEX file_filenameid_idx FilenameId ;
> >
> I really done this individual indexes, but building directory tree for
> Jobs are still very slowly.....
Index problems are probably the most common reason for this, but they're
not the only possible cause.
I didn't see any hardware details -- perhaps you posted it earlier and
I missed them. Bacula will need a lot of RAM to store that large of a
directory tree. Monitor top, iostat, and any other sys monitoring programs
you can during the tree build.
In our case, we decided to add another gig of RAM to backup server and things
are nice and fast now.
--
Bill Moran
Collaborative Fusion Inc.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
