Try to make the sent_sms table of type innodb, in stead of myisam. myisam locks the entire table upon an insert.
Let the list know, if that made a difference. == Rene From: users [mailto:users-boun...@kannel.org] On Behalf Of Alok Srivastava Sent: dinsdag 5 mei 2015 8:44 To: users@kannel.org Subject: Re: rows examined is too high 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
