For every "INSERT INTO sent_sms" query Rows_examined: 2413989 a fix number.
abhi On Tue, May 5, 2015 at 11:58 AM, Alok Srivastava <alok...@gmail.com> wrote: > 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 >
