MySQL Storage Engines

MySQL Storage Engines:

Keywords: MySQL Storage Engines, Storage Engines, Blackhole Storage Engine, Memory (Formerly Heap) Storage Engine, MyISAM Storage Engine, InnoDB Storage Engine, Merge Storage Engine, Example Storage Engine 

MyISAM Storage Engine: 

·  MyISAM tables are very fast if insertion queries are lesser than select queries made. It has the built-in indexing option which will fasten the query's response time than any other table type

When to use:

·  Use MyISAM table type where select statements (preferably more with where clauses) are made often than Insert/Update Statements.

·  Use MyISAM table type if you want lesser disk space than any other mysql storage engine.

InnoDB Storage Engine:

·         InnoDB tables are transaction enabled mysql storage engine type.

·         An InnoDB table allows you to do concurrent read & write statements as it supports row level locking.

When to Use:

·         Use InnoDB table type where transactions like rollback and commit are required (especially shopping cart kinda applications)

·         Use InnoDB table type where insert & update statements are made often than select statements. 

Keywords: MySQL Storage Engines, Storage Engines, Blackhole Storage Engine, Memory (Formerly Heap) Storage Engine, MyISAM Storage Engine, InnoDB Storage Engine, Merge Storage Engine, Example Storage Engine 

Blog Not yet Completed (Will be updated periodically) :-)