List:Cluster« Previous MessageNext Message »
From:Ridd1ck Date:November 29 2011 8:08am
Subject:Re: My SQL Cluster Queries Optmization
View as plain text  
 explain  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;

+----+-------------+-------+--------+-----------------------------------------+---------------+---------+------+-------+-------------+
| id | select_type | table | type   | possible_keys                          
| key           | key_len | ref  | rows  | Extra       |
+----+-------------+-------+--------+-----------------------------------------+---------------+---------+------+-------+-------------+
|  1 | SIMPLE      | mt    | range  |
session_esme,msg_timestamp,w2sms_client | msg_timestamp | 4       | NULL |
51288 | Using where |
|  1 | SIMPLE      | http  | eq_ref | PRIMARY                                
| PRIMARY       | 114     | func |     1 |             |
+----+-------------+-------+--------+-----------------------------------------+---------------+---------+------+-------+-------------+
2 rows in set (0.00 sec)

--
View this message in context:
http://mysql-cluster.1050023.n4.nabble.com/My-SQL-Cluster-Queries-Optmization-tp4115737p4118348.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