On Sun, 23 May 2010 01:13:33 -0700 (PDT) john espiro <[email protected]> wrote:
> I am trying to make sure I have the proper index on my dspam tables and for > dspam_token_data I see the following... > Does it look correct? To me, it looks as though I have something a bit messed > up. Shall I remove the indexes and re-add them (if so, which ones should I > add)? > > > | Table | Non_unique | Key_name| Seq_in_index | Column_name | Collation | > Cardinality | Sub_part | Packed | Null | Index_type | Comment | > +------------------+------------+------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+------- > | dspam_token_data | 0 | id_token_data_01 | 1 | uid | A | 18 | > NULL | NULL | | BTREE || > | dspam_token_data | 0 | id_token_data_01 | 2 | token | A | 1944879 > | NULL | NULL | YES | BTREE || > | dspam_token_data | 1 | id_token_data_02 | 1 | innocent_hits | A | 18 > | NULL | NULL | | BTREE || > | dspam_token_data | 1 | id_token_data_04 | 1 | uid | A | 18 | > NULL | NULL | | BTREE || > | dspam_token_data | 1 | spam_hits | 1 | spam_hits | A | 18 > | NULL | NULL | | BTREE || > | dspam_token_data | 1 | innocent_hits | 1 | innocent_hits | A | 710 > | NULL | NULL | | BTREE || > | dspam_token_data | 1 | last_hit | 1 | last_hit | A | 18 | > NULL | NULL | YES | BTREE || > | dspam_token_data | 1 | spam_hits_2 | 1 | spam_hits | A | 18 > | NULL | NULL | | BTREE || > | dspam_token_data | 1 | innocent_hits_2 | 1 | innocent_hits | A | 18 > | NULL | NULL | | BTREE || > | dspam_token_data | 1 | last_hit_2 | 1 | last_hit | A | 18 | > NULL | NULL | YES | BTREE || > > Ohhh boy. That looks messy! You have way, way to manny columns indexed. What storage driver are you using? MyISAM? InnoDB? -- Kind Regards from Switzerland, Stevan Bajić ------------------------------------------------------------------------------ _______________________________________________ Dspam-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspam-user
