MYISAM or InnoDB?

[spencer]

MyISAM offers speed, but InnoDB is reliable.
MyISAM is fast, but do not support transactions support.

InnoDB works perfectly fine on many modification of data, because it uses row locking instead of table locking as in MyISAM.

If you need foreign key constraints or transactions, you can only use InnoDB, whereas if you need fulltext indexes, you can only use MyISAM tables

Choose InnoDB, if want multi-statement transactions, advanced isolation levels and row-level locking, foreign key constraints, or go for MyISAM, comparatively used by beginners.

For message board application, here inserts & updates queries are executed a lot of times, then InnoDB would be suitable alternative.

[Christina]

I have noticed that if we use INNODB we lose full text search, and if we use MyISAM we get low performance due to the fact that Innodb is memory based.

[spencer]

Hi,
As I have stated above the features supported by each database engine, its up to the user, what should be chosen. Because requirement varies as per user need.

[Sean]

InnoDC is basically useful if you have your MySQL keeps crashes and myisam tables are with corrupt indexes.