MySQL Forums :: InnoDB :: innodb or myisam for logging


Advanced Search

innodb or myisam for logging
Posted by: bharath venk ()
Date: June 12, 2009 07:58AM

HI,
we are using mysql for our ad network .we have some where around 6 -9 million impression per day and for logging purpose for every impression and clicks there is a row inserted . So I am thinking of using mysiam for logging purposes I think it would give better performance than innodb as no other operation happens other than inserts . selects happens only in slave for summarization of impressions and clicks. and also I heard Innodb would perfom quite well in computers which has good resources such as memory . our machines have 16-32 Gb ram which is quite good .. so I am little confused what to use . whether to use Innodb or myissam with delayed write . can pls suggest me what engine and what configuration to go for this purpose and how much difference would it make if we go the other way

Thanks in Advance,
Bharath

Options: ReplyQuote


Subject Views Written By Posted
innodb or myisam for logging 3044 bharath venk 06/12/2009 07:58AM
Re: innodb or myisam for logging 2812 Rick James 06/13/2009 10:11AM
Re: innodb or myisam for logging 2422 bharath venk 06/16/2009 01:33AM
Re: innodb or myisam for logging 2131 Rick James 06/16/2009 10:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.