I have installed debian packages downloaded from sourceforge (Bacula 1.36.3-2), which have been packed by the same maintainer of 1.36.2-2Sarge1, and I have still another index table:
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ | 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 | 550866 | NULL | NULL | | BTREE | | | File | 1 | JobId | 1 | JobId | A | NULL | NULL | NULL | | BTREE | | | File | 1 | JobId | 2 | PathId | A | NULL | NULL | NULL | | BTREE | | | File | 1 | JobId | 3 | FilenameId | A | NULL | NULL | NULL | | BTREE | | +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ 4 rows in set (0.00 sec) P.S. I apologize for the very bad quoting, but couldn't find a better form. cheers, Carlo - a brand new Bacula user Gavin Conway ha scritto lo scorso 22/03/2006 10:36: > 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? > > Thanks, > Gavin Conway > ------------------------------------------------------- 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
