MySQL Forums :: General :: Issues with possible duplicate indices on table


Advanced Search

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


Subject Written By Posted
Issues with possible duplicate indices on table Doug Livesey 12/08/2011 09:15AM
Re: Issues with possible duplicate indices on table Peter Brawley 12/08/2011 12:35PM
Re: Issues with possible duplicate indices on table Doug Livesey 12/08/2011 01:30PM
Re: Issues with possible duplicate indices on table Peter Brawley 12/08/2011 02:17PM
Re: Issues with possible duplicate indices on table Doug Livesey 12/08/2011 03:17PM
Re: Issues with possible duplicate indices on table Peter Brawley 12/08/2011 08:49PM
Re: Issues with possible duplicate indices on table Doug Livesey 12/09/2011 03:20AM
Re: Issues with possible duplicate indices on table Rick James 12/11/2011 06:27PM


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.