1. MyISAM: MyISAM is the default storage engine in MySQL. It is a non-transactional storage engine that supports table-level locking. Example: MyISAM is used for data warehousing and web applications.
2. InnoDB: InnoDB is a transactional storage engine that supports row-level locking. It is the most popular storage engine for transactional applications. Example: InnoDB is used for online transaction processing (OLTP) applications.
3. Memory: Memory is a storage engine that stores data in memory. It is a non-transactional storage engine that supports table-level locking. Example: Memory is used for temporary tables and for high-performance applications.
4. Archive: Archive is a storage engine that stores data in a compressed format. It is a non-transactional storage engine that supports table-level locking. Example: Archive is used for storing historical data.
5. CSV: CSV is a storage engine that stores data in comma-separated values (CSV) format. It is a non-transactional storage engine that supports table-level locking. Example: CSV is used for importing and exporting data.