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.
Complete Genomics Sale: Gruyère or Emmental?
6 hours ago