title: What MYSQL table storage engine do most websites use? One that supports FULLTEXT indexing as well as RELATIONSHIPS?
body: <p>This is what I learnt in one of the posts I read in Stackoverflow.</p>
  
  <p>"First major difference i see is that InnoDB implements row-level lock while MyISAM can do only a table-level lock. You will find better crash recovery in InnoDB. However, it doesn't have FULLTEXT search indexes, as does MyISAM. InnoDB also implements transactions, foreign keys and relationship constraints while MyISAM does not."</p>
  
  <p>Since most sites need relationship between tables as well as a site search, which engine do they use? Which one should I?</p>