On Wednesday 22 March 2006 11:11, Carlo Agrusti wrote: > 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.
The above is probably quite OK, as you have individual indexes on all the important columns. If mine were like that, I wouldn't change it unless I were having performance problems ... > > 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 -- 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
