MySQL Forums
Forum List  »  Partitioning

Re: Partitioning with ndb cluster engine
Posted by: Mikael Ronström
Date: April 04, 2007 12:36AM

Hi,
Partition by HASH, RANGE and LIST are considered beta-features of
MySQL 5.1. Beta-features are activated by starting the MySQL server
with --new and then the below command will be possible. Personally
I always use this. I am doing a lot of DBT2 benchmarking where
PARTITION BY HASH is the default method of partitioning for the
MySQL Cluster tables. I don't know of any quality issues related
to PARTITION BY HASH.

Rgrds Mikael

Johan Jerräng Wrote:
-------------------------------------------------------
> Hi!
>
> I was trying to create a table with partitioning
> on the ndb cluster engine, according to the
> manual:
> http://dev.mysql.com/doc/refman/5.1/en/partitionin
> g-hash.html
>
> I get the following error:
> mysql >CREATE TABLE employees (
> -> id INT NOT NULL,
> -> fname VARCHAR(30),
> -> lname VARCHAR(30),
> -> hired DATE NOT NULL DEFAULT
> '1970-01-01',
> -> separated DATE NOT NULL DEFAULT
> '9999-12-31',
> -> job_code INT,
> -> store_id INT
> -> )
> -> PARTITION BY HASH(store_id)
> -> PARTITIONS 4;
> ERROR 1005 (HY000): Can't create table
> 't1.employees' (errno: 138)
>
> Which seems to mean "MySQL error code 138:
> Unsupported extension used for table"
> Anyone got any idea?
>
> The have_partitioning variable is set to YES and
> I'm using MySQL version 5.1.14.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Partitioning with ndb cluster engine
3921
April 04, 2007 12:36AM


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.