1

I have this big table which I want to have fulltext search, so I made it MyISAM, as InnoDB doesn't support that.

Am I gonna have performance issues if I write a lot to that table? I have been told that MyISAM locks the whole table during writes.

Do I have any other option if I need both fulltext search and non-locking write?

HappyDeveloper
  • 12,480
  • 22
  • 82
  • 117

2 Answers2

5

If you write a lot to a MyISAM table you'll eventually have locking issues that you wouldn't with InnoDB. I recommend looking into other options for full-text search, e.g. Lucene or Solr that are both accessible from a number of languages now. See Lucene Tutorial to get started.

WhiteFang34
  • 70,765
  • 18
  • 106
  • 111
3

If you are OK with 3rd party solutions(that work with your MySQL database), I'd highly suggest Sphinx to handle your fulltext search. As you can see on their website, it is highly endorsed by the community and very supported in terms of application level interaction.

There are of course other solutions other than Sphinx, in which you can see a fantastic SO discussion comparing them here:

Choosing a stand-alone full-text search server: Sphinx or SOLR?

Community
  • 1
  • 1
Mike Lewis
  • 63,433
  • 20
  • 141
  • 111