In mysql database which table store as MyISAM type and which table store as InnoDB type ? And Why? <p>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.</p> <p>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. </p>