There are two types of database engine in mysql..
You must have the understanding of when to use InnoDB and when to use MyISAM..
here I am going to describe the both MyISAM and InnoDB database engines with their limitations, It will help you to understand when to use MyISAM and when to use InnoDB.
Row limit of 4,284,867,296 rows
Maximum of 64 indexes per row
No Foriegn keys and cascading deletes and updates
No rollback abilities
No transactional integrity (ACID compliance)
No full text indexing
Cannot be compressed for fast, read-only
When to use MyISAM?
MyISAM is designed with the idea that your database is queried far more than its updated and as a result it performs very fast read operations. If your read to write(insert|update) ratio is less than 15% its better to use MyISAM.
When to use InnoDB?
InnoDB uses row level locking, has commit, rollback, and crash-recovery capabilities to protect user data. It supports transaction and fault tolerance.