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! >
