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 ph...@caerllewys.net p...@co.ordinate.org Landline: 603.293.8485 ------------------------------------------------------------------------------ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
