Search code examples
mysqlfulltext-index

Adding a FULLTEXT index on existing db

I have a MySQL table that has 165,716 records (and counting). The table is 233,3 MB large. Now I want to add a FULLTEXT index to a column in that table. Is that possible, or is it going to be a problem?

Kind regards

Solution

  • It's possible if the table is running the MyISAM engine, but it's likely to take a long time to complete the initial indexing.

    [edit]I misread the size - I thought it was 2.3GB, not 233MB! If that's the case, the indexing shouldn't take that long.