DebugQ - De:Bug:Q

Go Back   DebugQ - De:Bug:Q > DebugQ > Linux
FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
Thread Tools Display Modes
  #1  
Unread 09-15-2015, 05:45 AM
Lila Lila is offline
Administrator
 
Join Date: Nov 2007
Posts: 320
Default Difference Between InnoDB and MyISAM

Difference Between InnoDB and MyISAM

Database, Innodb, Myisam, MySQL


- 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.


For more information visit http://dev.mysql.com/


   

Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump


All times are GMT. The time now is 03:08 AM.

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
DebugQ - Debug Quote - De:Bug:Q