Iv. MySQL Architecture

MySQL Architecture
Connection pooling Management tool SQL Interface Analyzer optimizer cache storage engine file system


What is a storage engine
processors with different types of tables, different storage engines have different functions and storage methods

Available as pluggable components
Responsible for performing the actual data I/O operations for the database, different storage engines, and the way they store data
The user accesses the MySQL database through the connector, and according to the actual need to choose which kind of storage engine, avoids the big coding change

The default storage engine
MySQL 5.0/5.1:myisam
MySQL 5.5/5.6:innodb

What storage engines does MySQL support? Show engines;

What are the common storage engines? Myiasm InnoDB

What are the characteristics of common storage engines?

Myiasm
Exclusive table Space
USER.FRM user. MYD user. MYI
Table Structure Data index information
Transaction not supported
Table-Level Locks

InnoDB
Shared table Spaces
A.frm A.IBD
Table structure Data + index information

Support for transactional transaction rollback foreign keys
Transaction log
Ibdata1
Ib_logfile0
Ib_logfile1
Transaction? The process of a SQL operation from start to finish


To view available storage engine types
Show engines;

Manually specify when a table is built
CREATE TABLE Baitao (LF int (3)) Engine=innodb;
Change the storage engine for an existing table
ALTER TABLE Baitao Engine=myisam;

Set the default storage engine
Modifying the/ETC/MY.CNF configuration file
Default-storage-engine=xxx

This article is from the "Zhengerniu" blog, make sure to keep this source http://liufu1103.blog.51cto.com/9120722/1656827

Iv. MySQL Architecture