-----Original Message-----
From: Graham Keeling [mailto:
graham AT equiinet DOT com]
Sent: 13 April 2010 14:10
To:
bacula-users AT lists.sourceforge DOT 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 AT lists.sourceforge DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users