Have heard about InnoDB and MyIASM? Which one is best?

1. InnoDB supports transaction while MyIASM doesn't.

   2. InnoDB facilitates row-level locking while MyIASM has table-level locking

   3.  For higher volume, InnoDB provides very high performance.


Above 3 are major difference of the two major engines.


There is a myth that MyIASM is faster than InnoDB which is not completely true as InnoDB stores its tables and indexes in a table-space, which may consist of several files (or raw disk partitions). This is different from, for example, MyIASM tables where each table is stored using separate files. So the lookup is faster in InnoDB than MyIASM.

Make your best judgment considering data integrity as one of the important points!