MySQL Forums
Forum List  »  General

Issues with possible duplicate indices on table
Posted by: Doug Livesey
Date: December 08, 2011 09:15AM

Hi -- I was wondering if I could ask the community for a sanity check on the indices on a table we have with around 750,000 records in it.
The show keys output for it is here: https://gist.github.com/1447223
To me, it looks like there's a double index on id, which must be slowing things up, and there are things that don't look right about other indices there, too.
Unfortunately, I'm far from an expert (although I'm somewhere on the road there, hopefully ;)), so thought I'd post the indices here, in the hope that a DB guru might be able to point me more accurately at where they may be a problem.
Thanks for any & all help,
Doug.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.