Gavin McCullagh wrote: > On Mon, 08 Nov 2010, Alan Brown wrote: > >> Mysql works well - if tuned, but tuning is a major undertaking when >> things get large/busy and may take several iterations.
> When we do restores, building the tree takes a considerable time now. I > haven't had a lot of time to look at it, but suspected it might be down to > this issue. That's a classic symptom of not having the right indexes on the File table. This is in the FAQ somewhere and it's the issue you mentioned as affecting mysql but not postgresql (Their index handling is slightly different). The other big contributor to long tree builds is insufficient ram. Keep an eye on swap and the bacula-dir process whilst building the tree. If it starts thrashing, you need more memory. ------------------------------------------------------------------------------ The Next 800 Companies to Lead America's Growth: New Video Whitepaper David G. Thomson, author of the best-selling book "Blueprint to a Billion" shares his insights and actions to help propel your business during the next growth cycle. Listen Now! http://p.sf.net/sfu/SAP-dev2dev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
