Hello,
On Wednesday 22 March 2006 10:36, Gavin Conway wrote:
> Hi Kern,
>
> I did notice the difference when looking at the two installs I have
> here. Here is the output from the two;
>
> Debian Sarge 3.1 Bacula 1.36.2 (installed from the debian stable tree)
>
> +-------+------------+------------+--------------+-------------+-----------
>+-------------+----------+--------+------+------------+---------+
>
> | 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 | 26781364 | NULL | NULL | | BTREE | |
>
> | File | 1 | FilenameId | 1 | FilenameId |
>
> A | 653204 | NULL | NULL | | BTREE | |
>
> | File | 1 | FilenameId | 2 | PathId |
>
> A | 686701 | NULL | NULL | | BTREE | |
> +-------+------------+------------+--------------+-------------+-----------
>+-------------+----------+--------+------+------------+---------+
>
>
> Debian Sarge 3.1 Bacula 1.38.5 (installed from source)
>
> +-------+------------+----------+--------------+-------------+-----------+-
>------------+----------+--------+------+------------+---------+
>
> | 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
> | 0 | 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 | |
>
> +-------+------------+----------+--------------+-------------+-----------+-
>------------+----------+--------+------+------------+---------+
>
>
> Can anyone else running Debian Sarge 3.1 and the package in the debian
> stable tree confirm my findings? If they can then I'm quite concerned
> that this installation will have been deployed to clients. Is there an
> easy way to add the missing indexes to the default install?
It is quite possible that some older installations do not have all the proper
indexes. I'm not convinced that you need confirmation, you just need to add
the missing indexes providing you are having performance problems or as a
matter of precaution. There is a chapter in the manual that has a section
that specifically addresses performance and indexes -- probably the MySQL
chapter. It provides details of how to create the indexes ...
--
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&kid=110944&bid=241720&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
