I am using Both types in my database. And Found information regarding these two types as i given following :
1. InnoDB locks the particular row in the table, and MyISAM locks the entire MySQL table.
2. MyISAM is the original storage engine. It is a fast storage engine. It does not support transactions.
3. InnoDB is the most widely used storage engine with transaction support. It is an ACID compliant storage engine.
So, I am confused on which table store as MyISAM type and which table store as InnoDB type in My database.
Please provide suggestion to me.
InnoDB are two database engines, and they both are better in their aspects.
MyISAM works best on non-transactional purpose such as where you need
InnoDB works better where you use transaction such as
The main difference between
MyISAM is transaction and referential integrity
They are both better in their own design goals.