problems with db indexes?

[bdconnolly]

futzing around the db and when I checked it it gave this:

Code: Select all

Problems with indexes of table `serendipity_access`
More than one INDEX key was created for column `artifact_id`
Problems with indexes of table `serendipity_entryproperties`
UNIQUE and INDEX keys should not both be set for column `entryid`
Problems with indexes of table `serendipity_entrytags`
PRIMARY and INDEX keys should not both be set for column `entryid`
Problems with indexes of table `serendipity_groupconfig`
More than one INDEX key was created for column `id`

Is that a problem?

[garvinhicking]

Hi!

This is a problem of phpMyAdmin, sadly. It does not tell you properly, that the message is just a warning that might or MIGHT NOT apply. In some cases it's perfectly allright to have multiple indixes with same columns to improve performance for specific queries.

Best regards,
Garvin