Hi,
I have the following indexes:
mysql> show indexes from
File;+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+|
Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation |
Cardinality | Sub_part | Packed | Null | Index_type | Comment
|+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+|
File | 0 | PRIMARY | 1 | FileId | A |
367094717 | NULL | NULL | | BTREE | || File |
1 | JobId | 1 | JobId | A | 6900 | NULL
| NULL | | BTREE | || File | 1 | JobId |
2 | PathId | A | 22943419 | NULL | NULL | |
BTREE | || File | 1 | JobId | 3 |
FilenameId | A | 367094717 | NULL | NULL | | BTREE |
|+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
Are these the right ones?
Thanks,
Jan Jaap
Date: Tue, 20 Apr 2010 14:53:54 +0200
From: ksantiste...@gmail.com
To: evan.fra...@rms.com
CC: bacula-users@lists.sourceforge.net
Subject: Re: [Bacula-users] bacula 5.0.1 and db issues - please, share
your experience
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
_________________________________________________________________
Een netbook met Windows 7? Hier vind je alles dat je moet weten.
www.windows.nl/netbook------------------------------------------------------------------------------
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
