We are using InnoDB. It works just fine with dlr and send_sms, sent_sms tables. InnoDB comparing to MyISAM is more fault proof, so I'd recommend using it, every insert is a transaction, so theoritacally you won't lose more than 1 transaction if something bad happens.
Don't forget to add relevant indexes for speeding up queries from dlr table. 2012/3/22 Ashish Agarwal <ashisha...@gmail.com> > Hello, > > I wish to know what is the suitable mysql engine(MYISAM or INNODB) for dlr > and sqlbox (send_sms and sent_sms table) from kannel. I currently have high > load of traffic and RAM is not a problem. > > Please suggest. > > -- > Regards, > > Ashish >
