myISAM ? InnoDB?

[smlp]

Hi,

I wonder wich storage engine is recommended - MyISAM or InnoDB (MySql)? Currently, all my mantis tables are MyISAM.

[jotango]

The feature I use InnoDB for mostly are transactions. myISAM tends to be faster for frequent read-seldom write applications, InnoDB for frequently updated tables (because of the row vs. table level locking).

Since (AFAIK) mantis does not use transactions, this feature is useless. I would suggest staying with myISAM. If you see locking on certain tables often you could try changing that table to InnoDB.