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
