MySQL Storage engine (engine: Processor for processing tables)

1, the basic Operation command:
1. View all Storage engines
Show engines;
2, view the existing table storage engine;
Show create table table name;
3. Create the storage engine specified by the table
CREATE TABLE table name (...). ) Engine=myisam,charset=utf8;
4. Existing tables change the storage engine
ALTER TABLE name engine = MyISAM
2, the characteristics of common storage engine:
1. InnoDB Features
1, support transactions, foreign keys, row-level locks
2. Shared tablespace (path:/var/lib/mysql)
Table name. frm: Table structure and index information
Table name. IBD: Table Record
2. MyISAM Features
1, Support table-level lock
2. Exclusive table Space
Table name. frm: Table structure
The table name. MYD: (mydata) Table record
The table name. MYI: (myindex) index information
3. Memory Memory engine
1. Data stored in memory, fast
2, the server restarts, the MySQL service restarts after the table record disappears
3. How to decide which storage engine to use
1. Use MyISAM (waste resources using INNODB) to perform query operations with multiple tables
2. Use InnoDB to perform multiple write operations

MySQL Storage engine (engine: Processor for processing tables)