I don't think you can set auto removal.. You have to do it manually.... It is better to clear it for fast dlr receival
-----Original Message----- From: "christopher kamutumwa" <chriskamutu...@gmail.com> Sent: 08-07-2017 12:35 To: "robin c" <ro...@zincron.co.in> Cc: "users" <users@kannel.org> Subject: Re: HUGE DRL QUEUE MYSQL STORAGE thanks for your response.I would like to know what effects this might have when the DB is that big? and does it mean that its failing to match dlrs from operator. is their a validity period i can put in kannel configuration so that it auto removes sort of a validation period chris On Sat, Jul 8, 2017 at 6:32 AM, robin c <ro...@zincron.co.in> wrote: That dlrs are being stored in ur MySQL.. In ur configuration u might have given a table in sms_dlr data table. When we send a message there will be an entry in that table... It will get updated only when we receive d dlr of that message from the operator. Otherwise it will be on that queue only. You can clear that queue by deleting the entry from that table. From: christopher kamutumwa Sent: 08-07-2017 06:38 To: users Subject: HUGE DRL QUEUE MYSQL STORAGE Hello Team I have DLRs being queued which seems to be big as below status in Kannel; My query is what causes this? and how can i resolve queue issue? any assistance would be of great help DLR: received 41, sent 0 DLR: inbound (0.01,0.00,0.01) msg/sec, outbound (0.00,0.00,0.00) msg/sec DLR: 753643 queued, using mysql storage Regards, Chris