MySQL: What is the best partition technique for large InnoDB table (around 1.5M rows) with
TEXT type of column?
There is a
FULLTEXT index on the
TEXT column, which is very essential for my searching operation.
You can't partition an InnoDB table with a fulltext index, which would make intuitive sense, since it's difficult to envision how fulltext searches on (what would presumably be implemented as) multiple underlying fulltext indexes (one for each partition) would be able to give meaningful relevance and query expansion results.
The limitation applies to all storage engines.