Your message dated Mon, 30 Jun 2008 09:56:53 -0500
with message-id <[EMAIL PROTECTED]>
and subject line Fixed upstream
has caused the Debian Bug report #442884,
regarding Default MySQL table format contains a redundant index
to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [EMAIL PROTECTED]
immediately.)


-- 
442884: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=442884
Debian Bug Tracking System
Contact [EMAIL PROTECTED] with problems
--- Begin Message ---
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.




--- End Message ---
--- Begin Message ---
This was fixed upstream some time back already.


--- End Message ---

Reply via email to