Re: [Bacula-users] 7.2 mysql issue?

On 11/07/15 11:18, Jari Fredriksson wrote:
> On 5.10.2015 20.32, Stephen Thompson wrote:
>>
>> mysql> show indexes from File;
>> +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
>> | 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
>>    |  4494348205 |     NULL | NULL   |      | BTREE      |         |
>> | File  |          1 | JobId    |            1 | JobId       | A
>>    |          19 |     NULL | NULL   |      | BTREE      |         |
>> | File  |          1 | JobId    |            2 | PathId      | A
>>    |   408577109 |     NULL | NULL   |      | BTREE      |         |
>> | File  |          1 | JobId    |            3 | FilenameId  | A
>>    |  4494348205 |     NULL | NULL   |      | BTREE      |         |
>> +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
>>
>>
> 
> I seem to have an extra index from that..
> 
> show indexes from File;
> +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
> | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation 
> | Cardinality | Sub_part | Packed | Null | Index_type | Comment | 
> Index_comment |
> +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
> | File  |          0 | PRIMARY  |            1 | FileId      | A 
>   |   5,095,248 | NULL     | NULL   |      | BTREE      |         | 
>            |
> | File  |          1 | JobId    |            1 | JobId       | A 
>   |       2,736 | NULL     | NULL   |      | BTREE      |         | 
>            |
> | File  |          1 | JobId_2  |            1 | JobId       | A 
>   |          44 | NULL     | NULL   |      | BTREE      |         | 
>            |
> | File  |          1 | JobId_2  |            2 | PathId      | A 
>   |   1,019,049 | NULL     | NULL   |      | BTREE      |         | 
>            |
> | File  |          1 | JobId_2  |            3 | FilenameId  | A 
>   |   5,095,248 | NULL     | NULL   |      | BTREE      |         | 
>            |
> +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+


The index over JobId alone is redundant with the index over
(JobId,PathId,FilenameId) present as well.  I also had the redundant
index at one point, and dropped it with no ill effects.



-- 
  Phil Stracchino
  Babylon Communications
  phils AT caerllewys DOT net
  phil AT co.ordinate DOT org
  Landline: 603.293.8485

------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users