- The big difference between MySQL Table Type MyISAM and InnoDB is that InnoDB supports transaction
- InnoDB supports some newer features: Transactions, row-level locking, foreign keys
- InnoDB is for high volume, high performance
Most people use MyISAM if they need speed and InnoDB for data integrity. You can use more than one or any combination of these table types in your database. Remember to asses the needs of your application before building it. Even though MyISAM is faster than InnoDB in the MySQL world, InnoDB is fast compared to any database engine.With InnoDB you get transactions, speed and integrity three features not usually used in the same sentence.
InnoDB has been designed for maximum performance when processing large data volumes. Its CPU efficiency is probably not matched by any other disk-based relational database engine.
Fully integrated with MySQL Server, the InnoDB storage engine maintains its own buffer pool for caching data and indexes in main memory. InnoDB stores its tables and indexes in a tablespace, which may consist of several files (or raw disk partitions). This is different from, for example, MyISAM tables where each table is stored using separate files. InnoDB tables can be of any size even on operating systems where file size is limited to 2GB.
So, what do you think about those engines?? Please feel free to discuss it.
For more information visit http://dev.mysql.com/
Thanks
totally bingo said
totally bingo
totally bingo
sripathi said
i need more information about those structures and transactions, like which best for tractions…..
senthil said
Since we have higher performance with added features in Innodb than myISAM .why should we have it seperated ? rather than giving Innodb as updated version of myISAM . Any how people going to use Innodb only. why does myISAM still exist?
Difference Between InnoDB and MyISAM | Vadim Gabriel said
[...] reading Tapos Blog post about the differences between InnoDB and MyISAM database engines i found out that InnoDB does not [...]
Matthew Mihok said
MyISAM databases support the MATCH and AGAINST keywords for searching, very useful for that purpose, but the InnoDB offers better speed and space consumption.
Sitthykun said
can you tell me, what size of the maximum storage of MySQL?
both innodb and myisam.
cheer!
Joey said
My experience with MyISAM and InnoDB, is that MyISAM is optimal for big nasty logs and/or if you need to do a relevancy-relied full text search (as another author stated, with the help of MATCH and AGAINST). This compared to InnoDB that is optimal when it comes to handling and storing integers, using transaction-critical applications, etc.
Oh, and a protip to all developers: when logging things, make it log things efficient; don’t make the table bigger than it needs to be. Start by using INET_ATON to store IP-adresses as 32-bit integers instead of 16 digit char. Always mind the scale of volumes for those poor DBA’s sake
Also, check out the facebook-patch for InnoDB – they’ve really made some cool optimizations worth checking out.
cheers
/Joey