Hello Gavin,
I suspect that you might be experiencing some serious performance problems. A
more
appropriate set of indicies is probably something like what I have:
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 |
1345013 | NULL | NULL | | BTREE | |
| File | 1 | JobId | 1 | JobId | A |
NULL | NULL | NULL | | BTREE | |
| File | 1 | JobId_2 | 1 | JobId | A |
NULL | NULL | NULL | | BTREE | |
| File | 1 | JobId_2 | 2 | PathId | A |
NULL | NULL | NULL | | BTREE | |
| File | 1 | JobId_2 | 3 | FilenameId | A |
NULL | NULL | NULL | | BTREE | |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
5 rows in set (0.00 sec)
which is the "default" installation.
On Tuesday 21 March 2006 18:14, Gavin Conway wrote:
> Barry,
>
> This may be of some use;
>
> 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 | 25687365 | NULL | NULL | | BTREE |
> | | File | 1 | FilenameId | 1 | FilenameId | A | 626521 | NULL | NULL | |
>
> BTREE | |
>
> | File | 1 | FilenameId | 2 | PathId | A | 658650 | NULL | NULL | |
>
> BTREE | |
> +-------+------------+------------+--------------+-------------+-----------
>+-------------+----------+--------+------+------------+---------+ 3 rows in
> set (0.00 sec)
>
> mysql>
>
>
> Regards,
> Gavin Conway
>
> Barry Benowitz wrote:
> > Hi All,
> >
> > I am starting to notice performance problems on my bacula setup. Some
> > nights it backs up around 25G in 2 Hours, Last night it is still
> > running after 8 hours for the same 25G. Reading the manual told me to
> > check the indexes and I see that there are some set (5 of them) but
> > they don’t seem to have the name mentioned. Would someone using MySQL
> > post what an appropriate result from a show index from File command
> > should be?
> >
> > Thanks,
> >
> > Barry
> >
> > Barry Benowitz
> >
> > Raritan Computer
> >
> > (732) 764 8886 x1362
> >
> > [EMAIL PROTECTED]
--
Best regards,
Kern
(">
/\
V_V
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
