MySQL Forums
Forum List  »  Partitioning

Partitioning and Fulltext indexes
Posted by: martin sarsale
Date: January 12, 2007 10:32AM

Dear all:
I'm in the process of developing our new CMS, which will be used by thousands of customers.

I found partitioning to be great for this task since I'm planning to store all the customer's data in some huge tables and using partitioning so a customer with thousands of rows won't affect customers with smaller sites.

While reading the "Restrictions and Limitations" page, I found this:
"Partitioned tables do not support FULLTEXT indexes. This includes partitioned tables employing the MyISAM storage engine."

Why does this limitation exist? Are you planning to add this feature in a near future?


Options: ReplyQuote

Written By
Partitioning and Fulltext indexes
January 12, 2007 10:32AM

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.