List:Cluster« Previous MessageNext Message »
From:mike Date:January 14 2006 8:54pm
Subject:Re: Hoping to use cluster in 5.1, but have some questions
View as plain text  
Thanks for the reply! A couple followups.

On 1/14/06, Alex Davies <daviesalex@stripped> wrote:
> Full text support is not supported. Full list at
> http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-limitations.html

It also still looks like there is the 8k row size limitation...

> Remember if you are dealing with large databases that Indexes are
> still in-memory.

But that's compressed, right? I could check to see the size of my
existing tables by just looking at how big the .MYI file is? I thought
it was going to *partially* be in memory still not all of it - even
for indexes...

> Once you get above 8 they recommend something other than ethernet to
> connect nodes (SCI interconnects etc.)

What about gigabit ethernet w/ jumbo frames? Still not suggested?

It seems like to get around some of the limitations it would be
suggested to look at table designs and possibly design FOR the
limitations - i.e. split up tables smaller so there's no 8k rows, not
build tables with extensive indexes, etc...

Thanks.
Thread
Hoping to use cluster in 5.1, but have some questionsmike14 Jan
  • Re: Hoping to use cluster in 5.1, but have some questionsAlex Davies14 Jan
    • Re: Hoping to use cluster in 5.1, but have some questionsmike14 Jan
      • Re: Hoping to use cluster in 5.1, but have some questionsAdam Dixon14 Jan