MySQL Forums
Forum List  »  Performance

Re: Long query locking up MySQL Server
Posted by: Shawn Taylor
Date: December 03, 2010 02:23PM

I think you can delete these keys:

KEY `data_start` (`data_start`) -- redundant served by KEY `lista_przeloty` (`data_start`,`catalog`,`lotnisko_wylotu`,`kod_obiektu`)
KEY `catalog` (`catalog`) -- redundant served by KEY `shortIdx` (`catalog`,`kod_obiektu`)
KEY `kod_regionu` (`kod_regionu`) -- redundant served by KEY `catalogRegionIdx` (`kod_regionu`,`catalog`)
KEY `kod_panstwa_ISO` (`kod_panstwa_ISO`) -- redundant served by KEY `dlaPeriodow` (`kod_panstwa_ISO`,`catalog`,`kod_obiektu`) and KEY `lista_obiektow` (`kod_panstwa_ISO`,`data_start`,`catalog`,`kod_obiektu`)
KEY `period` (`period`) -- redundant served by KEY `dlaPeriodow2` (`period`,`catalog`,`kod_obiektu`)
KEY `catalogRegionIdx` (`kod_regionu`,`catalog`) -- redundant served by KEY `lista_obiektow2` (`kod_regionu`,`catalog`,`kod_obiektu`)
KEY `dataCatalogIdx` (`data_start`,`catalog`) -- redundant served by KEY `lista_przeloty` (`data_start`,`catalog`,`lotnisko_wylotu`,`kod_obiektu`)

This won't help you with the select, but will help overall since you are just cluttering up your design with redundant index data.

Once I see the create on the other table we can go from there.

Shawn

Options: ReplyQuote


Subject
Views
Written By
Posted
4043
December 01, 2010 05:23AM
1087
December 02, 2010 12:27AM
905
December 03, 2010 08:46AM
Re: Long query locking up MySQL Server
973
December 03, 2010 02:23PM
810
December 03, 2010 09:21PM
2080
December 04, 2010 11:44AM


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.