MySQL Forums
Forum List  »  Partitioning

partitioning by highly skewed data
Posted by: Hiroshi Takenaka
Date: June 16, 2005 07:58AM

Will it be possible to partition one specific partiton further?

For example, we have a 1TB table. We want to partition it,
and spread over 10 * 140GB disks using one column.
But, unfortunately, 20% of records have NULL on that column.

It would be nice, if we can partiton those records further
by using another column or some random value.
I think it should be easy if user can define and use
a custom partitioning function.


Options: ReplyQuote

Written By
partitioning by highly skewed data
June 16, 2005 07:58AM

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.