The index on 'id' won't help you a lot. How many entries are there typically in that table?
Having said that... sqlbox doesn't use the dlr table at all. So it's not your problem. == Rene -----Original Message----- From: users [mailto:[email protected]] On Behalf Of dorin Sent: donderdag 14 november 2013 12:12 To: spameden Cc: [email protected] Subject: Re: Big problem with sqlbox Thanks spameden for your reply "first of all what's the kannel/sqlbox version you're running?" I'm using kannel - 1.5 and sqlbox - I'm not really sure, I think 0.7; "you might need to tweak some settings. " Really I had set MyIsam all kannel tables. I have changed from MyIsam to InnoDb. Will familiarize soon with MariaDB too. Do you mean only these two tweaks? "check indexes on dlr table as well."I have indexed id column. Here is my dlr table CREATE TABLE IF NOT EXISTS `kannel_dlr`( `id` INT(11) NOT NULL AUTO_INCREMENT, `smsc` VARCHAR(40) DEFAULT NULL, `ts` VARCHAR(40) DEFAULT NULL, `destination` VARCHAR(40) DEFAULT NULL, `source` VARCHAR(40) DEFAULT NULL, `service` VARCHAR(40) NOT NULL, `url` VARCHAR(255) DEFAULT NULL, `mask` INT(10) DEFAULT NULL, `status` VARCHAR(40) DEFAULT NULL, `boxc` VARCHAR(40) DEFAULT NULL, `CampaignID` INT(11) NOT NULL, `RelOwnerUserID` INT(11) NOT NULL, `RelOperatorID` INT(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), UNIQUE INDEX UK_oempro_kannel_dlr_id (id) ) ENGINE = INNODB DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1; On 14.11.2013 12:28, spameden wrote: > first of all what's the kannel/sqlbox version you're running? > > check your mysql setup, you might need to tweak some settings. > > i'm strongly suggest using InnoDB instead of MyISAM, also take a look > at MariaDB (it's a fork of mysql, very nicely working). > > check indexes on dlr table as well. > > we've been using kannel to send about millions of sms messages daily > (MT) without any problems. > > 2013/11/14 dorin <[email protected]>: >> Hello all! >> I have a big problem ! >> >> I need to send via KANNEL 5000 of SMS. >> >> When I insert into table kannel_sqlbox_send_sms every minute 10 SMS - >> all works fine. But this method is very slow If I try to increase >> inserting SMS, for example (100SMS) MySql stops working and I got >> this error: >> >> MySQL Error: MySql Error: Couldn't connect to database - Lost >> connection to MySQL server at 'reading initial communication packet', >> system error: 111 >> >> In ideal I wish to do one insert with 5000 rows >> >> Memory,Proccessor is not loaded. >> My configuration is SMSBox+SQLBox+BearerBox; >> >> Please give me some Ideas! >> >
