Which database storage-engine is best for implementing a blog? [duplicate]

This question already has answers here: Closed 11 years ago.

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 storag开发者_开发问答e 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.