List:Cluster« Previous MessageNext Message »
From:Hendrik Woltersdorf Date:November 25 2010 11:11am
Subject:Antwort: Re: reason for slow query ?
View as plain text  
Hi Johan,

the primary index is very good. Many of these queries run fast, but a few
don't. And when I repeat a slow query manually it runs very fast too. At
the moment I am looking for other reasons, that slow down queries
_sometimes_. I checked the logs for LCPs but the LCP-times do not correlate
with the entries in the slow-query log.

Any other ideas ?

kind regards

Hendrik Woltersdorf
XCOM AG
Tel.: 0375/27008-580
Tel. mobil: 0178/5710078
Email: Hendrik.Woltersdorf@stripped




*** XCOM AG Legal Disclaimer ***

Diese E-Mail einschliesslich ihrer Anhaenge ist vertraulich und ist allein
für den Gebrauch durch den vorgesehenen Empfaenger bestimmt. Dritten ist
das Lesen, Verteilen oder Weiterleiten dieser E-Mail untersagt. Wir bitten,
eine fehlgeleitete E-Mail unverzueglich vollstaendig zu loeschen und uns
eine Nachricht zukommen zu lassen.

This email may contain material that is confidential and for the sole use
of the intended recipient. Any review, distribution by others or forwarding
without express permission is strictly prohibited. If you are not the
intended recipient, please contact the sender and delete all copies.

Hauptsitz: Bahnstrasse 37, D-47877 Willich, USt-IdNr.: DE 812 885 664
Kommunikation: Telefon +49 2154 9209-70, Telefax +49 2154 9209-900,
www.xcom.de
Handelsregister: Amtsgericht Krefeld, HRB 10340
Vorstand: Matthias Albrecht, Dirk Franzmeyer, Dr. Rainer Fuchs, Marco
Marty, Dirk Werner
Vorsitzender des Aufsichtsrates: Stefan H. Tarach
                                                                           
             Johan Andersson                                               
             <johan@severalnin                                             
             es.com>                                                    An 
                                        Hendrik Woltersdorf                
             25.11.2010 11:40           <hendrik.woltersdorf@stripped>      
                                                                     Kopie 
                                        cluster@lists.mysql.com            
                                                                     Thema 
                                        Re: reason for slow query ?        
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           




Hi,

Perhaps PRIMARY is not the best index.

Try to use 'tan_list' instead.

SELECT  *  FROM tan_list FORCE INDEX(tan_list) WHERE (SEC_TYPE='Card' AND
TAN_LIST_NUMBER='1' AND USER_ID='1023029' AND CLIENT_ID='1' );

BR
johan

23 nov 2010 kl. 14.16 skrev Hendrik Woltersdorf:

Attachment: [text/html]
Attachment: [text/html]
Attachment: [text/html]
Thread
reason for slow query ?Hendrik Woltersdorf23 Nov
  • Re: reason for slow query ?Johan Andersson25 Nov
    • Antwort: Re: reason for slow query ?Hendrik Woltersdorf25 Nov
      • RE: Antwort: Re: reason for slow query ?Andrew Armstrong25 Nov
        • Antwort: RE: Antwort: Re: reason for slow query ?Hendrik Woltersdorf26 Nov