List:Cluster« Previous MessageNext Message »
From:Wagner Bianchi Date:November 28 2011 4:28pm
Subject:Re: My SQL Cluster Queries Optmization
View as plain text  
Here we go with some basic hints:

   1. Have you enabled Engine Condition
Pushdown<http://dev.mysql.com/doc/refman/5.1/en/condition-pushdown-optimization.html>?
   (
   http://dev.mysql.com/doc/refman/5.1/en/condition-pushdown-optimization.html
   )
   2. Have you ran that query using EXPLAIN?

Best wishes,
--
*Wagner Bianchi*


2011/11/28 Ridd1ck <Ridd1ck.ste@stripped>

> 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.
>
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe:    http://lists.mysql.com/cluster
>
>

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