Archive for April, 2008

MyISAM or InnoDB?

Wednesday, April 9th, 2008

InnoDB is not always the best choice.

MyISAM locks the whole table to update only one row, so it’s hard when app requires lots of W(or RW): in this case InnoDB is better.

Bottom line:

if the table is mainly R: MyISAM better because faster

if the table is mainly W: InnoDB better because faster