content_image/811860.jpg
## Chapter 16 Alternative Storage Engines 

## Table of Contents 

<img src='content_image/811860.jpg'>

Storage engines are MySQL components that handle the SQL operations for different table types. InnoDB is the default and most general-purpose storage engine, and Oracle recommends using it for tables except for specialized use cases. (The CREATE TABLE  statement in MySQL 8.0 creates InnoDB  tables by default.) 

MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and unloaded from a running MySQL server. 

To determine which storage engines your server supports, use the SHOW ENGINES  statement. The value in the Support  column indicates whether an engine can be used. A value of YES , NO , or DEFAULT indicates that an engine is available, not available, or available and currently set as the default storage engine. 

mysql> SHOW ENGINES\G *************************** 1. row *************************** Engine: PERFORMANCE_SCHEMA Support: YES Comment: Performance Schema Transactions: NO XA: NO Savepoints: NO *************************** 2. row *************************** Engine: InnoDB Support: DEFAULT 

