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