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 >
