MySQL Forums
Forum List  »  Partitioning

Re: Convert existing table to partitioned ones
Posted by: Allan Kelly
Date: May 29, 2009 04:16PM

From the manual page referenced previously in the thread:
Quote

CREATE TABLE t1 (
    id INT,
    year_col INT
);

This table can be partitioned by HASH, using the id column as the partitioning key, into 8 partitions by means of this statement:
ALTER TABLE t1
    PARTITION BY HASH(id)
    PARTITIONS 8;

I've lifted my FULLTEXT index out of a 250,000 row table into a dedicated table. (Partitioning does not work with FULLTEXT). I'm now going to use the above code to partition the original table.

I'll try to report back....

Cheers, al.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Convert existing table to partitioned ones
3439
May 29, 2009 04:16PM


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.