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.
