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
>
>
