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.