CODEWITHSUNDEEP
mysqlperformancefull-text-searchinnodbmyisam
HappyDeveloper
HappyDeveloper

Reputation: 12805

Write speed with MyISAM?

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?

Upvotes: 1

Views: 405

Answers (2)

Mike Lewis
Mike Lewis

Reputation: 64137

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?

Upvotes: 3

WhiteFang34
WhiteFang34

Reputation: 72039

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.

Upvotes: 5

Related Questions