Thanks for this, it fixed my problem. Cheers, Evan.
-----Original Message----- From: Graham Keeling [mailto:gra...@equiinet.com] Sent: 13 April 2010 14:10 To: bacula-users@lists.sourceforge.net Subject: Re: [Bacula-users] bacula 5.0.1 and db issues - please, share your experience 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 This message and any attachments contain information that may be RMS Inc. confidential and/or privileged. If you are not the intended recipient (or authorized to receive for the intended recipient), and have received this message in error, any use, disclosure or distribution is strictly prohibited. If you have received this message in error, please notify the sender immediately by replying to the e-mail and permanently deleting the message from your computer and/or storage system. ------------------------------------------------------------------------------ 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
