# 16.11 MySQL逻辑架构

## mysql架构

mysql架构分为三层：

1. 服务层：为客户请求做连接处理、授权认证、安全等
2. 核心层：查询解析，分析，优化，缓存，所有内建函数；存储过程，触发器，视图等
3. 存储引擎层：存储和提取数据以及事务处理

![](https://2471267620-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LfNyxSFSDaHeCRaQx74%2F-M0cMS9didzV-TDioQ9-%2F-M0cMUow34lwkDSErYGz%2F1.png?generation=1582298962186682\&alt=media)

### 服务层

​ ![](https://2471267620-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LfNyxSFSDaHeCRaQx74%2F-M0cMS9didzV-TDioQ9-%2F-M0cMUoyvI_MfG0MCtpP%2F1-1581242308187.png?generation=1582298962096070\&alt=media)

### 核心层

​ ![](https://2471267620-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LfNyxSFSDaHeCRaQx74%2F-M0cMS9didzV-TDioQ9-%2F-M0cMUp4Qj8zgbvJr7iM%2F1-1581242354457.png?generation=1582298961340406\&alt=media)

### 存储引擎层

​ ![](https://2471267620-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LfNyxSFSDaHeCRaQx74%2F-M0cMS9didzV-TDioQ9-%2F-M0cMUp6W5YRy-m0X92A%2F1-1581242634333.png?generation=1582298962595346\&alt=media)

## 总图

​ ![](https://2471267620-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LfNyxSFSDaHeCRaQx74%2F-M0cMS9didzV-TDioQ9-%2F-M0cMUp8J7INOrX-IO0t%2F1-1581242670762.png?generation=1582298962787498\&alt=media)