Creating indexes solve performance issues on your environment Evan?
On Fri, Apr 16, 2010 at 7:21 PM, Evan Fraser <evan.fra...@rms.com> wrote:
> 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
>
------------------------------------------------------------------------------
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
