Pick your MySQL storage engine according to the different business requirements. 1. Go with the MyISAM engine
- R/W > 100:1 and relatively few updates.
- Low concurrency, no need for transactions.
- Small amount of table data.
- Limited hardware resources.
- Go with the InnoDB engine
- Small R/W ratio, large fields updated frequently.
- Table data over 10 million rows, high concurrency.
- High security and availability requirements.
- Go with the Memory engine
- Enough memory available.
- Low requirements for data consistency, as with applications like online user counts and Sessions.
- Data that needs to be archived regularly.
