MSQL error

Discussion in 'Databases' started by fryman, Oct 11, 2005.

0
  1. #1
    After doing a check on all my tables I got these 2 errors:

    Is this something I should be concerned about? How can I fix it?

    EDIT: sorry, please move this post to the database board
     
    fryman, Oct 11, 2005 IP
  2. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #2
    It's basically a waste of resources if you have two indexes that are indexing identical columns. For example, if both indexes for category are indexing just the one "name" column, I would just drop the index that is NOT the UNIQUE one (since there are more validation restrictions on that one). The UNIQUE one can do more (in terms of validation) than the other one, but the other one can't do anything for you that the UNIQUE one doesn't already do.

    Confusing enough for ya? :)
     
    digitalpoint, Oct 11, 2005 IP
  3. fryman

    fryman Kiss my rep

    Messages:
    9,604
    Likes Received:
    777
    Best Answers:
    0
    Trophy Points:
    370
    #3
    I knew you would stop by this thread :D

    Yeah, sure is confusing... so, if I go to phpmyadmin and select the "Repair Table" option will it fix this?
     
    fryman, Oct 11, 2005 IP
  4. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #4
    No... because the table isn't broken, it just has a redundant/extra index. Someone (or something) had to add it, so someone (or something) will have to remove it.
     
    digitalpoint, Oct 11, 2005 IP
  5. fryman

    fryman Kiss my rep

    Messages:
    9,604
    Likes Received:
    777
    Best Answers:
    0
    Trophy Points:
    370
    #5
    I see... so, which one should I delete, or how can I find out which one I should delete?
     
    fryman, Oct 11, 2005 IP
  6. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #6
    Attach a screenshot of your index list for that table. :)
     
    digitalpoint, Oct 11, 2005 IP