Page 1 of 1
myISAM ? InnoDB?
Posted: 09 Jan 2007, 11:13
by smlp
Hi,
I wonder wich storage engine is recommended - MyISAM or InnoDB (MySql)? Currently, all my mantis tables are MyISAM.
I would suggest myISAM
Posted: 15 Jan 2007, 11:29
by 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.