From the course: MySQL Installation and Configuration
Join today to access over 24,800 courses taught by industry experts.
MySQL storage engines overview - MySQL Tutorial
From the course: MySQL Installation and Configuration
MySQL storage engines overview
- [Bill] Hi, I'm Bill Wineman. My SQL supports different storage engines through a plugin system. A good selection of alternative storage engines are shipped With My SQL. The show engine statement shows a list of installed storage engines so you can see what's installed on your server. The default storage engine is the InnoDB engine. This is the preferred engine for most purposes. It's fully compliant, supports transactions, rollbacks, roll level locking, and non-locking reads. The MyISAM engine is a legacy engine. This was the default engine before InnoDB. ISAM stands for Indexed Sequential Access Method. This engine is mostly used for legacy applications and applications that require a smaller footprint. The memory engine is useful for temporary objects. It's fast and efficient, but not persistent. The memory engine stores data in RAM, so it's fast, but ephemeral. The CSV engine uses comma separated values in a text file. CSV stands for Comma Separated Values, a popular format for…
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.