Database Management MySQL Subjective
Oct 01, 2025

What are MySQL Storage Engines? Name the most common ones.

Detailed Explanation

Storage engines determine how MySQL stores and retrieves data.

Common engines:
InnoDB: Default, supports transactions, foreign keys, row-level locking
MyISAM: Fast reads, table-level locking, no transactions
MEMORY: Stores data in RAM, very fast but volatile
ARCHIVE: Compressed storage for archival data

Example:
CREATE TABLE users (...) ENGINE=InnoDB;
ALTER TABLE logs ENGINE=MyISAM;

Discussion (0)

No comments yet. Be the first to share your thoughts!

Share Your Thoughts
Feedback