Re: [Bacula-users] Bacula 2.2.8, dbcheck never completes
2008-08-18 13:38:08
>I really sort of feel like I have too many indexes now, but... who
>knows. Anyone know if MySQL will allow you to define two of the same
>index?
Why? Have you already changed something on the indices on the tables?
Yes, it's possible as long as the index names are different. Sorry, but
I don't have your mysql output anymore. But each line in your posted
output represents a column in the index. So for each column in the index
exist one record.
An example based on my previous post:
First record: Primary index (column index:1)
Second record: JobId on the column JobId (column index:1)
Third record: JobId_2 on the column JobId (column index:1)
Fourth record: JobId_2 on the column PathId (column index:2)
Fifth record: JobId_2 on the column FilenameId (column index:3)
Sixth record: PathId on the column PathId (column index:1)
Seventh record: FilenameId on the column FilenameId (column index:1)
At the end there are seven records for five indices.
Hopes this helps.
Cheers, Primus.
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
Re: [Bacula-users] Bacula 2.2.8, dbcheck never completes, Technik
- Re: [Bacula-users] Bacula 2.2.8, dbcheck never completes, Ryan Novosielski
- Re: [Bacula-users] Bacula 2.2.8, dbcheck never completes,
Technik <=
- Re: [Bacula-users] Bacula 2.2.8, dbcheck never completes, Ryan Novosielski
- Re: [Bacula-users] Bacula 2.2.8, dbcheck never completes, Technik
- Re: [Bacula-users] Bacula 2.2.8, dbcheck never completes, Ryan Novosielski
- Re: [Bacula-users] Bacula 2.2.8, dbcheck never completes, Technik
Re: [Bacula-users] Bacula 2.2.8, dbcheck never completes, Jeff Dickens
|
|
|