Possible Duplicate:
MySql: MyISAM vs. Inno DB!
I am implementing a blog in php using MySql.
Not all engines support special field types, as BLOB (binary large object) or TEXT types, which I need to use a lot.
Furthermore I will heavily need to manage comments to posts, and different possible archives of posts, using foreign key mechanism.
Which database storage engine (MyISAM, InnoDB,..) is it best to use in terms of efficiency and functionalities?
I'd recommend InnoDB over MyISAM, because of better transactional properties. Inno would be a little slower when it comes to writing, but your data is safer, and it's not that you're gonna write 5000 records a minute.
Some software (like MediaWiki and I think WordPress too) mix up the types. They use Inno for all relations and meta data, and keep a separate table for content fields, which are stored in a MyISAM table, because it allows using FULLTEXT indexes. But this is a workaround as well. Better use Inno all the time. If you need advanced searching, use a separate seach engine like Sphinx.