From the course: MySQL Installation and Configuration
Join today to access over 24,800 courses taught by industry experts.
MyISAM - MySQL Tutorial
From the course: MySQL Installation and Configuration
MyISAM
- [Bill] Hi, I'm Bill Weinman. The MyISAM engine is a legacy engine mostly used for compatibility with older versions of MySQL. This was the default engine before MySQL 5.5, released in December, 2010. ISAM stands for Indexed Sequential Access Method, a technique that dates back to IBM mainframe databases in the 1970s. The MyISAM engine does not support transactions nor foreign keys, its only locking mechanism locks an entire table at a time. It is sometimes used for write once, read many operations, like data warehousing, where writes are rare and fast-indexed read operations are important, although other alternatives may be more robust. The MyISAM engine was the default MySQL database engine before the release of MySQL 5.5 in December, 2010. Because of its large installed base, the MyISAM engine is well maintained and there are many tools available for maintenance and support.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.