On Tue, Apr 13, 2010 at 02:03:39PM +0100, Graham Keeling wrote: > On Tue, Apr 13, 2010 at 02:42:15PM +0200, Koldo Santisteban wrote: > > Hello > > I am working with bacula 5.0.1. On first stage i setup the server with > > bacula 5.0.1 and Mysql, but, when i need to restore i have found that "the > > bulid tree process" take 10-12 hours (or more). I have read all about this > > issues and i can see that no exists any "magic" solution. In order to solve > > it, i have migrate from mysql to postgre, but i can see the same symtopms. > > Perhaps it works better, but, in my opnion, this is not serios on a > > production environment. > > If it´s possible, i will appreciate it people share their experience with > > bacula last version and this kind of issues. A couple of month ago i > > finished to deploy bacula on my environment, but now, i am considering to go > > back all. > > Please any comment regarding this case is welcome. > > Regards > > Hello, > > I had similar problems with virtual and accurate backups until I made sure > that the indexes on my mysql database were the bacula defaults. > In particular, I had these indexes on my File table: > > JobId > JobId, PathId, FilenameId > PathId > FilenameId > > Once I had removed the PathId and FilenameId indexes, my queries changed from > taking many hours to taking about a second.
For clarity, I now have these indexes on my File table: JobId JobId, PathId, FilenameId > > To check these on your database: > Log into mysql. > use bacula; > show indexes from File; > > If you have any extra indexes, you can drop them like this: > > drop index <index name> on File; > e.g: drop index PathId on File; > > If you need to add one: > > create index <index name> on File (<list of fields>); > e.g: create index JobId on File (JobId); > > > ------------------------------------------------------------------------------ > Download Intel® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
