Dear List My server's mysql load is too high. When i tried to examine slow query log there is a big number of rows_examined like 2413989 in slow query log, when data insert to sent_sms table. while presently there r few thousands of records in sent_sms table. Here is slow quey log entry..........Please give me any solution why rows_examined is too high.
# User@Host: smppdb[smppdb] @ localhost [] # Query_time: 9.465214 Lock_time: 0.000099 Rows_sent: 0 Rows_examined: 2413989 SET timestamp=1430806525; INSERT INTO sent_sms ( sql_id, momt, sender, receiver, udhdata, msgdata, time, smsc_id, service, account, sms_type, mclass, mwi, coding, compress, validity, deferred, dlr_mask, dlr_url, pid, alt_dcs, rpi, charset, boxc_id, binfo, meta_data ) VALUES ( NULL, 'DLR', 'KAIZEN', '919585965215', NULL, 'id:9b1e98ab-398d-4d35-8127-4f3b47f52773 sub:000 dlvrd:001 submit date:150505114440 done date:150505114449 stat:DELIVRD err:000 text:', 1430806490, 'GAirtel', 'osm-tid', 'jintly', 3, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'http%3A%2F%2F121.160.153.187%2F%3Fdlrstring%3D%25a%26refid%3DFyBkOdbJezCXukaW', NULL, NULL, NULL, NULL, 'sqlbox', NULL, '?smpp?dlr_err=000&'); # Time: 150505 11:45:35 Regards Abhi
