Re: Convert existing table to partitioned ones

[Allan Kelly]

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.