From the course: MySQL Installation and Configuration
Join today to access over 24,800 courses taught by industry experts.
InnoDB - MySQL Tutorial
From the course: MySQL Installation and Configuration
InnoDB
- [Bill] Hi, I'm Bill Weinman. The InnoDB engine is the default storage engine for modern versions of MySQL. InnoDB is a general purpose storage engine designed for high performance and high reliability. This engine will be the best choice for the vast majority of applications. The InnoDB engine is fully ACID compliant. ACID stands for atomicity consistency, isolation, and durability. This is the standard for modern database reliability. ACID compliance means that a database engine is capable of guaranteeing the integrity of database transactions. Whether a transaction successfully completes or fails, the database remains in a current and usable state. Row-level locking allows multiple read and write operations to occur simultaneously on different rows in the same table without impacting database integrity nor performance. Foreign key constraints ensure that disparate inserts and updates do not result in inconsistencies across related tables in a data set, InnoDB provides…
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.