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 ||
------------------------------------------------------------------------------
_______________________________________________
Dspam-user mailing list
Dspam-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspam-user
