Package: bacula-director-mysql
Version: 2.2.0-1
In the file /usr/share/bacula-director/make_mysql_tables lines 41-44
define the following indexes:
INDEX (JobId),
INDEX (PathId),
INDEX (FileNameId, PathId),
INDEX (JobId, PathId, FilenameId)
The first index on column JobId is redundant. It is already included
in the last index on (JobId, PathId, FilenameId).
The redundant index consumes storage space and slows down the
database, and should be thus removed.
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
