[Users] innodb tables

Brandon Price brandon at dacrib.net
Mon Nov 20 14:57:55 CET 2006


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>
>> --------------------------------------------------------------------- 
>> ---
>>
>> _______________________________________________
>> Users mailing list
>> Users at openser.org
>> http://openser.org/cgi-bin/mailman/listinfo/users
>>
>
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>
>





More information about the sr-users mailing list