Re: NDB Partitioning - Moon's Father - com.mysql.lists.cluster

7 messages in com.mysql.lists.clusterRe: NDB Partitioning

From	Sent On	Attachments
Jake Conk	05 Feb 2008 22:18
Jason Brooke	05 Feb 2008 22:20
Martin Skold	07 Feb 2008 03:35
Jake Conk	07 Feb 2008 17:55
Mikael Ronström	08 Feb 2008 01:41
Moon's Father	12 Feb 2008 01:41
Mikael Ronström	12 Feb 2008 02:13

Subject:	Re: NDB Partitioning
From:	Moon's Father (yuel...@gmail.com)
Date:	02/12/2008 01:41:05 AM
List:	com.mysql.lists.cluster

It's not a nice idea to use partition in your product.

On Feb 8, 2008 5:42 PM, Mikael Ronström <mik...@mysql.com> wrote:

Hi,

8 feb 2008 kl. 02.56 skrev Jake Conk:

Hello,

I looked in the MySQL documentation for 5.1 and it doesn't say they will have range and list features for 5.1.

Based on this page in the 5.1 documentation <http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations- storage-engines.html> it says that 5.1 will only have key partitioning.

Can you elaborate a little bit more on what you mean by them being unsupported beta features and do you think they will be supported features when 5.1 comes out or are they only working on them for 6.0 or some other release?

It means that they work but aren't supported, and to use them you need to start the server with --new (for using new unsupported features).

Rgrds Mikael

Thank you,

- Jake

On Feb 7, 2008 3:35 AM, Martin Skold <Mart...@mysql.com> wrote:

Hi!

Range and list partitioning are unsupported beta features in 5.1, see test cases in test suite.

BR -- Martin

Not exactly like you can with MyISAM, no http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations- storage-engines.html

some other info here: http://mikaelronstrom.blogspot.com/2005/10/default-partitioning- of-mysql-cluster.html

Jake Conk wrote:

Can I partition an NDB table like I could with MyISAM tables? I looked this up but I didn't see it anywhere regarding ndb tables.

Thanks, - Jake