Hi, Can i use the default table type as INNODB for all my mysql tables in openser database. Can someone please tell me the fundamental drawback of using innodb type instead of myisam. My only concern is the limitaion of myisam to 4GB which requires continous backup of acc table data as it gets to its limit very soon. I am asking this since openser also specifies the default table type as myisam, so before changing the table type I just needed some expert advice on any performance related issues.
thanks in advance,
w/regards, Jayesh
__________________________________________________________ Yahoo! India Answers: Share what you know. Learn something new http://in.answers.yahoo.com/
Hello,
you can use innodb, there should be no problem. we used them and everything is fine. The drawback is latency, innodb is slower that myisam, but brings additional features, like transactions.
Cheers, Daniel
On 11/20/06 09:55, Jayesh Nambiar wrote:
Hi, Can i use the default table type as INNODB for all my mysql tables in openser database. Can someone please tell me the fundamental drawback of using innodb type instead of myisam. My only concern is the limitaion of myisam to 4GB which requires continous backup of acc table data as it gets to its limit very soon. I am asking this since openser also specifies the default table type as myisam, so before changing the table type I just needed some expert advice on any performance related issues.
thanks in advance,
w/regards, Jayesh
Find out what India is talking about on - Yahoo! Answers India http://us.rd.yahoo.com/mail/in/yanswers/*http://in.answers.yahoo.com/ Send FREE SMS to your friend's mobile from Yahoo! Messenger Version 8. Get it NOW http://us.rd.yahoo.com/mail/in/messengertagline/*http://in.messenger.yahoo.com
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
What about ndbcluster? I would like to use ndbcluster for all tables except acc which would of coarse be too big too quickly. I hope I am not the first to try this.
On Nov 20, 2006, at 5:01 AM, Daniel-Constantin Mierla wrote:
Hello,
you can use innodb, there should be no problem. we used them and everything is fine. The drawback is latency, innodb is slower that myisam, but brings additional features, like transactions.
Cheers, Daniel
On 11/20/06 09:55, Jayesh Nambiar wrote:
Hi, Can i use the default table type as INNODB for all my mysql tables in openser database. Can someone please tell me the fundamental drawback of using innodb type instead of myisam. My only concern is the limitaion of myisam to 4GB which requires continous backup of acc table data as it gets to its limit very soon. I am asking this since openser also specifies the default table type as myisam, so before changing the table type I just needed some expert advice on any performance related issues.
thanks in advance,
w/regards, Jayesh
Find out what India is talking about on - Yahoo! Answers India <http://us.rd.yahoo.com/mail/in/yanswers/*http:// in.answers.yahoo.com/> Send FREE SMS to your friend's mobile from Yahoo! Messenger Version 8. Get it NOW <http://us.rd.yahoo.com/mail/in/ messengertagline/*http://in.messenger.yahoo.com%3E
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users