Typo3 and Joomla in china

Notes on Storage Engine

Jul 23, 2010 Database
Posted by admin

1.The MyISAM Storage Engine

• Table locks
• No automated data recovery
• No transactions
• Only indexes are cached in memory
• Compact storage

2.The memory storage Engine

• Table locks
• No dynamic rows(no BLOB  and TEXT , even VARCHAR)
• Hash indexes are the default index type
• No index statistics
• Content is lost on restart

3.The InnoDB Storage Engine

• Transactional
• Foreign keys
• Row-level locks
• Multiversioning
• Clustering by primary key
• All indexes contain the primary key columns
• Optimized caching
• Unpached indexes
• Slow data load
• Blocking AUTO_INCREMENT
• No cached COUNT(*) value