Re: What's the best way to implement table partitioning in Mysql

[Mikael Ronström]

David Ma wrote:
Hi,
As Alan mentioned MERGE tables exist in the current version.
There is work ongoing that has implemented range partitioning a la
Oracle, will most likely be available in MySQL 5.1. Hopefully it will be
possible to do source downloads of 5.1 in a not too distant future.

Parallel scans is part of a later work package following up on partitioning
to also implement parallel execution inside queries in MySQL.

Some limited parallel scan facilities have recently been introduced in MySQL Cluster
through pushing down conditions into the NDB handler.

Rgrds Mikael

> What's the best way to implement table
> partitioning in Mysql?
> I'm wondering if mysql can do range-partition like
> oracle does? Thanks
>
> David