Package: bacula-director-mysql
Version: 3.0.2-3~bpo50+1
Severity: important
Hello,
we are using the MySQL variant of bacula (lenny-bpo version) and there is
since the upgrade from 2.x to 3.x an missing index on the FilenameId
column:
mysql> SHOW INDEX FROM Path;
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation |
Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Path | 0 | PRIMARY | 1 | PathId | A |
760828 | NULL | NULL | | BTREE | |
| Path | 1 | Path | 1 | Path | A |
760828 | 255 | NULL | | BTREE | |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
2 rows in set (0.00 sec)
Also dbcheck complains about it:
Checking for orphaned Path entries. This may take some time!
Found 4327 orphaned Path records.
Deleting 4327 orphaned Path records.
Note. Index over the FilenameId column not found, that can greatly slow
down dbcheck.
Create temporary index? (yes/no): yes
Create temporary index... This may take some time!
Severity important, because it slows down bacula..
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
