To find redundant (unneccesary) indexes in your mysql database, try the information schema views in
Roland Bouman's Redundant Index Finder. To delete them, try the procedure I_S_REDUNDANT_INDEXES_DROP which I just posted to the Community Feedback section.
Food For Thought On ONT's Proteomics Push
48 minutes ago