Advantages and disadvantages of InnoDB and MyISAM

	Advantages	Disadvantages
InnoDB	§  Transaction support §  Locking records §  It allows us to have the ACID characteristics (Atomicity, Consistency, Isolation and Durability: Atomicity, Consistency, Isolation and Durability in Spanish), guaranteeing the integrity of our tables. §  It is likely that if our application makes high use of INSERT and UPDATE we will notice an increase in performance with respect to MyISAM.	§  As a disadvantage, we note that as it is a type of engine that defines a more complex table design system, it reduces performance in speed for developments that require a high number of queries.
MyLSAM	§  Greater speed in general when recovering data. §  Recommended for applications in which SELECT statements dominate over INSERT / UPDATE. §   Absence of atomicity characteristics since it does not have to do referential integrity checks, nor lock the tables to perform the operations, this takes us, like the previous points, to greater speed.	§  As a disadvantage, we point out that it does not perform table locking, this can be a problem if, as mentioned above, there is simultaneous access to record keeping by several users.

 

 

In MySQL 5.0, InnoDB is included by default in binary distributions. The Windows Essentials installer configures InnoDB as the default MySQL database type on Windows. InnoDB is used in many large database sites that need high performance. The famous Internet news site Slashdot.org runs on InnoDB. Mytrix, Inc. stores over 1TB of data in InnoDB, and other sites handle an average load of 800 inserts and updates per second in InnoDB.

InnoDB is released under the same GNU GPL Version 2 license (June 1991) as MySQL. For more information about MySQL licensing.  

See here for more information