List:Cluster« Previous MessageNext Message »
From:Ridd1ck Date:November 28 2011 4:10pm
Subject:My SQL Cluster Queries Optmization
View as plain text  
I have one mysql cluster with 2 data nodes and 2 api nodes,
I have a web application that use big select statement like this:
SELECT mt.smpp_source_add,
 mt.msg_id,
 mt.msg_smsc_id,
 mt.default_smsc,
 mt.msg_smsc_id,
 mt.ported_smsc1,
 mt.ported_smsc2,
 mt.smpp_destination_addr,
 mt.state,mt.session_esme,
 mt.hlr_location,
 mt.hlr_state,
 mt.msg_timestamp,
 mt.state_timestamp,
 mt.msg_meta_data,
 mt.pb_id,
 mt.w2sms_client,
 http.ClientID as http_client 
 FROM MT as mt LEFT JOIN http_MT as http ON http.MT_ID=mt.msg_id 
 WHERE (mt.msg_timestamp BETWEEN '1322085600' AND '1322171999' ) AND 
 (mt.session_esme='-1' OR mt.w2sms_client='') AND 
 mt.smpp_destination_addr LIKE '%' AND mt.smpp_source_add LIKE '%' AND
mt.msg_id LIKE '%' ORDER BY mt.msg_timestamp DESC


and is really slow with cluster,
can you help me to optimize thsi Query?
Thanks.

--
View this message in context:
http://mysql-cluster.1050023.n4.nabble.com/My-SQL-Cluster-Queries-Optmization-tp4115737p4115737.html
Sent from the MySQL - Cluster mailing list archive at Nabble.com.
Thread
My SQL Cluster Queries OptmizationRidd1ck28 Nov
  • Re: My SQL Cluster Queries OptmizationWagner Bianchi28 Nov
    • Re: My SQL Cluster Queries OptmizationRidd1ck28 Nov
      • Re: My SQL Cluster Queries OptmizationJohan Andersson28 Nov
        • Re: My SQL Cluster Queries OptmizationWagner Bianchi28 Nov
          • Re: My SQL Cluster Queries OptmizationRidd1ck29 Nov
            • Re: My SQL Cluster Queries OptmizationWagner Bianchi29 Nov
              • Re: My SQL Cluster Queries OptmizationRidd1ck29 Nov