not quite sure about this, we are using 10. the speed mostly depends on your smsc provider(s) actually
2012/3/22 Ashish Agarwal <[email protected]> > And how much concurrent connection i.e. max-connection is recommended for > high traffic when using innodb. > > > On Fri, Mar 23, 2012 at 12:59 AM, spameden <[email protected]> wrote: > >> mysql> show indexes from kannel.dlr; >> >> +-------+------------+---------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ >> | Table | Non_unique | Key_name | Seq_in_index | Column_name | >> Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | >> Index_comment | >> >> +-------+------------+---------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ >> | dlr | 0 | smsc_ts_destination | 1 | smsc | >> A | 1 | 15 | NULL | YES | BTREE | >> | | >> | dlr | 0 | smsc_ts_destination | 2 | ts | >> A | 9408 | 35 | NULL | YES | BTREE | >> | | >> | dlr | 0 | smsc_ts_destination | 3 | destination | >> A | 9408 | 11 | NULL | YES | BTREE | >> | | >> | dlr | 0 | url | 1 | url | >> A | 9408 | 16 | NULL | YES | BTREE | >> | | >> >> +-------+------------+---------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ >> 4 rows in set (0.02 sec) >> >> CREATE index smsc_ts_destination ON dlr (smsc(15), ts(35), >> destination(11)) >> CREATE index url ON dlr (url(16)) >> >> >> 2012/3/22 Ashish Agarwal <[email protected]> >> >>> Hello, >>> >>> Thanks for your response. What are the fields that should be indexed? >>> >>> >>> On Fri, Mar 23, 2012 at 12:54 AM, spameden <[email protected]> wrote: >>> >>>> 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 <[email protected]> >>>> >>>>> 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 >>>>> >>>> >>>> >>> >>> >>> -- >>> Regards, >>> >>> Ashish Agarwal >>> >> >> > > > -- > Regards, > > Ashish Agarwal >
