In order to help you select the correct storage engine for your implementation of MySQL, simply define your requirements below and we will suggest a storage engine to suit your needs:

1.	My application uses transactions/rollback:	Yes No
2.	My application uses foreign Key Constraints:	Yes No
3.	Locking Level:	Row-Level Table-Level
4.	Materialized Views (Faster Joins):	Yes No
5.	I want to avoid partitioning my data:	Yes No
6.	My application uses long keys (URLs):	Yes No
7.	ACID Compliance Required:	Yes No
8.	Full-Text Indexing:	Yes No
9.	Clustering Integrated:	Yes No

Features Supported…	ScaleDB	InnoDB	MyISAM	Memory	NDB
Transactions with rollback	Yes	Yes	No	No	Yes
Foreign key constraints	Yes	Yes	No	No	No
Locking level	Row	Row	Table	Table	Row
Materialized views (faster joins)	Yes	No	No	No	No
Eliminates data partitioning	Yes	No	No	No	No
High-performance for long keys	Yes	No	No	No	No
ACID compliance	Yes	Yes	No	No	No
Full-text indexing	No	No	Yes	No	No
Clustering integrated	Yes	No	No	No	Yes

• Contact Us
• Company Blog